Part-1: Handling of price differences between a product receipt and the invoice of PO
Moving average is an inventory evaluation method that reevaluates inventory value in the sequential order of posting transactions, and it can be used to compute the average cost of the current ending inventory.
When a receipt transactions are included sequentially in the moving average calculation, according to the order in which the transactions are recorded in the system.
When Issue transactions are assigned the current active moving average cost at the time of recording, and the costs on inventory issues do not change even if the purchase costs (price in vendor Invoice ) change.
When Issue transactions are assigned the current active moving average cost at the time of recording, and the costs on inventory issues do not change even if the purchase costs (price in vendor Invoice ) change.
Now, i am going to describe about setups of moving average prerequisites and then how we can Handling of price differences between a product receipt and the Vendor invoice.
1- Set up an item model group
1.1- Go to Inventory and warehouse management > Setup > Inventory > Item model groups.
1.2- Click New to create a new item model group for moving average.
1.3- On the Setup FastTab, these check boxes are selected by default:
- Stocked product
- Post physical inventory
- Post financial inventory
but in my case i have removed Physical Negative Inventory.
On the Inventory model Fast Tab, in the Inventory model field, select Moving average. The Include physical value check box is not available. However, when you apply moving average, physical transactions are always included in a cost calculation.
2- Posting types
Meanwhile expenses amounts and adjustments must be posted to General ledger. To distinguish the proportionally expenses amounts from other transactions in General ledger, two unique posting types have been introduced:
On the Inventory model Fast Tab, in the Inventory model field, select Moving average. The Include physical value check box is not available. However, when you apply moving average, physical transactions are always included in a cost calculation.
2- Posting types
Meanwhile expenses amounts and adjustments must be posted to General ledger. To distinguish the proportionally expenses amounts from other transactions in General ledger, two unique posting types have been introduced:
- Price difference for moving average
- Cost revaluation for moving average
For defining ledgers,
2.1- Go to Inventory and warehouse management > Setup > Posting > Posting.
2.2- On the Inventory tab, click Price difference for moving average, and then click Add. In the Main account field, select the main account to use.
2.3- Click Cost revaluation for moving average, and then repeat step 2.2 for this account type.
3- Set up Production control parameters.
3.1 Go to Production control--> Setup --> Production control parameters.
3.2 On the General tab, under Report as finished, select the Use estimated cost price check box. When this check box is selected, the estimated cost price is used rather than the cost that is registered on the product master.
3.3 Under Posting, select Post picking list in ledger and Post report as finished in ledger.
3.4. Under Estimation, select Price calculation.
4- Set up Product item model group.
4.1- Product information management > Common > Released products > edit item AX- 000005 and make sure to assign the moving average item model group to the item.
Scenario : Handling of price differences between a product receipt and the invoice.
If some of the items on a purchase order have been received and then sold, and there is a difference between the estimated cost of the purchase (Cost when the product receipt was posted) and the vendor invoice, the full difference between the invoiced amount and the receipt cannot be recognized as inventory cost. In this case, you need to expense the difference proportionally.
In this example, you post an invoice to a receipt, and there is a difference in price between the estimated price and the price that is actually charged for the product.
After some of the units of the purchase are sold and thus taken out of inventory again, the value of the inventory cannot be based on the full quantity of the purchase.
In this case, the difference between the estimated price and the actual price of the items that were taken out of inventory must be expended.
After some of the units of the purchase are sold and thus taken out of inventory again, the value of the inventory cannot be based on the full quantity of the purchase.
In this case, the difference between the estimated price and the actual price of the items that were taken out of inventory must be expended.
To perform the example follow the steps:
1- Go to Accounts payable > Common > Purchase orders > all purchase orders. then create new order to purchase five pieces of an item No AX- 000005
and enter an estimated price of 10.00 per unit. then confirm the Purchase order.
and enter an estimated price of 10.00 per unit. then confirm the Purchase order.
2. To receive the items go to receive tab then process the product receipt.
3. Go to Account receivables -->Common --> sales order --> all sales order
Now, we will create a Sales Order with 2 quantity of item AX-000005. So two quantities are taken out of inventory at the cost of 10.00 each. confirm the sales order then process the packing slip then post the invoice.
4. when you receive the invoice for the purchase order and discover that you are actually charged 12.00 per unit for the item AX-000005 , not 10.00 as was originally estimated.
5. to create the invoice go back to the purchase order> invoice tab > invoice, change the cost per unit from 10.00 to 12.00, and then post the invoice.
6.The additional cost of 2.00 per unit cannot be related to the sales order, because the sales order is already costed when you receive the invoice for the purchased items. Therefore, the system performs a proportional calculation, and the expense of 4.00 ([12.00 – 10.00] × 2 units) is posted in Price difference for moving average account that we defined earlier.
7- To view amounts that are posted on the Price difference for moving average account based on a proportional calculation go to the Invoice tab in the purchase order, click Invoice.
5. to create the invoice go back to the purchase order> invoice tab > invoice, change the cost per unit from 10.00 to 12.00, and then post the invoice.
6.The additional cost of 2.00 per unit cannot be related to the sales order, because the sales order is already costed when you receive the invoice for the purchased items. Therefore, the system performs a proportional calculation, and the expense of 4.00 ([12.00 – 10.00] × 2 units) is posted in Price difference for moving average account that we defined earlier.
7- To view amounts that are posted on the Price difference for moving average account based on a proportional calculation go to the Invoice tab in the purchase order, click Invoice.
8- In the Invoice journal form, click Voucher.
9. In the Voucher transactions form, in the Amount field, view the amount that is posted to the Price difference for moving average account.
Note: The remaining stock quantity ( 3 pcs ) cost will be updated to 12 when the product receipt voucher reversed and the vendor balance voucher registered.
- The Price difference for moving average account could be debited or credited depending on the difference between the receipt cost and the invoice cost.
