Accounts Receivable Trade Accounts

Depending on whether the receipt fully pays the invoice, and whether the offset method is S or Y, the system reconciles entries differently. The system reconciles entries when:

  • • The offset method is S and a pay item for an invoice is paid in full by one or more receipts.

  • • The offset method is Y and an invoice is paid in full by one or more receipts where the total amount matches the invoice exactly.

    If an invoice is paid by multiple receipts and the offset method is Y, the system reconciles the entries when a receipt amount exactly matches the entire remaining amount of the invoice.

This table provides examples of how the R09150 reconciles AE entries in the accounts receivable trade accounts:

Invoices

Receipts

Offset Method S (offset per pay item)

Offset Method Y (offset per document)

1 invoice with 1 pay item (10,000.00 USD)

1 total receipt that pays invoice in full (10,000.00 USD)

All items reconciled.

All items reconciled.

1 invoice with 1 pay item (45,000.00 USD)

3 total receipts that pay invoice in full:

  • • 15,000.00 USD

  • • 15,000.00 USD

  • • 15,000.00 USD

All items reconciled.

All items reconciled.

1 invoice with 2 pay items

  • • 1: 2,400.00 USD

  • • 2: 7,000.00 USD

4 total receipts that paid both pay items in full:

  • • 1: 1,200.00 USD

  • • 2: 1,200.00 USD

  • • 3: 3,500.00 USD

  • • 4: 3,500.00 USD

All items reconciled.

All items reconciled.

1 invoice with 3 pay items:

  • • 1: 350.00 USD

  • • 2: 450.00 USD

  • • 3: 550.00 USD

2 total receipts that paid first 2 pay items with exact receipt amounts in full for each pay item:

  • • 1: 350.00 USD

  • • 2: 450.00 USD

Pay item 3 not paid.

Pay Items 1 and 2 reconciled.

Pay item 3 not reconciled.

No items reconciled.

2 invoices with 1 pay item each:

  • • 1: 18,000.00 USD

  • • 2: 22,000.00 USD

1 total receipt for 29,000.00 USD that pays invoice 1 in full and partially pays invoice 2 (18,000.00 applied to invoice 1 and 11,000.00 to invoice 2).

Invoice 1 reconciled.

Invoice 2 not reconciled.

No items reconciled. 29,000.00 USD doesn't match either invoice amount or the total of invoice 1 and 2.

1 invoice with one pay item for 1,000.00 USD

3 separate receipts:

  • • 1: 400.00 USD

  • • 2: 400.00 USD

  • • 3: 200.00 USD

All items reconciled.

All items reconciled.

1 invoice with one pay item for 1,000.00 USD

3 separate receipts:

  • • 1: 400.00 USD

  • • 2: 400.00 USD

  • • 3: 400.00 USD

All items reconciled.

No items reconciled because the total amount of 1,200.00 USD for all receipts does not match the invoice total of 1,000.00 USD.