AP270 Report

Most of the info on the AP270 is in APDISTRIB and APPAYMENT.

Which of the fields reports the actual expense account and cost center? Is there a different between the DSC account and the DIS account unit?

DSC account
DIS account unit

DIS Account Unit is the cost center, and DSC Account is the expense account number

Barb, so that means I would have get the cost center (DIS-ACCT-UNIT) from the APDISTRIB file and the Account number (DSC-ACCOUNT) from the APPAYMENT file, right?

Often times our users are asked for all the payments that were made to a vendor and they want to know what cost center and expense account as well and that is currently not on that report.

Whoops, sorry, I didn't look at that close enough. DSC-ACCOUNT in APPAYMENT has to do with the bank account (i think it is your bank account). You want to pull DIS-ACCOUNT from the APDISTRIB table to get the expense account.

Bob, thank you so much for your quick response! I will go ahead and code it to pull from the APDISTRIB.