Dear All,
Good morning,
I would like to get the weighted average cost price for every single item in the purchase & sales separably.
If you found, please share it here.
Best regards,
Hem
*This post is locked for comments
Assuming that you are using one of the actual costing methods (set on the Item Model Group), except for Moving average, you will find that the current running average cost price for each item can be seen on the 'On-hand' tab of the 'On-hand' inquiry form.
For the item, look at the storage and tracking dimensions. Make a note which have 'financial inventory' ticked.
On the On-hand inquiry, use Dimensions Display to enable only the dimensions which have 'financial inventory' ticked (plus any relevant product dimensions).
Then, when you click on any record in the inquiry, you can switch to the 'On-hand' tab. At the bottom of the form, the 'cost price' shows the current running average cost.
Is that what you want?
Dear Guy Terry,
Thanks for reply.
I knew the place where you pointed here.
Assume, I purchased 5 quantities of Product A from the vendor with the unit price of 10 dollars each. On the On-hand inquiry, physical inventory is 5 quantity & the physical cost amount 50 dollars, then the cost price (weighted average cost) is 10 dollar. I issued the complete product A to the customer. when I come back to On-hand inventory form for the product A, I can see the cost price is zero instead to see the cost price is 10 dollar.
I would like to see the cost price 10 dollar even the product A is sold out entirely (for the analysis of forthcoming purchasing). Guide me to get the issue will be resolved soon.
Dear Hem Shankar,
I think you can use latest cost price check mark in item master data. It will show you the last cost price purchased. In your case it will show you $10.
Otherwise cost in inventory overview will be zero if there is no stock.
Regards,
Prashant
Dear Guy Terry & Prashant,
Thanks to explained about the latest price scenario for the purchase with this impact of receipt.
Thanks & regards,
Hi Hem,
The tick-box Prashant suggested will update the 'Cost price' on the item record each time a receipt transaction is financially updated. In other words, each time you post a purchase order invoice for an item (which has 'Use latest cost price' ticked), AX will put this cost (which comes from the PO Invoice) onto the item record.
It will not retrospectively put a cost on the item record; if you want to see it do something, you need to post the PO Invoice after you have ticked it.
However, 'receipts' are not just created by Purchase orders. Other types of receipt include Posting a positive inventory adjustment journal, Receiving a Transfer order, Crediting a customer return. All of these things will also update the 'Cost price' on the item record.
I'm not 100% sure what you're after, but this might not be it.
If you want to see the cost that was used when you sold an item, you can look on the Inventory transaction related to the Sales order line ('Cost amount' field). The Cost amount field will show the running average price that applied when the Sales order was invoiced, and after you run Inventory close (or Inventory recalculation), that price will be updated according to the Weighted average model (it will be updated so that all the sales in that period have the same cost price).
For a history of your selling cost prices, you could use the Inventory transaction inquiry (Inventory management -> Inquiries -> Transactions -> Transactions) and filter by the Item, Type = Sales order and Issue status = Invoiced, Delivered.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 4
Nayyar Siddiqi 2
Guy Terry 2 Moderator
