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

Article ID: 916506 - View products that this article applies to.
Expand all | Collapse all

On This Page

INTRODUCTION

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

The article also discusses the reasons that the total on the Detail General Ledger report does not match the total on the Unvouchered Receipts report.

MORE INFORMATION

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 this, follow these steps:
    1. In the Modules list, click General Ledger.
    2. In the General Ledger pane, click 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 are 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. Click Print.
  2. Print the Unvouchered Receipts report. To do this, follow these steps:
    1. In the Modules list, click Purchasing.
    2. In the Purchasing pane, click 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 1d. Type the period number in the MM-YYYY format, where MM is the two-digit month and YYYY is the four-digit year.
    4. Click Print.
  3. Compare the totals. The total on the Detail General Ledger report that you printed in step 1 should match the total on the Unvouchered Receipts report that you printed in step 2.

Reasons that the total on the Detail General Ledger report does not match the total on the Unvouchered Receipts report

The total on the Detail General Ledger report does not match the total on 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. Therefore, these items will not 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 on the Unvouchered Receipts report. However, the Detail General Ledger report does not 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.
Notes
  • 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.
    Collapse this tableExpand this table
    Type of BatchDebitCredit
    Purchasing receiptInventoryAP Accrual
    Accounts Payable voucherAP AccrualAP Trade
    Accounts Payable paymentAP TradeCash

Properties

Article ID: 916506 - Last Review: July 28, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Dynamics SL 2011
  • Microsoft Dynamics SL 7.0
  • Microsoft Dynamics SL 6.5, when used with:
    • Accounts Payable
    • Purchasing
Keywords: 
kbmbsmigrate kbsurveynew KB916506

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com