Adjusted AP Invoices

SOLVED

Posted By [email protected] 3 months ago

Is it possible to create either a Crystal report or VI export job to show a list of AP invoices that were adjusted over a certain period of time? I'm having trouble distinguishing between original invoices and adjustments when looking in DFDM, other than a different header sequence number. Thanks in advance.

Top Replies

Kevin M 3 months ago +1 verified

If you are looking for recent data only, try AP_TransactionPaymentHistory's type "A" records. This table contains the data shown in the lower grid on Vendor Maintenance's Invoices tab.…

+1 Kevin M 3 months ago

verified answer

If you are looking for recent data only, try AP_TransactionPaymentHistory's type "A" records. This table contains the data shown in the lower grid on Vendor Maintenance's Invoices tab.
Cancel
Vote Up +1 Vote Down

Reply

Reject Answer

Cancel
0 [email protected] 3 months ago in reply to Kevin M

Thanks, Kevin! Would the past 12 months be considered recent data? That's how far back my client would like to go on the report/export.
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel
0 Kevin M 3 months ago in reply to [email protected]

The timeline is determined by the AP Options for retaining Open Invoice data. (In older versions it is a "days" setting, instead of months).
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel
0 [email protected] 3 months ago in reply to Kevin M

Got it. Thank you so much for your input!
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel

Adjusted AP Invoices

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING