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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

GRNI report

(1) ShareShare
ReportReport
Posted on by 1,022
Hi all,
 
I'm looking for GRNI report.
 
What I can find is that we can use Purchase lines list page, and apply the filter on 'Amount received not invoice (LCY)'.
However, it is found that this amount includes VAT.
 
I don't think Finance will accept this since it includes VAT.
Where can I generate the GRNI report?
 
There is alternative in my mind --- Export all lines, and insert 2 column in the excel.
One is GRNI quantity = Quantity - Outstanding quantity
Another one is GRNI amount = GRNI quantity * Unit cost exclude VAT
 
I'm thinking if there is other way to achieve it.
 
Welcome to have any thought!
I have the same question (0)
  • Suggested answer
    Teagen Boll Profile Picture
    3,410 Super User 2026 Season 1 on at
    If you update the profile (role) you should be able to see two fields that get what you want:
    I noticed that the Amount Received Not Invoiced Excluding VAT isn't part of a standard role personalization change.

    You need to go to the Profiles (Roles) page and then update the role you have assigned (or other users have assigned) and add those fields to the Purchase Lines page.
     
    Best,
    Teagen Boll
    Social: LinkedIn
  • Suggested answer
    Grigorios Mavrogeorgis Profile Picture
    2,833 Super User 2026 Season 1 on at
    Hi,
    Actually the Purchase Lines page with 'Amt. Rcd. Not Invoiced (LCY)' is the standard approach Microsoft recommends for a GRNI overview, so you are on the right track there.
    About the VAT, that field is the amount received not invoiced in local currency and it is based on the line amount excluding VAT. If you are seeing something that looks like it includes VAT, check your Prices Including VAT setting on the purchase orders, because when this is ticked the Direct Unit Cost and Line Amount are shown with VAT, and that is what makes it look wrong. Untick it or use the amounts excluding VAT and the figure should be what Finance expect.
    If you want to reconcile with the G/L, this only works if you have Expected Cost Posting to G/L enabled in Inventory Setup, then the balance of the Invt. Accrual Acc. (Interim) should match. Without that setting there is nothing posted in the G/L to compare with.
    For a proper report I would build a small query on the purchase lines with the same filter, this is easier to maintain than the Excel export.
    Hope this helps.
     
    Glad to help - follow up if anything is unclear.  
    ►  If this solved it, marking it verified helps others too.      
    Regards,
    Grigorios Mavrogeorgis
    Business Central Consultant & AL Developer

    Work: Gmsoft Limited
    Blog:  insidebusinesscentral
    LinkedIn: linkedin.com/in/gregorymavrogeorgis

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 677 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 521 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 306 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans