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

Posting Considerations   P.O. 000039-00

 

Posting P.O. Receiving:                    DR Inventory                        $720.00

                                                       CR Rec Accrual                        720.00

 

Posting A/P Voucher                        DR Rec Accrual                   $720.00

                                                      CR Accts Payable                     720.00           

 

If Invoice had come in at $750.00

 

Posting A/P Voucher                        DR Rec Accrual                   $720.00

                                                      DR PPV                                      30.00

                                                      CR Accts Payable                     750.00           

                                         

Reporting

 

The Reporting Function is accessed from:

Elliot Main Menu à Distribution à Purchase Order & Receiving à Processing à Reconciliation Processing à Report

 

 

What makes this feature powerful is that it provides detailed reporting to reconcile the ending balance in the G/L receiving accrual account.  This function gives you the option to print three reports: 1.  Outstanding Report, 2.  Date by Date Report, and 3.  History Report.

 

1.   Outstanding Report: This report should be run at the end of the accounting period.  The report will list all Receivings that have not been invoiced and Invoices that have not been received, and compare the net balance to the GL Receiving Accrual Account.  This report is generated from the A/P and P/O Account Reconciliation Files. 

 

2.   Date by Date Report: This report should be run when the Outstanding Report net balance does not match the GL Receiving Accrual Account balance.  This report compares the subledger net changes with the G/L Accrual Account and isolates any discrepancies on a day by day basis.

 

If the net changes for a day match, that day will be skipped.  If net changes do not match, the report will print the subledger detail and the G/L Accrual Account detail for that day.  By isolating discrepancies to a day, it then becomes relatively easy to identify where the problems come from, e.g., someone updates the G/L Accrual Acct, but not from A/P or P/O.  This report is generated from the A/P and P/O Reconciliation Files, and the GL Transaction File.

3.       History Report: This is exactly like the Outstanding Report.  The difference is that it is generated from the history files: APRCNHS and PORCNHS.  These two history files are updated when you purge the A/P and the P/O Account Reconciliation files.

 

Oustanding Report

 

This report items from the AP Reconciliation File and the P/O Reconciliation File.  At the time of printing, you have the option to report fully reconciled items.   When you purge these files, only the reconciled items get purged by a cut-off date.

 

The report is in four sections:

 

            1.         Unapplied A/P

            2.         Outstanding P/O

            3.         Fully Applied P/O

            4.         Grand Total (Net Balance)

 


Section 1:    Unapplied A/P

                                               

These are A/P invoices posted against prepaid Purchase Orders or those P/O’s or line items that have net been received yet.  When the P/O lines are received, they will be reported as Outstanding P/O line items in Section 2.  To reconcile the P/O line items just received against the Unapplied A/P’s, you must go to Reconciliation Processing Menu, Processing Sub Menu Re-apply.  After this has been done, the posted voucher and posted line items will appear in Section 3, Fully Applied Purchase Order line items.

 

 

Section 2:        Outstanding P/O Line Items

 

This reports items from the P/O Reconciliation file and these line items are P/O line items that have been received but not vouchered in A/P.

 

  

Section 3:        Fully Applied P/O Line Items

 

This report lists the P/O line items matched up, (reconciled) to the corresponding A/P voucher.  If one P/O line item had two receivings, it would appear twice and each with it’s corresponding A/P voucher.  This is also the information, (reconciled items), that gets purged when you run the Purge function.

 

 

 

Section 4:        Grand Total (Net Balance)

 

This is the last page of the Outstanding Report and reports the difference between Unapplied A/P transactions and outstanding P/O line items.

 

 

 

 

Grand Total:      A Debit balance indicates there are more unapplied A/P transactions than P/O line item receivings.  A Credit Balance indicates more posted receivings than posted vouchers for line items in A/P. 

 

In addition to Prepaid Purchase Orders and line items posted before P/O Receiving, a Debit balance can also occur when you post an A/P voucher without processing it against the P.O. Receiving.  This also another good reason why you should reconcile at Month End.

 

A zero balance will indicate that all the P/O receivings have been matched up to an A/P voucher and that there are no Unapplied A/P transactions. 

 


Remember:

 

P/O Receivings:                   DR Inventory                              CR Accrual Account

 

A/P Vouchers                      DR Accrual Account                   CR Accounts Payable

                        DR Purchase Price Variance (PPV)

 

 

Day By Day Report

 

 

This report groups and isolates all transactions on a Date By Date reporting basis, thus making it easier to find transactions that do not match up. 

 

 

 

