Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks
I have provided a snip it of transactions from item details. I understand the W.A. calc when the PO is purchased and we have 9 more POs at $0 come in affecting the next two sales orders after to adjust out at $26 (260/10=26)
But I don't understand the last two transactions and where 32.5 and 110.66 came from?
On 8 April there was an inventory close / recalculation that might have an impact on those prices.
Also, what is the purchase price in the PO 145147?
Have you tried using the cost explorer that you can find in AX2012 for the item?
This explorer should give you some insights and explanations where those prices originate from.
PO145147 is a zero dollar PO. We don't use AX dynamics 2012 we still use 2009. This is what I found in cost explorer for the two sales orders at the end that I could not understand the calculation for. It isn't giving me much though?
Hi Cost accountant pdx,
It might take a while until we find the underlying issue but let's continue here.
Is your sales order ending 932 linked to the purchase order?
Can you please check the lot ids in the PO / SO lines?
Can you identify the prices that the cost explorer shows in your PO ending 147?
What is the price of 155 and what are the 16.06?
Has there some incorrect matching?
Some typing errors?
Can you share the setup of the item model group for the item used in the PO?
Question 1: The SO and PO are linked. However, the lot ID for the PO ( shown in pic 1) is different than what is showing for the SO shown in pic 2.
I can't understand where the 171.06 is coming from in the cost explorer. Nowhere on the PO states a $ amount and there is none listed on the item details. I don't know what calculation would've occurred from the inv recalculation that occurred bc nothing it coming out to the 171.06 based on past costs listed in the item details from above. The 16.06 shows as a vendor balance on the cost explorer. When I looked at settlements its showing up as an adjustment (shown below)
Question 3: The item model group for this item is IM1 - Average costing
Good morning Cost accountant pdx,
Many thanks for the screenprints.
I believe the second one that you shared in your last reply is the important one as it shows a marking.
Marking lines overrules what's done when running an inventory close / recalculation.
Can you please continue investigating the voucher and the transaction related to this marking line?
Business Applications communities