Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Item cost not populati...
Microsoft Dynamics NAV (Archived)

Item cost not populating on a negative adjustment

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I have been doing some testing of Positive and Negative adjustments to our stock using the item journal in Nav (we go live in July). On the positive adjustment it automatically pulls through the cost from the item card. However on a negative adjustment it doesn't - why is this and can this be made to do so?

In our current system a negative adjustment will automatically use the price from the stock value but a positive adjustment doesn't - surely this is the way round it should be but in Nav it seems to be the opposite?

Can someone help me please?

Selina

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost not populating on a negative adjustment

    This mean, you need to run the "Adjust Cost Item Entries" batch job on periodic basis. This will result into accurate inventory, even though you do not see any cost getting populated during Negative Adjustment.

    When you run the batch job, system will adjust the positive entry cost to your negative adjustment.

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost not populating on a negative adjustment

    It is currently set to never

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost not populating on a negative adjustment

    Can you check your Inventory Setup >  "Automatic Cost Adjustment"  field value? If it is always, you do no need to run this batch job.

    Otherwise, it is mandatory to run this batch job to have accurate inventory costing / COGS & related financials. You can check with your partner for further details.

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost not populating on a negative adjustment

    Hmm I'm very confused about this cost adjustment thing - we have not been told about this at all so I will speak to our partner.

    We do not manufacture so most of our products are not in stock/inventory - we order from a supplier and that supplier sends direct to the customer.

    However we do hold stock of some products in different locations we have across the country and so for these items we have the FIFO costing method set up.

    Thank you for your assistance

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost not populating on a negative adjustment

    This is very important batch job.  Ideally you should run this job on daily basis to have your accurate costing.

    If you do not wish to run this batch job, you need to setup "Inventory Setup" > "Automatic Cost Adjustment" to Always. However, please note that, this would affect the performance very badly and hence not recommended. Better you run the batch job manually on daily or weekly basis.

    Just to give you some idea..

    Let's assume you are having one Purchase at 10 USD per Qty. Later you do the negative adjustment, which will take the cost as 10 USD.

    Further, if you try to revalue your Purchase from 10 USD to 12 USD due to some Item Charge or price difference.

    So this batch job will pass the 2 USD difference to your negative entries as well.

    This is bit detailed topic and you should check with your partner Sr. consultant to understand this in much detail.

    You can get more details about this batch job at following link.

    msdn.microsoft.com/.../hh169387(v=nav.90).aspx

    Hope this helps.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost not populating on a negative adjustment

    What is the "Adjust cost item entries" job - when and why would we use this?

    We tend to do negative adjustments to write off out of date stock or any stock that is not present when we do the stock takes so yes there would always be available inventory.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item cost not populating on a negative adjustment

    Normally, In Item Journal > cost is getting populated from Item or SKU > Unit Cost field, except Standard Costing Method....

    So, logic is > For Positive Adjustment - Cost is getting populated from Item or SKU card. You can still have option to change the Unit Cost value before posting, if needed.

    For Negative Adjustment - Cost will still get populated from ITEM or SKU card, however the same will get adjusted as per actual costing of POSITIVE Item Entry line (If you are not using Standard Costing) as soon as you run "Adjust Cost Item Entries Batch" Job.

    This means, Unit Cost field has no relevance, when you post negative adjustment as it will get applied from the positive entry (Assuming You have Inventory Available for that Item).

    Hope this helps.

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,321 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans