955
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
Hi Andre,
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.
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.
Hi Andre,
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?
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
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?
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
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 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.
I meant that unit price should be filled automatically with Item cost price in Sales order & purchase order.....
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (