Importing serial number to the batch Item Traking Lines

Flashtn
Member Posts: 68
Good morning all,
I use Item Journal to enter items in inventory. When there are a lot of serial number, I must enter them one by one. It's very hard!!!
My question is : how can I import serial numbers of an item to the batch Item Traking Lines from EXCEL file ? Can I use the table Excel Buffer (ID 370) ?
Thank you in advance
I use Item Journal to enter items in inventory. When there are a lot of serial number, I must enter them one by one. It's very hard!!!
My question is : how can I import serial numbers of an item to the batch Item Traking Lines from EXCEL file ? Can I use the table Excel Buffer (ID 370) ?
Thank you in advance

0
Comments
-
Use Barcode readers. Manually enter serial numbers - to strong0
-
why not a dataport? :!:LR0
-
1)
In Excel:
Save As ... *.csv
(this type of text file is contains separators. The operator default value is ";", but this is depend on the operating system (for example Windows XP at the Regional Settings --> Numbers (List separator))
2)
Next, create a dataport, because it is more easier than other way. Or if you can import from Excel directly, it's better) :!:
Can you setup the properties in a dataport module?0 -
Yes, I can do dataport, but I want to know if i import data directley in this table (ID 370) or there are conditions ?0
-
Ther is one the most directly import:
for exapmle if the excel structure is the same as like tha table try select all in excel, copy, and paste to tha table
Some table it is works
But the dataport is the safeiest way0 -
you need to update the reservation entry table, item ledger entry and item tables whilst doing the dataport.
alternatively if you can provice your email id and i will email an object to import the file.0 -
The Item Ledger Entry table, Reservation Table and Item table are updated when I posted (validate) the lines in the form of Item Journal. Thus, there is no problem in this side.0
-
The Item Ledger Entry table, Reservation Table and Item table are updated when I posted (validate) the lines in the form of Item Journal. Thus, there is no problem in this side.0
-
there might be some other generic conditions that you need check
for example:
1) does the serial no. already exist in navision item ledger entry (ideally if you are importing that suggests a lot of s/numbers and it would be good if the client establishes duplicates before the dataport is imported, coz once it's imported its difficult to establish which one is the duplicate).
2) An exception report of the numbers that are not imported due any integrity issues.0 -
Just structure your dataport a little differently and you wont need to check for duplicate numbers.
Set the autoupdate and autosave to false on the dataport dataitem.
Set the fieldlist
On the afterimportrecord trigger have 2 journal records
lrJnl.init;
lrjnl.reset;
lrjnl.setcurrentkey("journal template name", "journal batch name", "line no.");
lrjnl.setrange("journal template name", ___________);
lrjnl.setrange("journal batch name", _____________);
if lrjnl.find('+') then
lrjnl2."line no." := lrjnl."line no." + 10000
else
lrjnl2."line no." := 10000;
then set the rest of the values for variable lrjnl2, using VALIDATES for any fields that lookup, then
lrjnl2.insert;
at the very end of the dataport put a commit;
Then you import to the journal not worrying about overwriting records or primary keys. You should NEVER write directly to posted (ledger) tables, this has amazing potential for disaster. Import to the journal, post manually; let the posting routine do it's job and put the data in the correct place.
-a0
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