You’re offline. This is a read only version of the page.
31
Hello,
I tried creating a webservice using page object for Purchase Invoice. as per the dev environment, Purchase Invoice page id is 51, so created a webservice using this object and published it. Then I tried building a SSIS package to extract data from external source and import to NAV 2017. I am using Kingswaysoft SSIS Integration Toolkit for Microsoft Dynamics 365 to import the data into NAV. I am able to see the object and map respective fields for purchase invoice webservice created above. However when the process is run, it is inserting the data into Purchase Header table, not into Purchase Invoice table. I don't know what I am doing wrong here?
Anybody has faced similar issue? I have attached the screenshots for reference.
Thanks in advance for the help.
[View:/cfs-file/__key/communityserver-discussions-components-files/34/PurchaseInvoice-Webservice.xml]
Thanks
Shree
*This post is locked for comments
Even this is a little late, maybe this is helping you or anyone else to find a solution. It is about that the subpage need to have the keyfields included, that you can add it by code. The subform page (Line part) usually have the "document No." and "Document Type" not included. You can add this in the dev.env and make it invisible. Read here for more ...
I cannot pass document number for the invoice line API as it throws the error "Detailed Message: Field Document No. is readonly! " And if I don't pass the value, I get the message - Detailed Message: Document No. must have a value in Purchase Line: Document Type=Invoice, Document No.=, Line No.=0. It cannot be zero or empty. )
So I am unable to use Lines API (using page webservice for object id 55).
For Purchase Line, what fields are you specifying? did you specify the document no. on the line to match the Purchase Header No. Try to check if you have any purchase lines without document no.
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
