Goods received not invoiced

Question

Hello,
I have a UK manufacturing client on v16e.  In their old system, they had a Goods Received Not Invoiced (GRNI) report (quite common in Anglo-Saxon accounting) that listed the value of the inventory they had received but not yet been invoiced for by the supplier. I realise I can get the figure by looking at the balance sheet, but what they really need is a report structured by supplier, purchase order number and product number, and they need to be able to run it as of a specified date, such

Chris TRINGHAM · Accepted Answer

Hi Kylie

If you use Automatic Inventory Valuation on relevant Product Categories (for everything you buy) then there will be postings to the stock interim account for goods received.

To make it useful you have to ensure that the same account is *not* used for inventory adjustments, manufacturing orders, wastage, etc.

Then you can create a report from the journals items posted to that account.

https://odootricks.tips/inventory-postings-valuation/ [1]

[1] https://odootricks.tips/inventory-po

Rijo John · Answer

I'm unsure if this idea will be helpful, but you could create an XLS report. To generate the report from wizard view, you'll need to add two date fields: a start date and an end date. Using these dates, you can filter the purchase orders.
Within each purchase order, you'll find purchase lines. Each purchase order line contains the ordered quantity, received quantity, and invoiced quantity.
Based on a condition, you can pass the data to the XLS report: (if received quantity > 0 and invoiced quant

Related Posts	Replies	Views
How to add Custom field in journal item to financial report GL, Partner ledger and so Odoo 16 accounting reporting odoo16features	0 May 23	1519
Odoo 16 Journal Report to pdf accounting reporting odoo16features	0 Jan 23	1657
Reporting in an alternative currency from the main currency (v18) accounting manufacturing inventory reporting	1 Jan 25	344
List and Print All Unpaid Invoice to be Billed to the Customer Before Overdue accounting invoice reporting odoo16features	1 Apr 24	778
Report needed for linking OUT transfers to the IN transfers stock is being pulled from accounting inventory reporting transfers valuation	0 Aug 24	410

This question has been flagged

Enjoying the discussion? Don't just read, join in!