You’re offline. This is a read only version of the page.
I know how to create configuration package card in Rapid start in NAV 2015, but I am not sure which table ID to use for purchase order import. As there are quiet a few tables related to purchase.
Also I would like to know table ID for purchase invoices too.
We have a separate system that creates all purchase orders, and then our bookkeeper manually enter them into NAV, Thus we would like to import them through Rapid start function.
Will highly appreciate your help.
I looking forward hearing from an expert soon.
*This post is locked for comments
To me it looks like you are trying to create a purchase line that has a reference to the purchase order header that does not exist (perhaps, yet). It might be because you are trying to import lines before the headers, or because there is some error in the data and in the line there is some document no. value that is not in the header (e.g., some unneeded space or linebreak in the document no. in your file).
Hi Guys, Any help with below question please?
Looks like most of things are in shape now after spending many hours. However I am still getting one main error on purchase line in configuration package that is " The field document no. of table purchase line contains a value that cannot be found in the related table" and other type of error is " The purchase header does not exist. Identification fields and values; Document type-Invoice, No."
Any help will be highly appreciated please
Thanks everyone for your help.
Looks like most of things are in shape now after spending many hours. However I am still getting one main error on purchase line in configuration package that is " The field document no. of table purchase line contains a value that cannot be found in the related table" and other type of error is " The purchase header does not exist. Identification fields and values; Document type-Invoice, No."
Any help will be highly appreciated please
Hi
Uploading dimension in NAV 2015 is bit tricky and it work on combination and dimension set id.
If you using XMLPORT to upload the data then based on combination of dimension you need to write a code to find dimension id and that need to import in tables to get correct dimensions
You can look at the DimensionManagement codeunit as it contain one function called GetDimensionSetID
If combination not there then it will create dimension set id based on new combnation
If you directly uploaded the dimension then it may create mess in dimension .You need take help of developer/partner for the same.
Thanks Alexander,
Does it mean I need to tick Dimension set ID in header, and in excel file I need to add eight columns of dimension ID because we have got eight different dimensions.
Does the column heading should be Dimension set ID 1, Dimension set ID 2 etc?
Thanks,
Hamid
In the Purchase Header there are two fields for global dimensions - Shortcut Dimension 1 Code and Shortcut Dimension 2 Code. Also, there is a field Dimension Set ID, which represents the combination of all dimension values for your document. Read more here: msdn.microsoft.com/.../hh169155(v=nav.90).aspx
Thanks a lot
One more thing, I am unable to view dimensions in either table 38 or 39. Reading it online, I understand I have to select dimensions from development environment, but not sure how do I access that? Any help will be much appreciated?
Thanks,
Hamid
You need to import data in table no 38 and table no 39 to create purchase order
Once imported data you can post the Purchase order so the rest of table will get update automatically.
Thank you very much for your response. Just to clarify I need both lines, 38 for header selection and 39 for what to be added in purchase line?
For unposted purchases, there is 38 (Purchase Header) and 39 (Purchase Line) for both orders and invoices. There is a Document Type field that defines the type of the document: Quote, Order, Invoice, Credit Memo, Blanket Order, Return or Order.
For posted purchase orders (which I do not think you would need for the import), there are 120 (Purch. Rcpt. Header) and 121 (Purch. Rcpt. Line) for posted orders and 122 (Purch. Inv. Header) and 123 (Purch. Inv. Line) for posted invoices.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (