Re:JDEdwards Reports

Haynal

Member
Re:JDEdwards Reports

Hi all

I am currently working on Financial reports say for example Customer/Supplier Balance Report (R7404002). The report extracts data from table F74412, however I would like to know how the table is being populated so as to be able to create my own test data. Can anyone help on this matter?

Thanks
 
Re:JDEdwards Reports

Hi Haynal,

The supplier and customer balance reports are based on information in the Customer/Supplier Balance Worktable (A/P and A/R) table (F74412). You must build the table using the Generate Supplier Balance program (R7404001) and the Generate Customer Balance program (R7403B001) before you run the customer and supplier balance reports.
The initial balance is calculated as of one day prior to the date specified in the Date From processing options for the Generate Supplier Balance and Generate Customer Balance
programs.

Hope it helps.
 
Back
Top