Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Unit Costs

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

Our marketing team views the unit cost on the item card and the purchase price card to determine how to price our products. If they see a discrepancy ><$10, they send it to accounting to fix. We've had quite a few items with this large discrepancy. We're finding that the causes are: 1) the allocation of freight to the items, or 2) when the invoice was entered the costs billed were higher than what we have in NAV or 3)  the UOM entered on the PO in NAV was different than what's on the item card. Marketing needs us to update the unit costs with the correct cost if the item so they can price it correctly and I'm not sure how to fix. I know the unit cost on the item card is updated automatically, but is there a way to update NAV with the correct price? I think going forward prior to posting the invoices, any cost discrepancies should be forwarded to our Purchashing dept., but how do we correct the unit costs after posting? I'm a novice to NAV and Inventory so I apologize in advance for any misinformation or lack thereof. Also, I'm not sure if Marketing should even be looking at the item card to determine the price, so if anyone has any ideas on that as well please let me know. I think they should be given a report from Accounting or maybe there is something they can view in the Sales module instead of through Purchasing.

Any help is appreciated. Thank you so much.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unit Costs

    Thanks Tharanga!

    I need this information as I am not familiar with the Inventory Costing process. This will help me get a better understanding.

    Thanks again.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Unit Costs

    Hi mmv,

    We manually change the unit cost on the purchase order now. I think part of the reason is that our Purchasing dept. isn't updating the Purchase Price table with the most recent vendor costs.

    Thanks!

  • Suggested answer
    Tharanga Chandrasekara Profile Picture
    Tharanga Chandrasekara 23,116 on at
    RE: Unit Costs

    Refer this link for now : msdn.microsoft.com/.../hh169029(v=nav.70).aspx

    I will get back to you on this.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: Unit Costs

    Hi,

    You have a functionality to revalue the inventory through Revaluation Journals.

    If you are looking for updating the Unit Cost for a Particular Purchase, you may do the same while Invoicing a Purchase Order (I mean, you can manually change the Unit Cost at the Purchase Order) or by using Item Charges while making the Purchase Invoice separately (and allocate the charges to the respective Purchase Receipt).

    Best Regards,

    MMV

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! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans