Not able to run inventory audit report, how to find the actual cost price of the Item sold.

Dear Business One Experts,

One of our client is using SAP business one 8.81 patch 10 HF 1. I am not able to run the inventory audit report as when i try to run it giving the posting date, a warehouse and then an item group as the selection criteria it gives me an error message stating 'The report returns too many records for this action and may cause SAP Business One to stop responding for a long time or shut down; select fewer records '.

The inventory evaluation method that the client is using is moving average and company has about 80000 items. I have tried the OIVL table to get the inventory value based on the date, item group and warehouse to get the closing quantity and the actual cost price for the item. But i am able to only get the closing stock quantity only. I am not able to get the actual cost price of the item.

Can you please help me to get the actual cost price of the item as in the inventory audit report through query. It would be of great help.

Regards,

Gokul K.