Invoice Select by Period

[jaredlim]

How do I create an Invoice History Report and searching by period?

 

[dfeller]

If you want to use the default one in MAS, you'll find it under Accounts Receivable, Reports.

If you want to create a report, you'll use the invoice history data files.

In 4.10 or 4.20 those are:

AR_InvoiceHistoryHeader
AR_InvoiceHistoryDetail

Dawn

 

[jaredlim]

I need to create a AP report. And I used the AP_InvoiceHistoryHeader and AP_InVoiceHistoryDetail.
But when I try to get the amount from the Detail table, I onlt got some and it doesn't show all. If I try to use AP_InvoiceHistory, it will take a long time to process or show me Not Responding. So, any solutions?

 

[dfeller]

Are you using any other tables?

Dawn

 

[jaredlim]

Yes. APB_CheckHistory, API_InvoiceHistory and AP1_VendorMaster.

 

[dfeller]

I think you are using far too many tables. You only need the invoice history tables and maybe the vendor tables. How are you linking those tables? (The APB and API are unnecessary.)

If you are on 4.10 or lower, the tables are AP_12 and AP_13.

Dawn

 

[jaredlim]

I've tried to use table AP_12 and AP_13.
But the amount of each invoice is different. It doesn't show the amount of invoiced. Is that any way I can show it?