Importing error in NAV_5.0

Business Central/NAV Developers Forum
1

Hi Everybody,

can someone help us? we are importing transaction entries such as invoices, receving, journals. We encountered the following errors:

  1. successful but no amounts are imported

2.The value ,G/L Account,Item,Fixed Asset,Charge (Item) for SELECTSTR parameter no. 2 is not valid.

  1. Quantity must not be 0 in Sales Line Document Type=‘Invoice’,Document No.=‘SIN-00013’,Line No.=‘40000’.

Please help.

Thanks

2

Hi Neil,

Welcome to the Dynamics User Group!

First of all - where (what tables) are you importing the infomation into?

And how are you importing?

I suspect you are not running any validates.

3

Hi,

Thank you for the reply.

We are importing invoices, receiving, official receipts and general journals. Our procedure as follows:

  1. Import the header

  2. import the lines

How do we validate?

Thanks

Neil

4

Hi Neil,

You can validate on import using a dataport/XMLport or import the data and write a report/codeunit to validate the data. I would suggest that you get an experience person to help who knows what fields need to be validated

5

Thanks. we have IT developers/programmers but have no experience in NAV. Can you suggest a site or resources (website link) for this data import?

6

You need to contact your Navision partner (the company that sold Navision to you) for help with this.