Not a lot of developers will be able to help you with this question. You need to find an inventory/item tracking specialist or an end user who uses this functionality every day, which you have a much chance of doing in our end-user forum. So I have moved your question there.
Hello its Steve. Not sure your time zone but if we can connect via Teams I can look at try to help you. Please email me steven.chinsky@wipfli.com and I will connect with you.