Purchase Order

  1. Why Receiving Non-Inventory Items in PO Will Cause General Ledger Inventory Account Out of Balance?
  2. Order Has Been Printed But Not Posted
  3. When does the Purchase Line History data get updated?
  4. Can I Edit the Ship Date Field in PO Line Item Screen?
  5. Getting PO Lock File Problem During PO Printing
  6. Feature - Notes Tracking from PO Warehouse Receiving to Inventory Transfer Management to Inventory Transaction
  7. Feature - Prevent MM Item from Purchasing
  8. Feature - Include Or Exclude UDC in Buyer's Desk
  9. Feature - Item Number Verification After Serial Number Scan
  10. PO05S1 Purchase Order and Receiving Receivings Audit Trail Report
  11. PO05S2 Purchase Order and Receiving Drop Shipment Receivings Report
  12. PO0104 Purchase Order and Receiving Release Blanket Orders
  13. PO0105 Purchase Order and Receiving Purge Closed Purchase Orders
  14. PO0200 Purchase Order and Receiving Print Purchase Orders
  15. PO0300 Purchase Order and Receiving Purchase Order Inquiry
  16. PO0400 Purchase Order and Receiving Scheduled Receipts Reports
  17. PO0600 Purchase Order and Receiving Purchase Line History Report
  18. PO0700 Purchase Order and Receiving Cash Requirements Projection Report
  19. PO0800 Purchase Order and Receiving Commodity Code Vendor Report
  20. PO0900M Purchase Order and Receiving Vendor Performance Analysis Report
  21. PO1000 Purchase Order and Receiving P/O Setup
  22. PO1101 Purchase Order and Receiving Buyer Code File Maintenance
  23. PO1201 Purchase Order and Receiving Comment Code File Maintenance
  24. PO1301 Purchase Order and Receiving Reject Reason Code File Maintenance
  25. PO1401 Purchase Order and Receiving Ship-To File Maintenance
  26. PO1501 Purchase Order and Receiving Item Vendor File Maintenance
  27. PO1502 Purchase Order and Receiving Purge Item Vendor File Maintenance
  28. PO1601 Purchase Order and Receiving Vendor Service Address
  29. PO1700 Purchase Order and Receiving Clear Year-to-Date Statistics
  30. PO1800 Purchase Order and Receiving Open Purchase Orders Reports
  31. POCLSMNU Purchase Order and Receiving PO Close Processing
  32. POIMPMNU Purchase Order and Receiving Purchase Order Import
  33. POINVMNU Purchase Order and Receiving Invoice Processing
  34. POORDEXS Purchase Order and Receiving Purchase Order Export
  35. POEQMNT Purchase Order and Receiving Purchase Order Requisition
  36. POREQPST Purchase Order and Receiving Post Requisitions
  37. PORSTSCN Purchase Order and Receiving Reset P/O Rec/Inv Qty
  38. POUPDSTA Purchase Order and Receiving Update Vendor Statistics
  39. POWHRMNT Purchase Order and Receiving Warehouse Recovery Process
  40. POWRIMNT Purchase Order and Receiving Warehouse Receiving Import
  41. Feature -- PO Ship-to File Maintenance Determine Drop Ship Location by State/Zip Code Tables
  42. Feature - Warehouse Receiving Serial Number Validation
  43. Feature - Buyer's Desk Inventory Class Selection Criteria
  44. Feature - PO Ship-To File Received to Transit Location
  45. Purchase Order Line Item Add or Change Event
  46. PO0000 Purchase Order and Receiving Overview 1
  47. PO0000 Purchase Order and Receiving Overview 2
  48. PO0000 Purchase Order and Receiving Overview 3
  49. PO0000 Purchase Order and Receiving Overview 4
  50. PO0000 Purchase Order and Receiving Overview 5
  51. PO0000 Purchase Order and Receiving Overview : Index
  52. PO0100 P/O and Receiving Purchase Order Processing 1
  53. PO0100 P/O and Receiving Purchase Order Processing 2
  54. PO0100 P/O and Receiving Purchase Order Processing 3
  55. PO0100 P/O and Receiving Purchase Order Processing 4
  56. PO0100 P/O and Receiving Purchase Order Processing 5
  57. PO0100 P/O and Receiving Purchase Order Processing: Index
  58. PO2000 P/O and Receiving Receivings Processing 1
  59. PO2000 P/O and Receiving Receivings Processing 2
  60. PO2000 P/O and Receiving Receivings Processing 3
  61. PO2000 P/O and Receiving Receivings Processing 4
  62. PO2000 P/O and Receiving Receivings Processing 5
  63. PO2000 P/O and Receiving Receivings Processing 6
  64. PO2000 P/O and Receiving Receivings Processing 7
  65. PO2000 P/O and Receiving Receivings Processing 8
  66. PO2000 P/O and Receiving Receivings Processing 9
  67. PO2000 P/O and Receiving Receivings Processing: Index
  68. POFRMMNT P/O and Receiving P/O Form Setup 1
  69. POFRMMNT P/O and Receiving P/O Form Setup 2
  70. POFRMMNT P/O and Receiving P/O Form Setup 3
  71. POFRMMNT P/O and Receiving P/O Form Setup 4
  72. POFRMMNT P/O and Receiving P/O Form Setup 5
  73. POFRMMNT P/O and Receiving P/O Form Setup: Index
  74. PORCNMNU P/O and Receiving P/O Reconciliation Process 1
  75. PORCNMNU P/O and Receiving P/O Reconciliation Process 2
  76. PORCNMNU P/O and Receiving P/O Reconciliation Process 3
  77. PORCNMNU P/O and Receiving P/O Reconciliation Process: Index
  78. How to Retrieve Open Purchase Orders Through SQL SELECT Statement
  79. Feature - Receivings Processing Mass Receiving Changes
  80. Feature - Warehouse Receiving Mass Receiving
  81. How to Remove Outstanding PO from Received Not Invoiced Report
  82. Feature - Add Events for Addition of PO Header and Line
  83. Feature - Allow to Enter Unit Cost in PO Warehouse Receiving Add Mode
  84. Feature - Ability to Create a CSV Export in PO Edit List When "Show Headers Only" = "Y"
  85. Feature - Added PO by Comment Code List to the Schedule Receipts Reports
  86. Feature - Support Negative PO Line Item Unit Cost
  87. Feature - Added F4=Revision Option to PO Inquiry Drill Down
  88. Feature - Add Serial Number Support to PO Warehouse Receiving Import
  89. Multiple Users Print Purchase Orders at the Same Time
  90. Feature - F1 Key Next Manual Check Support in Invoice Processing

Feedback and Knowledge Base