• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

AP270 Report

 6 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member
Posts: 490
Veteran Member
2/10/2015 1:51 PM
Hello, I am looking for the information on the AP270, if possible to get the cost center and the expense account, which table should I pull from?

Any help would be great.

jjcyeshua
Veteran Member
Posts: 49
Veteran Member
2/10/2015 10:01 PM
Most of the info on the AP270 is in APDISTRIB and APPAYMENT.
Chesca
Veteran Member
Posts: 490
Veteran Member
3/9/2015 2:42 PM
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
Bob Canham
Veteran Member
Posts: 217
Veteran Member
3/9/2015 2:51 PM
DIS Account Unit is the cost center, and DSC Account is the expense account number
Chesca
Veteran Member
Posts: 490
Veteran Member
3/9/2015 3:13 PM
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.
Bob Canham
Veteran Member
Posts: 217
Veteran Member
3/9/2015 3:21 PM
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.
Chesca
Veteran Member
Posts: 490
Veteran Member
3/9/2015 4:36 PM
Bob, thank you so much for your quick response! I will go ahead and code it to pull from the APDISTRIB.