Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Item Journal with Nega...
Microsoft Dynamics NAV (Archived)

Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

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

We created an item journal for a non-bin controlled location - on the item journal we are adjusting two items - one is a positive adjustment and the other is a negative adjustment.

We are zeroing out the inventory for this item COWM2431 - which has 1 pc but we need to adjust it out to zero.

On the Item Journal - for item No. COWM2431 - on the entry type we put in Negative Adjustment and the quantity is 1 but when we post the item journal - on the item ledger entries we are seeing the quantity posted as 1 instead of -1. But the entry type is negative adjustment.

What could have cause this one? Is it because we have both positive and negative adjustment on the item journal?

How to fix this issue ? Right now our inventory is increase by 1 pc due to this entry , now we have 2 pcs.

When I did a test in my testing database, it seems to be working fine with the item journal having a negative adjustment entry type.

*This post is locked for comments

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    Yes, that should work if there are no modifications in the system.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    That is what I did. That is why I know that we put in a 1 under the negative entry type.

    I am wondering what else could cause this if there is no mode on the codeunit 22

    To fix this issue, I am thinking of doing an Item Journal with a negative entry type for quantity of 1 to fix the original item journal that causes the issue. Then create another item journal to zero out the inventory by using the negative entry type for quantity of 1.

    Will this work?

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    I am not sure what you mean, if you want to view the ledger entries then go to the item card - > History -> Entries - Item Ledger Entries

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    Is there a way to check to see what was done on the item journal - when I did a navigate I saw a 1 on the item journal.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    We put the quantity in item journal as 1 with negative adjustment entry type.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    Did you put the quantity in item journal as 1 or -1 ? you can do positive adjustment with -1 or negative adjustment with 1

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    There are two items on the item journal - Item A is a positive adjustment and the item COWM2431 is a negative adjustment.

    The issue is that when we posted the Item Journal COWM2431 is not treated as a negative quantity but a positive quantity even though it is a negative adjustment.

    We did not make any changes in the Codeunit 22.

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,749 on at
    RE: Item Journal with Negative Adjustment Entry Type but posted a Positive Quantity instead of Negative Quantity

    If you want to zero out the inventory you just need to do the negative adjustment why do you have +ve and -ve on the item journal and please verify if you there are any changes made to the codeunit 22, because when you post -ve adjustment with quantity 1 it should show as -1 in the item ledger entries, unless there is a bug in one of the customizations made.

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,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans