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

Publicaciones relacionadas	Respuestas	Vistas
How to add Custom field in journal item to financial report GL, Partner ledger and so Odoo 16 accounting reporting odoo16features	0 may 23	2261
Odoo 16 Journal Report to pdf accounting reporting odoo16features	0 ene 23	2257
Reporting in an alternative currency from the main currency (v18) accounting manufacturing inventory reporting	1 ene 25	926
List and Print All Unpaid Invoice to be Billed to the Customer Before Overdue accounting invoice reporting odoo16features	1 abr 24	1520
Report needed for linking OUT transfers to the IN transfers stock is being pulled from accounting inventory reporting transfers valuation	0 ago 24	992

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!