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

Powiązane posty	Odpowiedzi	Widoki
How to add Custom field in journal item to financial report GL, Partner ledger and so Odoo 16 accounting reporting odoo16features	0 maj 23	2999
Odoo 16 Journal Report to pdf accounting reporting odoo16features	0 sty 23	2953
Reporting in an alternative currency from the main currency (v18) accounting manufacturing inventory reporting	1 sty 25	1642
List and Print All Unpaid Invoice to be Billed to the Customer Before Overdue accounting invoice reporting odoo16features	1 kwi 24	2131
Report needed for linking OUT transfers to the IN transfers stock is being pulled from accounting inventory reporting transfers valuation	0 sie 24	1535

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!