I am trying to create a Crystal Report to show AP Invoices based on Invoice Date that went to a certain GL Account.
The GL Accounts I am trying to grab are in the range of 540000-000 to 540000-999.
This is what I have current Linking which I feel I have wrong:
I also have the following in Select Expert:
Thanks in advance for helping.
-Robert Z
If you're talking about already-posted invoices, then you need the AP_InvoiceHistoryHeader and AP_InvoiceHistoryDetail, not the files you're using.
Have you looked at the existing Sage Report on the AP Report Menu, called AP Expense by GL Account Report? Maybe you need to "save as", then add a run time selection for an Invoice Date, it appears to…
