Hello All.
I am trying to import new purchase lines into an existing purchase order with the configuration package.
I am using the excel spreadsheet to import my file.
I am getting an error that the item i am trying to import cannot be found.
(The field No. of table Purchase Line contains a value (Item) that cannot be found in the related table (Standard Text).)
Is there another method or field i can use so Nav can recognise that what i am importing is a new line and will also create the Line No for the Purchase line.
Thanks.
Hi,
Replying about your second query that can Line No automatically created every time you import purchase line. If document is not created using Page then you need to specify Line No. Otherwise it will not create the next line.
Regards,
bilal
Document Type and No. and Vendor No. when import Purchase Header
We must give value to line No. when import
Hello Josh.
Would there be a way for a Line No. to be automatically created every time I upload a new purchase line?
That seems to be the last piece of the puzzle.
Thanks
Yes this worked perfectly, Thanks for your help.
Would you also have the fields required to create a New Purchase order?
I understand this would be under a new table header.
Yes I am using a BC screenshot but the idea is identical to NAV 2016. You can alter the related table:
In your case you need to review the columns used in your Excel file as it seems you have "No." and "Type" values mixed around. If you get the order correct you might not even need to change the related table.
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156