web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Issue with Purchase In...
Microsoft Dynamics NAV (Archived)

Issue with Purchase Invoice Webservice

(0) ShareShare
ReportReport
Posted on by ShreeIT 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]NAV-Page-List.PNGNAV-Webservice.PNGSSIS-to-Import-Data-into-NAV.PNGNAV-Data-in-PO-table-not-in-PO-Invoice.PNG

Thanks

Shree

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,237 Super User 2025 Season 2 on at
    RE: Issue with Purchase Invoice Webservice

    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.

  • ShreeIT Profile Picture
    ShreeIT 31 on at
    RE: Issue with Purchase Invoice Webservice

    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).

  • Suggested answer
    Ideeah_Studio Profile Picture
    Ideeah_Studio 5 on at
    RE: Issue with Purchase Invoice Webservice

    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 ...

    forum.mibuso.com/.../odata-add-purchase-invoice-line

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Alexander Ermakov Profile Picture

Alexander Ermakov 2

#2
SC666 Profile Picture

SC666 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans