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

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

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

• 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.

• 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