Is there an accurate way to tell the on hand inventory for a certain day?

You can use “Inventory part on hand development” window to track on hand quantities based on days.

 

Hi @Rasika Lakmal, I was thinking about the same, but when I think how we can get a glimpse of the qty on a ‘certain day’, I think it cannot be limited to the ‘Created date’. Don’t you think?

For example, if a transaction is not created on that day, there won’t be a record. 

Thanks. 

@Vimukthi Mahakumbura 

Here, created date is the transaction date.  You can use column “On hand quantity after transaction” that shows exact on hand quantity for that day. 

But what if I wanted to know quantities showing for the entire warehouse. It will take forever to look each item up one by one.

You can use Warehouse Navigator for this. 

If you can take a sum of the required column, you can find the total. Date element is also there. 

I have warehouse navigator but I am not seeing where I can choose a particular date.

@idolh you can use the last activity date. But, Based on your requirement, custom field option will work for you.

Best Regards,
Rasika

@idolh If you wish to proceed with the custom filed/customization you should contact their IFS consulting organization (or official IFS partner) by raising a new case directly to the consulting organization (where this has been made available), or via other channels as nominated by their consulting/partner organization.