4.2Supplier Master Batch Upload Report (R04010Z)

Use this program to access the processed address book records, retrieve the corresponding supplier information in the Supplier Master - Batch Upload table (F0401Z1) table, and upload it to the Supplier Master table (F0401).

Review the Supplier Master Batch Upload report (R04010Z):

4.3Store and Forward Voucher Batch Processor Report (R04110Z2)

Use this program to move the uploaded vouchers from the Voucher Transactions - Batch Upload table (F0411Z1) and the Journal Entry Transactions - Batch File (F0911Z1) tables to the Accounts Payable Ledger (F0411) and the Account Ledger (F0911) tables.

4.4Batch Voucher Processor Report (R04110ZA)

After your custom program loads the transaction information into the Voucher Transaction - Batch Upload (F0411Z1) and Journal Entry Transactions - Batch File (F0911Z1) tables, run this program to process the information in the F0411Z1 and F0911Z1 tables and load it into the Accounts Payable Ledger (F0411) and Account Ledger (F0911) tables.

4.19A/P Unrealized Gain/Loss Report (R04425)

4.20Currency Detail - Foreign and Domestic Report (R04427A)

On the Accounts Payable Reports menu (G0414), select Open A/P with Foreign Amounts program (P04427). On the Currency Open A/P Details form, select Currency Detail - Foreign and Domestic.

Use this report to print a detailed list of open accounts payable items with foreign currency amounts, based on the Accounts Payable Ledger table (F0411). If no foreign currency transactions exist, the system prints domestic amounts.

Review the Currency Detail - Foreign and Domestic report (R04427A):

4.21Currency Detail - Aging Report (R04427B)

On the Accounts Payable Reports (G0414), select Open A/P with Foreign Amounts program (P04427). On the Currency Open A/P Details form, select Currency Detail - Aging.

Use this report to print a detailed list of open accounts payable items with foreign currency amounts, based on the Accounts Payable Ledger table (F0411). If no foreign currency transactions exist, the system prints domestic amounts.

Review Currency Detail - Aging report (R04427B):

4.22Open A/P Detail w/Foreign Currency Aging Report (R04427C)

On the Accounts Payable Reports menu (G0414), select Open A/P with Foreign Amounts program (P04427). On the Currency Open A/P Details form, select Open A/P Detail w/Foreign Currency Aging.

Use this report to print a detailed list of open accounts payable items with foreign currency amounts, based on the Accounts Payable Ledger table (F0411).

4.25"As Of " Open A/P Detail w/ Foreign Currency Report (R04427F)

This report is identical to the Open A/P Detail w/Foreign Currency Aging report, except that it is based on the As Of" Accounts Payable Ledger table (F0411A). The as of date that is used for aging is the as of date associated with the F0411A record in the A/P 'As Of' Date table (F0490).

4.30Cash Requirements Report with Currency Aging Report (R04431A)

Use this report to determine how much money you need for payments and how much money you have in your bank accounts. The report lists vouchers by supplier in three aging columns, provides a total for each supplier and each bank account, and shows the total amount necessary to pay open vouchers.

4.32Create Payment Control Groups Report (R04570)

This program is a batch process that you run once for each payment cycle. The program typically creates multiple payment groups. Each payment group contains information that determines how the group is processed, such as bank account and payment instrument.

Review the Create Payment Control Groups report (R04570):

4.33Print Automatic Payments - Standard Format Report (R04572)

The system prints the Print Automatic Payments - Standard Format report when a standard check payment at write status (WRT) is updated to the Work with Payment Groups program (P04571).

4.40Calculate Withholding Report (R04580)

Calculates withholding amounts using the withholding percentage in the supplier master record.

Updates the pay status on the original voucher pay item from% (percentage) to the value that is designated in the processing options.

Creates a negative pay item for the withholding amount with the same payee, pay status, and due date as the original voucher pay item.

Creates a pay item for the withholding amount using the tax authority in the supplier master record.

Produces a report that either lists the new pay items and the pay status of each item or lists the vouchers that were not released for payment and the error that is associated with each voucher or pay item.

Review the Calculate Withholding report (R04580):

4.41Generate Positive Pay Text File Report (R04586)

At the end of each day, run this report to create the positive pay text file to submit to your bank. When you run this program, the system selects payment records from the Accounts Payable - Matching Document table (F0413) and populates the Text Processor Header table (F007101) and the Text Processor Detail table (F007111) with information from these payment records.

4.44A/P To G/L Integrity by Offset Account Report (R047001A)

On the Period End Processing menu (G0421), select A/P to G/L by Offset Account.

Use this report to compare posted, open amounts in the Accounts Payable Ledger table (F0411) to the balance in the offsetting A/P trade accounts in the Account Balances table (F0902).

Review the A/P To G/L Integrity by Offset Account report (R047001A):

4.45A/P To G/L Integrity Report By Batch Report (R04701)

On the Period End Processing menu (G0421), select A/P Orig Doc to G/L by Batch.

Use this report to verify that the gross amount of each batch in the Accounts Payable Ledger table (F0411) balance with the amounts in the corresponding batch in the Account Ledger table (F0911). This report also checks each pay item for an invalid pay status.

Review the A/P To G/L Integrity Report by Batch report (R04701):

4.46A/P Payments To G/L By Batch Report (R04702A)

On the Period End Processing menu (G0421), select A/P Payments to G/L by Batch.

Use this report to verify that each batch of payment amounts in the Accounts Payable Matching Document Detail table (F0414) is in balance with the corresponding batch of amounts in the Account Ledger table (F0911).

4.50Post Drafts Payable Report (R04803)

After a draft is paid and closed, use this program to post it to the general ledger. The system changes drafts with a pay status of # (draft selected) to P (draft paid). The system then generates and posts journal entries that debit drafts payable and credit the payables bank account, and prints a post report.