How to reconcile the Unvouchered Receipts report to the AP Accrual account in Microsoft Dynamics SL

This article describes how to reconcile the Accounts Payable Accrual (AP Accrual) account to the Unvouchered Receipts report in Purchasing in Microsoft Dynamics SL.

Applies to:   Microsoft Dynamics SL
Original KB number:   916506

Introduction

The article discusses the reasons that the total on the Detail General Ledger report doesn't match the total on the Unvouchered Receipts report.

How to reconcile the AP Accrual account to the Unvouchered Receipts report

To reconcile the AP Accrual account to the Unvouchered Receipts report, follow these steps:

  1. Print the Detail General Ledger report. To do it, follow these steps:

    1. In the Modules list, select General Ledger.
    2. In the General Ledger pane, select Detail General Ledger under Report. The Detail General Ledger (01.620.00) screen appears.
    3. In the Report Format box, select Standard.
    4. In the Beg Period box and in the End Period box, type the period number that corresponds to the period that you're trying to reconcile. Type the period number in the MM-YYYY format, where MM is the two-digit month and YYYY is the four-digit year.
    5. On the Select tab, specify the following settings: Field: vr_01620.accthist_acct
      Operator: Equal
      Value: AP Accrual account number
    6. Select Print.
  2. Print the Unvouchered Receipts report. To do it, follow these steps:

    1. In the Modules list, select Purchasing.
    2. In the Purchasing pane, select Unvouchered Receipts under Report. The Unvouchered Receipts (04.700.00) screen appears.
    3. In the Beg Period box and in the End Period box, type the same period number that you specified in step d under step 1. Type the period number in the MM-YYYY format, where MM is the two-digit month and YYYY is the four-digit year.
    4. Select Print.
  3. Compare the totals. The total in the Detail General Ledger report that you printed in step 1 should match the total in the Unvouchered Receipts report that you printed in step 2.

Reasons that the total in the Detail General Ledger report doesn't match the Unvouchered Receipts report

The total in the Detail General Ledger report doesn't match the total in the Unvouchered Receipts report when one or more of the following conditions are true:

  • You post items to the AP Accrual account that are outside the period range for which you run the report.

    The Unvouchered Receipts report is period-sensitive. So these items won't appear on the report.

  • You post transactions to the AP Accrual account that are outside the automatic postings.

  • Before you release the Accounts Payable voucher that you created from the Purchasing receipt, you change the AP Accrual account to a different account on the Accounts Payable voucher.

  • You have unposted transactions in the Post Transactions (01.520.00) screen from the Purchasing module or the Accounts Payable module.

    Note

    When you save and then release the Purchasing receipt, the receipt appears in the Unvouchered Receipts report. However, the Detail General Ledger report doesn't include the transaction until you update the account history for the AP Accrual account. The Post Transactions process updates the account history for the AP Accrual account when you post the transaction to the General Ledger.

More information

  • The Unvouchered Receipts report closely approximates an Accounts Payable aging report in the Purchasing module when you select Regular Order in the PO Type box in the Purchase Orders (04.250.00) screen.

  • Starting with Microsoft Business Solutions - Solomon 6.0 Service Pack 1 (SP1), the Unvouchered Receipts report is a period-sensitive report.

  • The following table shows the accounting flow for a regular purchase order.

    Type of Batch Debit Credit
    Purchasing receipt Inventory AP Accrual
    Accounts Payable voucher AP Accrual AP Trade
    Accounts Payable payment AP Trade Cash