web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... GRNI data

Small and medium business | Business Central, N...

Suggested Answer

GRNI data

(3) Share

Report

Report

Posted on by CS-04021000-0

55

Hi all

I'm looking to see if I can extract GRNI data from the Business Central database , i know there's data available in the the purchase line table , however this does not match the GRNI download directly from the BC application. Any help appreciated!

Thanks

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

OussamaSabbouh 11,382 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

GRNI in BC = “Amount Received Not Invoiced (LCY)” on Purchase Line.

To match the GRNI report, only include purchase lines where:

Type = Item

Quantity Received > Quantity Invoiced

Amt. Rec. Not Invoiced (LCY) > 0

That’s the exact data the GRNI view is based on.

Regards,

Oussama Sabbouh

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,751 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi,

below purchase receipt lines page might help.

1 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,055 Super User 2026 Season 1

#2

YUN ZHU 1,063 Super User 2026 Season 1

#3

Dhiren Nagar 1,014 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans