Incorrect Closing Stock Amount value
Act as Zoho Inventory Expert. We are a construction company, OVAL Projects Engineering Limited. We started using Zoho Inventory for Stock Management.I have multiple warehouses. I have encountered a problem while generating custom warehouse wise inventory details. The problem is: Before running the custom report, I have updated the purchase price of all items in the Item Master screen manually. But when the report got generated, it should give Closing Stock Value as Closing Stock Quantity * Updated Purchase Price for the item. In the contrary, system is picking a random number 1000 as purchase price and applying the above formula to derive the CLosing Stock Value. Please give me how my custom report can fetch the latest updated purchase price data from item master and correctly populate the Closing Stock Value in the custom report.