You’re offline. This is a read only version of the page.
Hi all,
I have the following transactions:
I used to Weighted Average Method, but Cost Price unequal. Can you explain for me. I performed Inventory Closing.
Thanks for you help!
*This post is locked for comments
Hi Tham,
Where did you export this Excel list from? Probably the Financial cost amount on its own is not telling the whole story. You also need to consider any Adjustment that Inventory close has made.
Hi Tham,
You need to check settlement against the line that has date of 3/31/2018. In your screenshot, we didn't see the settlement. We just assumed that transaction (row 1 / 2) are kind of settled together (Looking at screenshot again, doesn't look like row 2 is settled yet (no settled amount in there). Go back to inventory transaction and click on settlement and it will show you all transactions that got settled and the inventory close that may have settled row 1st may be close of 3/31/2018.
Hi Satish Panwar,
Can you explain why Financial Closed is 3/31/2018 when Financial date is 05/26/2017 (Inventory Closed at 05/31/2017)?
Please help me!
Thanks,
Hi Ludwig,
In the accounting period (05/2017), with Weighted average method, issue price unequal. This excel file, I filters with Financial date (05/2017). I don't know share excel file in the room.
In my award, Weighted average method- when closing adjust issue transaction to cost price in this period by site only.
Hello Tham,
Can you explain where exactly you see the 'unequal' cost price?
There are some lines not shown in the Excel because of the filters. What are those lines?
Would be great if you could explain in more detail where you see the issue with those transactions shared in the Excel document.
Many thanks and best regards,
Ludwig
Hi Tham,
Weighted average doesn't all cost prices will be equal. if you look at row 1 & 2, they seems to be settled together, prices are equal. Transaction 5/6 are both related to same quarantine order and have same price. row 9 is settled transaction, you need to look at what this is settled with, there is settled lot id that help identify which transaction is being settled together. There got to be other transactions as well that help fluctuate the cost price. Consider this scenario,
Purchase 1 at $10 and purchase 1 at $20. When sold it's out at $15. Average cost price $15
Purchase 1 at $5 and purchase 1 at $10. When sold it's out at $7.5. Average cost price $7.5
As you notice the price fluctuated based on what made the transaction. Looking at your cost, they look very good. More the transaction, there may be more variations.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (