Posted Sales Invoice via Webservice

aadams

I have published the page: 132 (Posted Sales Invoice) as a webservice. In c# I consume the service and perform the "Read" operation, which returns the sales invoice header. However, the data returned does not contain all of the data that is available on the page 132, namely the order no (table 112, field 44). Is there another page I should publish that would return this? Or is there a better way to do this?

Just for background, I'm reading the posted sales invoices from NAV (2009 r2) to update an external CRM, in which we use the order no to tie the two systems together.

aadams

Not sure if this was the best solution, but I was able to get the order no (and other bits that aren't exposed via webservice) by creating a new "card" type page based on the 112 table and including all fields. Then I published that page as a webservice instead of the built in 132 page.

I still welcome any suggestions as to how this "should" be accomplished.

julkifli33

aadams wrote:

I have published the page: 132 (Posted Sales Invoice) as a webservice. In c# I consume the service and perform the "Read" operation, which returns the sales invoice header. However, the data returned does not contain all of the data that is available on the page 132, namely the order no (table 112, field 44). Is there another page I should publish that would return this? Or is there a better way to do this?

Just for background, I'm reading the posted sales invoices from NAV (2009 r2) to update an external CRM, in which we use the order no to tie the two systems together.

have you showed the field in your pages?

aadams

Thanks for the reply.

Yes, the page shows the field. Its the built-in Posted Sales Invoice page (132), which when viewed shows the order no field on the general tab. Is that what you meant? I'm fairly new to NAV, so forgive me if I'm missing the obvious.

As I stated in my follow up post, when I created a new page based on the same table and publish it as a webservice the field comes over just fine. Not sure what the difference is or if that is the best way to solve it, but it worked.