Field Ship/ Invoice in Sales Header

tro#1
Member Posts: 122
I just cannot find it - maybe somebody knows...
When do field:
Ship
Invoice
Shipping No. and
Posting No.
get filled in a sales header?
The number series for orders, posted shipments and posted invoices are different ones.
I have some orders in the system which have not been posted yet but do have above mentioned fields filled. There are some other orders where the fields are not filled. And I just cannot find out what the difference is. I changed the status, printed pick list and also tried to post them (with missing mandatory dimensions) but the fields do not fill.
When do field:
Ship
Invoice
Shipping No. and
Posting No.
get filled in a sales header?
The number series for orders, posted shipments and posted invoices are different ones.
I have some orders in the system which have not been posted yet but do have above mentioned fields filled. There are some other orders where the fields are not filled. And I just cannot find out what the difference is. I changed the status, printed pick list and also tried to post them (with missing mandatory dimensions) but the fields do not fill.
0
Comments
-
The Ship and Invoice boolean fields on the header are populated during posting:
When you make a shipment, Ship will be set=TRUE
When you post an invoice, Invoice will be set=TRUE
You will find the Shipping No. and Posting No. fields are generally blank.
During posting, a check is made to determine if they are blank - if so, then the relevant No. Series is used to generate the shipment and invoice nos etc.
If your implementation dictated, you could put these fields on screen (they're not by default), on the Sales Order form for example, and allow the user to enter these fields manually, where they will be used instead of a number from a series.0 -
The number series get called, I believe on creation of the header, so if they were not there at the start they were not in the setup at this point.
The ship Boolean is set to yes when one of the lines is shipped, not sure about the invoice one, when it is fully invoiced makes no sense as it will no longer be there!The art of teaching is clarity and the art of learning is to listen0 -
AdamRoue wrote:The number series get called, I believe on creation of the header, so if they were not there at the start they were not in the setup at this point.
The ship Boolean is set to yes when one of the lines is shipped, not sure about the invoice one, when it is fully invoiced makes no sense as it will no longer be there!
You could partially invoice something though, in which case Invoice will be set=TRUE.
They basically indicate that a Shipment has taken place and an invoice has been posted from that order.0 -
that boolean fields (ship, receive and invoice) are used posting routines in cu 80 internally. they dont mean anything in sales order because same order can be involved in different posting in different ways such as "get sipment lines" feature in invoice screen.You will find the Shipping No. and Posting No. fields are generally blank.
During posting, a check is made to determine if they are blank - if so, then the relevant No. Series is used to generate the shipment and invoice nos etc.
If your implementation dictated, you could put these fields on screen (they're not by default), on the Sales Order form for example, and allow the user to enter these fields manually, where they will be used instead of a number from a series.0 -
The confusing thing is:
The order I am looking at has not been posted at all. Neither shipped nor invoiced.
To recreate an example like this I even tried it with a new order. I chose a posting date which was not in the allowed range. I tried to post it. It aborted like wanted. I did the same with no "Quantity to ship" filled out. The order did not post at all. But "Ship" did not get changed to "Yes". It is still "No". The same if any mandatory dimensions are missing.
So obviously it must be something what happens later in CU80. But since I do not have a shipment CU80 must have aborted afterwards.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions