How to import data

Navi_Learner · 2007-01-05

Hi, I read some reference regarding import and it still doesn't work for me. I created a new field Quantity to a table in Navision. In my text file, I have Order No, and Quantity(only two fields to be imported to the system on condiction that the sales order is the same). I set up the Dataport field with the two fields (Order No, Quantity). I tired to test two records in the text file and import them to the system, but nothing is imported. What's my problem? Thanks!

Savatage · 2007-01-05

if it's like a regular sales order and you want to import lines.

the lines have to have at least
Example Dataport Fields

SourceExpr
"Document Type" (like:Order, Invoice, Credit Memo)
"Document No." (Must match the Header Doc No)
Type (Like: Item, G/L Account, etc)
"Line No." (Note every item has to have a different line no!!!!!!)
"No." (your item or account#)
Quantity (How Many)

Don't forget to Validate your item #

Now this doesn't include how to do the header. Are you createing a header Manually & importing lines into it?

Note: there are many posts about Dataports and how to find the dataports chapter in the Application Designers Guide. It's always best to read up on these before "trying stuff" you'll find alot of time will be saved.

Tip: If you're importing records into Sales Line Table (for example) check the Primary Key on the Sales Line Table to see what fields are mandatory to have.

How to import data

Comments

Categories