Import transactions changes Last No. used

jackies
Member Posts: 114
Hi people 
We have a series of dataports for importing transactions with/without VAT and with/without balancing acc.
The dataports validate the last no. used of No. series to follow the sequence and give the next document no. However, eventhough we get the correct no. series this also changes the Last no. Used as if the transactions have been posted.
Example:
1. Last No. used: U100040
2. Imported 8 lines in General Journal that received No. series U100041-U100048
3. Last No. used: has changed to U100048 before posting the entries
4. As a result if I try to post the entries I get the message that the first Document No. must be U100049...
Please also note that we also use Posting No. series and this is not affected.
Thanks!

We have a series of dataports for importing transactions with/without VAT and with/without balancing acc.
The dataports validate the last no. used of No. series to follow the sequence and give the next document no. However, eventhough we get the correct no. series this also changes the Last no. Used as if the transactions have been posted.
Example:
1. Last No. used: U100040
2. Imported 8 lines in General Journal that received No. series U100041-U100048
3. Last No. used: has changed to U100048 before posting the entries
4. As a result if I try to post the entries I get the message that the first Document No. must be U100049...
Please also note that we also use Posting No. series and this is not affected.
Thanks!
0
Comments
-
Populate the Document no yourself and don't increment the numbering series?0
-
Well yes...if I'm doing the posting since I don't mind but..this is for all the users that want to simplify the processing.0
-
This is fixed
I realised that this piece of code was "missing"IF GenJournalBatch."Posting No. Series" <> '' THEN "Gen. Journal Line"."Posting No. Series" := GenJournalBatch."Posting No. Series";
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