Share
ReportHi Folks,
Can some one help me to understand how can the Cost amount be calculated for a record in Inventory transactions form.
You’re offline. This is a read only version of the page.
Hi Folks,
Can some one help me to understand how can the Cost amount be calculated for a record in Inventory transactions form.
Hello,
The cost amount for the Inventory Issue is automatically calculated.
Depending on whether we are using LIFO/ FIFO / Weighted avg. adjustments will be made at the time of running the Inventory close procedure.
By default when an issue transaction is posted, the cost price is updated by the Average Cost price.
For E.G:- We are using the FIFO model.
1) Made PO of Item "XYZ" 1 qty @ price 10.
2) MAde PO of Item "XYZ" 1 qty @ price 20.
3) Made SO of Item "XYZ" -1 THe price would be -15 ( System would issue by the average price [10+20]/2.
4) We run the Inventory closing.
5) As we are using the FIFO model, the cost price of the sales transaction would be updated to -10.
Thanks, Kaushik
This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.
P.S:- Please mark the answer as verified if it has helped in resolving the issue.
Hi,
This depends on the valuation principle that you have defined for your items in the item model group such as FIFO, LIFO, etc.
You can find some information here:
henrikmarxlarsen.wordpress.com/.../
Best regards,
Ludwig
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
