Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K 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
- 273 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
Requisition Worksheet - Unexpected Surplus calculation
Stardust
Member Posts: 5
Hi everybody!
I am trying to use the Requisition Worksheet in Navision 3.70 with Replenishment System = Purchase, Manufacturing Policy = Make-to-Stock, Reordering Policy = Maximum Qty. All the other planning parameters (reorder point, maximum inventory, etc.) are set to zero. I don't use SKU.
I have noticed that for some reasons beyond my understanding, for each item Navision calculates a "Surplus", which is shown in the Order Tracking Window as "Untracked Quantity". This surplus is usually 10 to 50% of the tracked quantity, which is in fact the needed quantity. It seems to me that it is calculated somewhere in the codeunits 99000854 (Inventory Profile Offseting) and 99000830 (Create Reserv. Entry), but I wasn't able to pinpoint the exact location.
I have to mention that this is happening only for the items that have negative inventory.
Example:
Item 1 with Qty. on Inventory = -7800
After running the Requisition Worksheet, a new order for 11700 pcs is suggested. From the 11700 pcs, 7800 pcs are coming from the Item Ledger Entries, and the difference of 3900 pcs is coming from the "Surplus", or "Untracked Qty."
Can anyone give me a hint or a solution to this ennoying issue? ](*,) Without solving this issue, the Requisition Worksheet is almost useless, unless you do not convince the user to check and change manually the quantity for hundreds and thousands of items.
Thank you in advance!
I am trying to use the Requisition Worksheet in Navision 3.70 with Replenishment System = Purchase, Manufacturing Policy = Make-to-Stock, Reordering Policy = Maximum Qty. All the other planning parameters (reorder point, maximum inventory, etc.) are set to zero. I don't use SKU.
I have noticed that for some reasons beyond my understanding, for each item Navision calculates a "Surplus", which is shown in the Order Tracking Window as "Untracked Quantity". This surplus is usually 10 to 50% of the tracked quantity, which is in fact the needed quantity. It seems to me that it is calculated somewhere in the codeunits 99000854 (Inventory Profile Offseting) and 99000830 (Create Reserv. Entry), but I wasn't able to pinpoint the exact location.
I have to mention that this is happening only for the items that have negative inventory.
Example:
Item 1 with Qty. on Inventory = -7800
After running the Requisition Worksheet, a new order for 11700 pcs is suggested. From the 11700 pcs, 7800 pcs are coming from the Item Ledger Entries, and the difference of 3900 pcs is coming from the "Surplus", or "Untracked Qty."
Can anyone give me a hint or a solution to this ennoying issue? ](*,) Without solving this issue, the Requisition Worksheet is almost useless, unless you do not convince the user to check and change manually the quantity for hundreds and thousands of items.
Thank you in advance!
0
Comments