31 Update the A/P Ledger

This chapter contains this topic:

31.1 Updating the A/P Ledger

Navigation

From Accounts Payable (G04), choose Automatic Payment Processing

From Automatic Payment Processing (G0413), choose Work with Payment Groups

Updating the A/P ledger creates transaction records of your payments and your payment register. You can update payments only if the next status of the payment group is UPD (update).

After you update the A/P ledger tables, you can post payments to the G/L. Alternatively; a processing option for Work with Payment Groups allows you to automatically submit payments for posting to G/L after updating the A/P ledger tables.

31.1.1 Before You Begin

  • Verify that all payments printed correctly. After you update the A/P ledger, you cannot reset payment processing. You must void the payments and begin the payment process again.

  • Review processed payments.

31.1.2 What Happens When You Update the A/P Ledger?

When you update the A/P ledger, the system:

  • Processes void payments

  • Changes the pay status of vouchers from payment in-process (#) to paid (P)

  • Prints a payment register

  • Copies payment information from the worktables to the A/P ledger tables:

    • A/P Ledger (F0411)

    • A/P Matching Document (F0413)

    • A/P Matching Document Detail (F0414)

  • Clears the worktables, F04571, F04572 and F04573

The following graphic shows how the system updates the A/P ledger and posts payments to the G/L.

Figure 31-1 Updating the A/P Ledger and Posting Payments to the G/L

Description of Figure 31-1 follows
Description of "Figure 31-1 Updating the A/P Ledger and Posting Payments to the G/L"

To update the A/P Ledger

On Work with Payment Groups

Figure 31-2 Work with Payment Groups screen

Description of Figure 31-2 follows
Description of "Figure 31-2 Work with Payment Groups screen"

  1. Follow the steps for reviewing payment groups.

    See Section 29.3, "Reviewing Payment Groups".

  2. Do one of the following for a payment group with a next status of UPD:

    • Choose Update for a single payment group

    • Choose Update All for all payment groups

31.1.3 What You Should Know About

Topic Description
Posting G/L detail records (F0911) and Account Balances (F0902) are updated when the payment batch is posted.
Supplier Payment Inquiry (P042004) Supplier Payment Inquiry (P042004) allows you to view payment records and the remittance information (vouchers that were paid by the payment). Processing options are available to select the format view and data to be preloaded upon inquiry.