Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Cost Amount (Actual)

(0) ShareShare
ReportReport
Posted on by 4

Hi! 

Is there anyone in this forum that knows how Cost Amout (Actual) is calculated in Item Ledger Entries and can help me out? 

pastedimage1653896214905v1.png


The reason I ask is because I have a customer who experiences that there is a big difference between the calculated gross margin from the chart of accounts and the calculation made via Item Ledger Entries by including the Cost amount (Actual). This customer has NAV 2018, CU 08 (I coulnd't find the correct choice under 'Forum').

Cost amount (Actual) does not seem to be updated in a good way. This customer has a just-in-time flow on items that does not have large stocks. So when the price increases on these items it should take effect quite quickly but this does not happen. If we choose to update the unit cost on all lines when we complete a production order, only the latest purchase cost is updated, if you do the same run via the item table, the unit cost is updated immediately.

How can we ensure that the Cost amount (Actual) is correct so that this customer can do a follow up on which items that have a good margin and which items that have a bad margin?

Best regards. 
Eva



  • Verified answer
    Eva Profile Picture
    Eva 4 on at
    RE: Cost Amount (Actual)

    Thanks!

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    RE: Cost Amount (Actual)

    Hi,

    Can you please refer the below document? may be it help you

    probitas.co.uk/.../

    Thanks.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans