Skip to Content
This question has been flagged
accountinginventoryreportingodoo16featuresGRNI
2 Replies
4250 Views
Avatar
Kylie Grant

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 as month end or year end.  I can't figure out how to produce such a report; however, given what a common requirement it is, I'm sure there must be a way and I just haven't found it.  Any help would be greatly appreciated. 

Thanks



Avatar
Discard
Alex Lyngsoe

Hi Kylie,
Did you find a usable solution ?

Kylie Grant
Author

Hi Alex, unfortunately not via the UI. I know all the required data is there so I need to write a spec to have it developed.

Avatar
Chris TRINGHAM
Best 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/

Avatar
Discard
Avatar
Rijo John
Best 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 quantity

Avatar
Discard
Kylie Grant
Author

Hi Rijo, thanks very much for the idea. I haven't had a chance to try it out yet but I'll post back here when I do.

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