Dynamics Community Forum Thread Details

How to Retrieve Your Reference column on Posted Purchase Documents using OData V4

Hello everyone,

I am working on a desktop application in .NET (C#) that interacts with OData V4 endpoints of Dynamics NAV version 2018.

I am creating an Unposted Purchase Invoice using the Page 6404 (Workflow Purchase Documents). There is a field called Your Reference which I use to store some unique ID that helps us track the document when posted and creating payments for it. The Your Reference field is not directly shown to user in NAV Role Tailored Client; however, it can be seen by using the Help -> About this Page -> Table Columns section.

I can see when invoice is posted, the Your Reference field remains the same which would serve our purpose. But I have issue retrieving that column from any of the default pages of Dynamics NAV OData V4 endpoints for posted documents. I have tried:

Object Type, Object ID, Object Name

Page, 188, Posted Documents without incoming documents

Page, 138, Posted Purchase Invoice

Page, 146, Posted Purchase Invoices,

Query, 130, Posted Docs. With No Inc. Doc.

I was wondering is that field available on any default endpoint, or does it need development in Dynamics NAV to expose that column? Thanks for your help

Quick Links

Leaderboard