same Posted Shipment and Invoice No. series.

181deepak
Member Posts: 95
Hi Experts.
(Nav 2013 R2 )I have made 3 pages for SO, that is one for job work, export and Domestic SO. and 3 Different Posted Invoice no. series for each type of SO. Depending of Type of SO I get Posted Invoice no. series automatically.
but now I also want same posted shipment and invoice no. series (because there always be ship and Invoice) for this 2 method:-
1) I need to make three no. series for posted shipment also that I do with Posted invoice. (Not Favorable)
2) That I want is- how and where I can do on Table 36 that my Shipment no. is = Posting no. (Invoice).
please give suggestion.
(Nav 2013 R2 )I have made 3 pages for SO, that is one for job work, export and Domestic SO. and 3 Different Posted Invoice no. series for each type of SO. Depending of Type of SO I get Posted Invoice no. series automatically.
but now I also want same posted shipment and invoice no. series (because there always be ship and Invoice) for this 2 method:-
1) I need to make three no. series for posted shipment also that I do with Posted invoice. (Not Favorable)
2) That I want is- how and where I can do on Table 36 that my Shipment no. is = Posting no. (Invoice).
please give suggestion.
0
Comments
-
Well, normally the whole point of no. series is that you can only use a number once. You could try to override that behavior but I would really not recommend it. Having the same document number for a shipment and invoice, making both turn up at Navigation - this is really just so un-Navisionic that it could cause unforeseen problems.
Just do this. Make an invoice number field on the shipment header and during posting save the invoice number there. It will be basically a secondary number. Then you can use this field for listing, sorting, finding shipments, you can also print it on the delivery note report, whatever. You simply tell people to not look at the actual shipment number, to simply ignore it, blend it out.0 -
Just as Miklos suggests, I would suggest the same. Do not use the same no. for shipments and invoices for these reasons:
When working with goods, there is always a chance a shipment cannot be done at once, and as a consequence multiple shipments have been made for 1 invoice.
When working with services, the value of the shipment document is diminished to next to nothing. And then it shouldn't matter what number the shipment document has. (It actually rarely has any accounting value).
However, if you really really really want to do this. (Pls check with a accountant to see if there are no legal consequences of eventual problems when using the same number (holes in numbers for invoices are frowned upon here)), you can always use fields 63 and 64 in table 36 . When they have a value, the no. series is not called upon during posting.
Nevertheless, I would suggest to not do that, and not make a problem out of it.0 -
Thanks for your Valuable reply.. =D>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