Hello, is there a way to get the actual qty of an item to show as a column in the main item list? ie. fetch the actual qty into the item master, so that it can then be selected in the list settings?
First you have to add the custom field in the Item master and hourly run the scheduler_events to update the actual qty.
Reference: Fetching Available Quantity of the stock and displaying it on customfield in Items page - #2 by NCP
After then you can set it in the Item ListView.
Thank you NCP. I really appreciate your responses and help.
Is there no way to more simply fetch the value from actual qty in real time? Why an hourly schedule? I’m very new to ERPNext but this method seems somewhat convoluted and I wonder why a stock on hand count against the inventory items wouldn’t be more easily accessible in the system? While I can appreciate that all software has its differences, in the inventory management systems I’ve used before, the ability to see stock on hand in this way has always been there as default functionality?