PORCNMNU P/O and Receiving P/O Reconciliation Process 1

P/O Reconciliation Process

Difference between On-Line Receiving and Batch Receiving

 

Before we talk about the purpose of this feature, we have to understand the difference between On-Line and Batch receiving.  The following table outlines the difference between these two receiving methods:

 

 

 

On-Line Receiving

Batch Receiving

P/O & I/M transactions

Once a transaction is entered, the inventory is update immediately.  Easy to use and less control.

Once transaction is entered, you can review and edit the data.  You will need to post transactions to update inventory.

Inventory Trx. Audit Trail Report

Show in audit trail format.

Show in inventory ledger format for all transactions that affect inventory quantity balance.  Great report!

I/M Distribution

No impact on I/M distribution

Dr. Inventory Account

Cr. Receiving Accrual Account

A/P vouchering when received a PO invoice

Cr. Accounts Payable

Dr. Inventory

Cr. Accounts Payable

Dr. Receiving Accrual Account

Month End Reconciliation

G/L Inventory balance will not match I/M Stock Status Report.  Therefore, you need to find all the receiving not invoice, or invoice not receiving transaction to reconcile G/L and Inventory sub-ledger.  This is a manual process and can be time consuming.

G/L Inventory balance should match I/M Stock Status Report.  However, there will be value in Receiving Accrual Account to reconcile at month end.  If you do not enable “Receiving Accrual Account Reconciliation” feature, there’s no easy way to reconcile.

G/L Financial Statement

G/L Inventory does not reflect your true inventory value.

Add “Receiving Accrual Account” to your Balance Sheet as a temporary liability account.

 

 

Application Overview

 

If you are using batch receiving in Purchase Order, posting PO receiving updates the General Ledger (via the GL Inventory Interface) by debiting inventory and crediting the receiving accrual account as a temporary liability account.  Without enabling this feature, there are no sub-ledger detail reports that could be used reconcile the ending balance in the G/L receiving accrual account.

 

The purpose of this feature is to provide a means of reconciliation for the P/O receiving accrual account.  For data accuracy and integrity, the Reconciliation Process should be done prior to your End of Month Reporting.  As a bonus, this feature will also speed up A/P voucher processing. 

 

If you are using on-line receiving method, there’s no need to enable this feature because there’s no such a concept as “Receiving Accrual Account” in on-line receiving process.  However, we do recommend most users to use batch receiving instead of on-line for the additional features and benefits of batch receiving process.

 

 

NOTE:  This use of this feature is controlled, (turned off and on), in Accounts Payable Global Setup.


Additional Files Used by This Feature:

 

Accounts Payable

 

1.   APRCNFIL - Receiving Account Reconciliation File. This file will be updated when posting AP Transactions.  Two reports will be generated from this file:  The Outstanding Report (similar to A/P Open Items), and The Date by Date Report.  We will discuss the purpose of these reports later in this document.   

2. APRCNHIS - Receiving Reconciliation History File.  This file    will be updated when you purge the APRCNFIL file.  The purpose of this file is to provide history information.  You can generate an Outstanding Report from this file. 

Purchase Order

 

1.   PORCNFIL - Receiving Account Reconciliation File.  This file will be updated after posting Receiving Transactions in P/O.  Two reports will be generated from this file: The Outstanding Report, and The Date by Date Report.

 

2.   PORCNHIS - Receiving Reconciliation History File.  This file will be updated when you purge the PORCNFIL file.  The purpose of this file is to provide history information.  You can generate an Outstanding Report from this file.

 

Setting Receiving Accrual Account in P/O Setup

 

Before we can begin using this feature, you will need to setup the Receivings Accrual Account.  Figure 2A.4 shows how to do this.  Field 16 under P/O setup is where you define the account.  In our example, we set this account to 02165-10000-00000.

 

 

     

 

Figure 2A.4 P/O Setup

 

 


Feedback and Knowledge Base