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. 
  • Amir Deris Profile Picture
    38 on at
    Matching purchase invoice lines with purchase receipt lines using ODataV4
    Thanks for the reply. Sounds good. We will follow the path to get developer license and customization to make this work. Appreciate your help.
  • Suggested answer
    YUN ZHU Profile Picture
    79,097 Super User 2025 Season 1 on at
    Matching purchase invoice lines with purchase receipt lines using ODataV4
    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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,207 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans