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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Matching purchase invoice lines with purchase receipt lines using ODataV4

(1) ShareShare
ReportReport
Posted on by 38
Hello everyone,
 
We are developing a desktop application communicating with Microsoft Dynamics NAV version 13 (Business Central) and using ODataV4 web services. We need to create Purchase Invoices and for each line, specify which Purchase Receipt line they correspond to; i.e., three way matching. Similar to the functionality of Functions -> Get Receipt Lines which is available in the NAV UI for Purchase Invoices.
 
When using Page 6404 (Workflow Purchase Documents), I can see there is receiptNumber and receiptLineNumber fields which are populated when using the Get Receipt Lines functionality. However, I am unable to set these values during Purchase Invoice line creation, indicating these fields are read only. 
 
I tried many other page web services but have been unable to find a way to create Purchase Invoice lines and specify which Purchase receipt lines they refer to.
 
I was wondering is there any standard way for doing this or this requires customization?
 
Appreciate your response. 
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,729 Super User 2025 Season 2 on at
    Hi, the simplest way is to create a new page, make the fields editable, and then publish it in Odata. But this requires customization and a development license. 
    In addition, if you develop an API page, the performance will be much higher than that of web service.
    More details:
     
    Hope this helps.
    Thanks.
    ZHU
  • Amir Deris Profile Picture
    38 on at
    Thanks for the reply. Sounds good. We will follow the path to get developer license and customization to make this work. Appreciate your help.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans