web

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

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

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

Unanswered

GRNI data

(1) Share

Report

Report

Posted on by CS-04021000-0

47

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 (1)

Answers Img

Answers (0)

Suggested answer

OussamaSabbouh 4,878 on at

Like (1)

Report

GRNI data

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

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 3,477

#2

Jainam M. Kothari 3,235 Super User 2025 Season 2

#3

YUN ZHU 1,799 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans