Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Unit Costs

(0) ShareShare
ReportReport
Posted on by

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

  • 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.

  • 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,467 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans