User Tools

Site Tools


faq:inventory_reconciliation

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
faq:inventory_reconciliation [2013/04/25 14:02 (11 years ago)] clifffaq:inventory_reconciliation [2014/11/14 10:10 (10 years ago)] – [What not to change] cliff
Line 15: Line 15:
 So what happens if you change a PO line, an inventory value line on a bill, or a line on an invoice? The answer is you break things, and can no longer reconcile. If you follow proper processes things should reconcile unless you change things after the fact. The one exception to note is overselling. If you oversell on an invoice you oversell at standard cost. When you receive the product at cost other than standard, there is now an outage in the system. In order to fix this issue you have to go back to all invoices that were oversold and change the cost on them to the amounts from the PO line(s) that would have filled them. So what happens if you change a PO line, an inventory value line on a bill, or a line on an invoice? The answer is you break things, and can no longer reconcile. If you follow proper processes things should reconcile unless you change things after the fact. The one exception to note is overselling. If you oversell on an invoice you oversell at standard cost. When you receive the product at cost other than standard, there is now an outage in the system. In order to fix this issue you have to go back to all invoices that were oversold and change the cost on them to the amounts from the PO line(s) that would have filled them.
  
-So what kind of things can cause problems if you change them after the fact? If you change either side of the PO to Bill, or PO to Invoice process you will be out of reconciliation. So editing cost or quantity of a PO line, editing cost or quantity of an invoice line, or changing the amount on the inventory line of a bill after the fact will cause problems. Manual adjustments effect the sub-ledger totals so we need to place manual adjustments in the list of things that break reconciliation. So why do manual adjustments break the system? Ans: because every manual adjustment has to have a corresponding GL adjustment of equivalent dollar value. Here is a list of some things not to do: +So what kind of things can cause problems if you change them after the fact? If you change either side of the PO to Bill, or PO to Invoice process you will be out of reconciliation. So editing cost or quantity of a PO line, editing cost or quantity of an invoice line, or changing the amount on the inventory line of a bill after the fact will cause problems. Manual adjustments effect the sub-ledger totals so we need to place manual adjustments in the list of things that break reconciliation. So why do manual adjustments break the system? Ans: because every manual adjustment has to have a corresponding GL adjustment of equivalent dollar value. 
-  * Change the cost on an invoice line +
-  * Change the cost or quantity on a PO line +
-  * Change the Inventory Value posting on a bill +
-  * Oversell an item on an invoice +
-  * Make a manual adjustment without a corresponding GL entry to that hits the inventory value for the same amount+
  
 +  * Here are some key points:
 +    * Do not change the cost on an invoice line
 +    * Do not change the cost or quantity on a PO line after PO is completed
 +    * Do not change the Inventory Value posting on a bill
 +    * Do not oversell an item on an invoice
 +    * Do not make a manual adjustment without a corresponding GL entry to that hits the inventory value for the same amount
  
 ===== Process Suggestions ===== ===== Process Suggestions =====
faq/inventory_reconciliation.txt · Last modified: 2021/09/03 16:50 (3 years ago) by jbalasabas