Strange No. Series error
dleroux
Member Posts: 87
We have users on Nav4/SQL who are receiving the following error message with some regularity:
The Sales Header does not exist.
Document Type='Order', No.='SQ10145'
Document Type: Order, No.:SQ10145
This message occurs when they try to enter a new sales order (Hit F3 on the sales order card)
Now the SQ prefix tells me that for some reason Navision looked at the Sales Quote number series rather than the Sales Order number series. (This client does not use quotes at all - everything starts with the Sales Order)
Since it used the wrong number series, I can understand why it is unable to find the sales header (Doc Type 'Order'), but does anyone know how to prevent it from using the wrong No. Series in the first place? When they try a second time, they wind up with a "proper" sales order number and all is well.
The client has about 8 people entering new sales orders, but generally in the neighborhood of 100 orders per day.
The Sales Header does not exist.
Document Type='Order', No.='SQ10145'
Document Type: Order, No.:SQ10145
This message occurs when they try to enter a new sales order (Hit F3 on the sales order card)
Now the SQ prefix tells me that for some reason Navision looked at the Sales Quote number series rather than the Sales Order number series. (This client does not use quotes at all - everything starts with the Sales Order)
Since it used the wrong number series, I can understand why it is unable to find the sales header (Doc Type 'Order'), but does anyone know how to prevent it from using the wrong No. Series in the first place? When they try a second time, they wind up with a "proper" sales order number and all is well.
The client has about 8 people entering new sales orders, but generally in the neighborhood of 100 orders per day.
0
Comments
-
what about some filter? Sometime, the filters on the card (set by user or C/AL code) are problem...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
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 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
