Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Commodity Pricing Wrong Calculation

Posted on by 160

I have a product P8000 Frozen Concentrate Orange Juice - 12 FL Oz (355 ml) which contain it P6000 pure orange juice extracted, item P6000 contain item M6008 oranges

7802.1.jpg

I configured commodity pricing template for item P8000 and item P6000

3527.2.jpg

And I configured pricing for M6008 Oranges item (Raw material) cost to be 2.6, The inventory value is .61

6763.3.jpg

Finally, I run the create price and margin data, then view the result

 

For item P6000 AX Calculate the price of oranges base on commodity price 2.6

1665.4.jpg

M6008 orange juice extracted( contain M6008 Oranges in formula line) 1872/720=2.6

 

For item P8000 Frozen Concentrate Orange Juice which contain the M6008 Orange juice extracted it calculate the price based on inventory value not the commodity value

1464.5.jpg

 

M6008 Cost 4.96/8.1= 0.61 the inventory value not commodity price 2.6

So the calculation for sub-BOM will not be calculated based on commodity price? Please any solution so that AX will calculated the sub-BOM based on commodity price.

 

I used demo data for company USP2 for this simulation

 

 

 

 

 

*This post is locked for comments

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans