I need to build a report, but I am unable to understand what tables some information comes from I generally use ssrs for my reporting, but I would like to understand how I can produce a report like this inside NAV.
When I open the Posted Invoice Form under financial management from the navigation on the left I can find all the fields I am needing. (I am unable to find this form in the object designer)
Is there some way to use this form to create a report, since all the numbers are already displayed in this form?
This report will be an invoice aging report that have not been paid 0-30, 31-60,61-90, over 90 days
The fields required from posted sales invoice:
Sell-to Customer No.
Sell-to Customer Name
If I am on the record I click invoice, then invoice statistics
Total Incl Tax or (Balance due)
0-30, 31-60, 61-90, over 90 days date diff. from posting date → current date