Reservation Entry
Angelo
Member Posts: 180
Hello Guys,
I want to ask about reservation Entry table. for Source type = 37 (sales line) source subtype = 4, value of Quantity(Base) is Positif value but why sometime Quantity(base) is negative value for source type = 37 source subtype = 4? have you ever found this problem before?pls share....
Regards,
Angelo
I want to ask about reservation Entry table. for Source type = 37 (sales line) source subtype = 4, value of Quantity(Base) is Positif value but why sometime Quantity(base) is negative value for source type = 37 source subtype = 4? have you ever found this problem before?pls share....
Regards,
Angelo
0
Comments
-
Do you have negative qty on sales line?
Find the related sales line and see what special about it.0 -
You can have outgoing (Sales) & incoming (Sales Returns)...
From the Help...
Quantity (Base) Field
The Reservation Entry Table
This field contains the quantity of the item that has been reserved in the entry. This quantity is expressed in base units of measure.
Depending on whether the item is supply or demand, the value in this field can be positive or negative. In the case of a demand, for example a sales order, the value will be negative.NAV - Norton Anti Virus
ERP Consultant (not just Navision) & Navision challenger0 -
Well if subtype is 4, then Document type is "Order".
So they must have negative qty on sales order.0 -
Hmmm Source Subtype=4... ..wouldn't that make it a Blanket order?? Wait though... ..you don't track blanket orders ??
Have a look at the reservation entries again. Is there not a matching Positive entry for your negative one?
For example, a negative on the sales line (Source Type=37) and a positive on the item ledger (Source Type=32) for the same item/lot/serial?0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
