Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
How to stop Negative Inventory??
navuser1
Member Posts: 1,329
Hi All,
Is there any setup in Navision3.7 to stop the transactions which are going to create a negative inventory?
Is there any setup in Navision3.7 to stop the transactions which are going to create a negative inventory?
Now or Never
0
Comments
Deep
India
No Standard code in any version???
Deep
India
Use "Lot Tracking" on all items. The systems does not allow "Lot Tracked" items to go negative. You may need to re-think some of the business process to support this change.
If I want to put my code then where is write place in Codeunit 22 to check the same.
In which function of codeunit 22 I use to write my code.
That said, if you are the only one who can do it, there is a function in C22 called InsertItemLedgEntry. Be careful.
My Blog - nav.education
The function already does not allow negative inventory for consumption entries.
IF (((ItemLedgEntry."Entry Type" IN [ItemLedgEntry."Entry Type"::"Negative Adjmt.", ItemLedgEntry."Entry Type"::Consumption]) AND ("Source Type" = "Source Type"::Item)) OR (ItemLedgEntry."Entry Type" = ItemLedgEntry."Entry Type"::Transfer)) AND (ItemLedgEntry.Quantity < 0) THEN ERROR(Text005,ItemLedgEntry."Item No.");text005 is 'Item %1 is not on inventory.'
You add your own code below it.
//Mod Start if (ItemLedgEntry.Quantity < 0) THEN ERROR(Text005,ItemLedgEntry."Item No.");//Mod End[/code]Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I have choosen the right function.
And my code is
InvtSetup.GET;
Item.GET(ItemLedgEntry."Item No.");
Item.SETFILTER("Date Filter",'..%1', ItemJnlLine."Posting date");
Item.SETFILTER("Location Filter",'%1',ItemLedgEntry."Location Code");
Item.CALCFIELDS("Net Change");
IF NOT InvtSetup."Allow Neg. Invt." THEN
IF (Item."Net Change" + ItemLedgEntry.Quantity) < 0 THEN
ERROR(Text005A,Item."No.",ItemJnlLine."Posting Date");
Text005A =
The quantity in the Inventory is not sufficient to cover net change in the inventory
for Item No. %1 on date %2.';
One problem with your code is, what they are already negative on inventory?
They will get the error no matter what.
//Mod Start IF NOT InvtSetup."Allow Neg. Invt." THEN if (ItemLedgEntry.Quantity < 0) THEN ERROR(Text005,ItemLedgEntry."Item No."); //Mod EndPlus your code is slow. You are doing calculating a flow field for every entry.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Out of the box, you can enable warehouse management. This will prevent inventory from going negative.
Search the forum, there are a TON of discussions on this.
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book