web
You’re offline. This is a read only version of the page.
close
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) / Negative open inventor...
Microsoft Dynamics NAV (Archived)

Negative open inventory items

(0) ShareShare
ReportReport
Posted on by Sunny2014 2

Hi All,

We have a client who is going to switch to NAV2013R2 shortly. When we work on importing open inventory balance per item, there are two items which donot have on-hand quantity but their legacy system (Quickbooks) has negative inventory value (negative quantity x unit cost) for those two items.

According to the clients, due to some reason, the inventory QTY of those two items were adjusted previously. As a result,  inventory quantities shows negative number since then.

Since we are required to migrate all open inventory balance including the two negative inventory items, we tried to use both positive adjustment with negative quantity and negative adjustment with positive quantity using item journal. Nevertheless, both item journal adjustments do not work to complete posting due to the error "You have insufficient quantity of item xxxx on inventory"

The client does not use warehouse module, lot number, serial number tracking and bin feature as well. So, their inventory feature usage in NAV is very simple and limited. Does anyone have an idea how we can fix this issue?

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,243 Super User 2025 Season 2 on at

    Sunny,

    Since you have a negative qty, you need to use Positive Adjustment with +ve quantity, the type will define what type of transaction it is, you don't need to adjust the quantity to positive or negative. Since you are using Positive Adjustment with -ve quantity which is a negative adjustment or vice versa you are getting the above error.

    Do the Positive adjustment with +ve quantity which will make the inventory to zero.

  • Sunny2014 Profile Picture
    Sunny2014 2 on at

    Hi Suresh,

    Thank you for your post. Actually, in NAV, there is no on-hand quantity because we are working to import all open balance transactions in order for the client to start using NAV in two days. So, technically, there is not on-hand quantities for all items. The rest of the items which the client provided us shows positive quantities so that we can easily migrate using positive adjustment with positive number in the quantity field at item journal entry window.

    The questions I posted above is only the case that two items which has negative quantity and we have to migrate into the brand new company where does not have on-hand quantity. We removed the option of "Prevent negative quantity" in the inventory setup window (Departments/Administration/Application Setup/Warehouse/Inventory/Inventory Setup), and tried to post item journal using positive adjustment with negative quantity, but still does not work.

    Have you experienced to migrate negative inventory items when you implement NAV to new client? If so, how did you fix the issue which I encounter now?

    Please advise.

  • Verified answer
    Sunny2014 Profile Picture
    Sunny2014 2 on at

    Hi all,

    I figured out to fix this issue. In item card, there is also "Prevent Negative Inventory" configured as "Yes" because this setting is based on inventory setup. But on each item card, we can temporarily remove this setting then I was able to migrate negative inventory quantity and value into brand new company.

    Suresh,

    Thank you for your suggestion as well.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans