window "invoice schedule" not shows records in Report
Description
the option Report of the window "invoice schedule" not shows records !!!
Environment
None
Attachments
4
Activity
Show:
Heng Sin Low April 27, 2013 at 7:05 AM
Patch to data engine committed.
Richard Morales Herrera March 8, 2013 at 10:12 PM
the attached suggested patch works without applying the migration script
Carlos Ruiz March 8, 2013 at 9:17 PM
Thanks Richard, can you please help me testing the attached suggested patch to solve this issue (without applying the migration script).
Carlos Ruiz March 7, 2013 at 4:57 AM
Richard found this is caused because the column c_invoiceschedule.invoiceweekday (based on list) is null on database, and marked as mandatory on dictionary.
The same can happen on any reference column that has nulls on database and is marked as mandatory on dictionary - that record will not be shown on reports.
The next query shows 52 records with the same problem (DB nullable - Dictionary mandatory):
Major
the option Report of the window "invoice schedule" not shows records !!!