Currently the Due Date table (GACCDUDATE) only has the creation date CREDAT and due date DUDDAT of the open item. It would make things substantially easier from a reporting perspective if the respective invoice date was also added to this table. Currently when you are reporting on AR you have to link SINVOICE to GACCDUDATE and when you are reporting on AP you have to link PINVOICE to GACCDUDATE, but if you want to report on open items in general (i.e. both AR and AP) you can't easily link GACCDUDATE simultaneously to both sources.

by: Kevin C. | over a year ago | Financials