Documentation >
MAC-PAC Technical Library >
Financial >
Accounts Payable >
Programs >
VAT Extract - Purpose
VAT Extract - Purpose
AP545L
The VAT Extract program (AP545L) prints the three different reports containing book code information. This program allows you to request the following four reports:
Accounts Payable Balance by Account (AP545A)
Accounts Payable Balance by Vendor (AP545B)
Accounts Payable Transaction by Account (AP545C)
Accounts Payable Transaction by Vendor (AP545D)
Two additional reports will be generated in a 198-character format: AP545C1 and AP545D1. These reports will includes the transaction amount in the original currency in addition to the bookkeeping amount. The data that was entered on the report request screen will also be printed on a report (AP545E).
In order for these reports to be generated, starting balances are required at the account/vendor level for each period. These balances will be stored on the Accounts Payable Period Balances by Account/Vendor file (APBALPP). Reference File category M14 will be used to determine which accounts have balances stored on this file in order to include them on the reports. When a transaction is posted in the Accounts Payable Distribution program (AP170E), the account will be checked against Reference File category M14. If it exists, the APBALPP file will be updated with the transaction amount. One record per period will be generated for each vendor within an account.
Optional selection criteria can be entered to restrict the amount of information printed on the report. The range of transactions processed by the Accounts Payable Balance/Transaction Reports Selection program can be limited by using the following user-specified parameters:
|
From Account
|
Only accounts created during or after this period will be processed.
|
|
Through Account
|
Only accounts created during or before this period will be processed.
|
|
From Vendor
|
Only vendors created during or after this period will be processed.
|
|
Through Vendor
|
Only vendors created during or before this period will be processed.
|
|
Suppress Zero Balances
|
Allows you to choose whether account/vendor lines with zero balances will be printed on the balance reports.
|
