Announcements
No record found.
Hi All,
In AX 2012, i am using at Item with WA costing method. Is there any possible way that my item cost price should automatically update in the sales order & purchase order.
Thanks in advance,
Gaurav Chandak.
*This post is locked for comments
I meant that unit price should be filled automatically with Item cost price in Sales order & purchase order.....
Hi Gaurav,
When you enter a purchase price in the PO, the cost price will be updated at the moment of invoice posting. If you have set on your item model group that also physical value should be included, this will also have the cost price updated in AX at the moment of posting your product receipt.
The cost price field on the sales order is important at the moment of a retuned item.
Otherwise an average cost price will be used for posting your packing slip. If no cost price is know at this moment, it is 0.
You have to run the inventory recalculation/closing regulary to have the correct cost prices updated on the inventory transactions. With this recalculation the WA costing method will be applied.
During e.g. a month a temporary average costprice will be used for issued item transactions. If you run the recalculation at the end of the month, the appropriate costing method will be applied. Note that your margin can show other figures after a recalculation.
Thanks André Arnaud de Calavon a ton for your descriptive answer. It helper alot.
Have a nice day & peaceful week ahead,
Kind Regards,
Gaurav Chandak
Hi Andre,
But in our case, the cost price is not showing or picking from the Item masters even though we can see the default price in Item master window. Do we need to do any more update to show item cost price in PO and Sales transactions. Please advice
Thanks
Hi Sreess,
I cannot fully understand your question. This post was about the weighted average. What inventory model are you using? When talking about PO and Sales transactions: do you mean the PO and sales lines or the related inventory transactions?
We have uploaded the opening product list with price in Ax 2012. But when we are doing any transaction in Adeaca (Advacned Project) related to these items, the cost price is not automatically showing there.
We are also having the issue of getting the item cost price to populate on Project Item journals in standard AX 2012 CU8. I assume I am missing a parameter or something. Were you able to resolve?
Thanks,
Corey
In Ax 2009.
In inventory management -->Journals -->item transaction -->movement, I was selected a record and printed that record ,in that cost price and cost amount is not displaying.
but few records are displaying these two fields.Can you please tell me why this is happening.is there any changes need in my inventory set up?
Hi Pallavi,
It depends on the quantity field. Negative quantity is not retrieving a cost price. Positive transactions are trying to get a cost price based on the item settings. If there is no known cost price, it will also be zero.
Thanks for your reply.I was checked the above mentioned solution. If there is any negative quantity it was printed with negative cost price and cost amount.Not at all problem with this.but some records are not showing negative or positive cost price and cost amount,these reports are showing these two fields at back end(select a record-->lines-->Inventory-->transactions).while coming to the lines and print-->journal these two fields are empty.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
