SAP MM: Change of material moving average price after goods receipt and invoice verification posting for PO
SAP MM: Change of material moving average price after goods receipt and invoice verification posting for PO
This blog is based on the SAP system of S4HANA 1909 version. The system environment activates the retail industry solution, and the displayed materials use the moving average price as their price control.
1,The PO 4500000807.
The net price of material is 2 EUR per EA.
Suppose we just have one purchase surcharge, the customs duty, and its rate is 10%.
The inital MAP (moving average price) is 1.95 EUR,
Initial stock 400 EA,initial stock amount is 780 EUR, see above screen.
2,Exeucte the transaction code MIGO to do GR for this PO.
Save it, then the material document 5000000794 generated.
Check the finance document of this material document,
Dr:Raw material 220
Cr:GR/IR 200
Cr:Customers clearing MM 20
It can be seen that the customs duty of 20 EUR has been included in the cost of materials.
3, Execute the transaction code MM43 to observe the MAP of article master.
You can see that the MAP has been updated by SAP system. The new MAP is 2 EUR, see above screen.
Click the button “Material price analysis”, get below screen:
Before GR, the MAP is 1.95 EUR, stock quantity is 400, the stock value is 780 EUR.
The MAP after this time GR =(the stock value before GR + receipt stock value)/(the stock quantity before this time GR + the GR quantity) =(780+ 2.2*100)/(400+100)=1000/500 = 2 EUR/EA.
4,Execute the transaction code MIRO to do invoice verification.
4.1,First let me post the invoice for the materials. The price of invoice is 2.5 EUR/EA (in PO the price is 2 EUR/EA).
Save it,
The invoice document generated. Now go to see the MAP in article master,
You can see the MAP was updated again, the new MAP is 2.1 EUR/EA. Because the invoice price is 0.5 EUR bigger than the PO price, after invoice posting, the stock value increased 50 EUR (0.5*100), the total quantity is 500 EA. Then the MAP=1050/500=2.1 EUR.
See the material price analysis result,
4.2, The invoice for the customs duty. We suppose that the rate of customs duty is not the same as the rate I maintained in PO document,the rate is 5%, not 10%.
Save it,
Another invoice document generated successfully.
Now check the MAP in article master data again,
The new MAP is 2.08 EUR, see above screen. Check the material price analysis result,
Because the customs amount was deducted 10 EUR, so the stock value was changed from 1050 EUR to1040 EUR. The stock quantity is 500 EA, then the MAP = 1040/500=2.08 EUR.
So far, the verification of the purchase order invoice has been completed. At this time, the cost price of the material is the latest and most real cost price.
See the purchase order history,
In this scenario, the material and customs duty invoice prices are different from the prices in the purchase order, so the moving average price of the material will be updated automatically after the invoice is posted.
相关文章
- DataTables warning: table id=dataTable - Requested unknown parameter 'acceptId' for row 0. For more
- SAP Connector for Microsoft .NET
- C#【多线程篇】Parallel.For和for的效率比较(Paralle.Foreach和foreach比较类似)
- SAP 异常现象之同一个IDoc可以被POST两次触发2张不同的物料凭证
- SAP QM初阶之检验批系统状态中的CTCM该如何消除?
- SAP RETAIL The same code for Site Master & BP & Customer
- SAP MM 史上最偷懒的盘点事务代码MI10
- SAP RETAIL 如何确定自动补货触发的单据类型 III
- SAP RETAIL Plant Group里的特性
- SAP MM MIGO界面里的'Via Delivery'选项
- SAP SD 基础知识之Cash Sales和Rush Order的区别
- SAP SD 基础知识之行项目类别(Item Category)
- SAP MM ME81N PO Value Analysis报表中Net Value 为负数是怎么回事?
- SAP MM PIR里的Lower Limit & Upper Limit
- SAP教程之 Sap S/4HANA的未来是什么?它会取代 SAP ABAP 吗?
- 浅析Nginx配置获取客户端真实IP的proxy_set_header、X-Real-IP、$remote_addr、X-Forwarded-For、$proxy_add_x_forwarded_for分别是什么意思
- SAP HR工资配置项1---工资计算周期配置
- BI--SAP BI的权限管理