Sage 100

Have a client with a warehouse for ""inactive"" inventory and a warehouse for items that really are on hand (or active). Using ALE.they would search on description for example ""1 inch valve"" The kicker is that the only warehouse quantities they want to see for 1 inch valves are those in the ""active"" warehouse for the item..I told them not possible, but thought I'd see if there was a way this might work. They are on 4.4 SU8 - appreciate any help.

Man - isn't there something for a lookup that combines warehouses ? Or maybe I'm dreaming. The other part should just be filters - right -- <> 0 ?

Here's one - but I didn't look at the manual yet - http://dsdinc.com/enh/by-module/inventory-management/es-im-1242.html

BLAH - doesn't look like it handles ALE (or is at 4.5) -- http://www.sagesoftware.com/mas90/ext_solutions/files/im/im-1242.pdf

ALE allows visibility of the default whse only...which would be ok, but the qty is the Total Quantity - not qty by whse. There is a separation between IM1 and IM2 (yes, yes, I know different file names, but you get the idea). I can't find anything that gets the warehouse qtys accessible. I must be missing something.

Maybe you can use Inventory Module Explore Item Quantities by Warehouse View. Make Custom view, add description Column, filter out zero quantity and inactive warehouse?

What if you create a UDF on CI_Item and use VI to calculate and populate this field on a schedule. You could even create a field for each warehouse, if not too many.

What Bill said. You could in addition have a script button in Inventory Maint when they want to manually run this calc and not wait for the scheduled update. Had a situation kind of like this too. Client wanted some fields in Customer Maint / Summary tab on their customer ALE Lookup (Sales PTD, Sales YTD, etc). In the end, customized that lookup to include UDF versions of those fields. To populate the UDFs I created a stand-alone utility they could schedule that ran the same calc as Summary tab did (but for all customers) and a button in Customer Maint they could press to manually run the calc for all customers. They clicked this when they didn't want to wait for the next scheduled update.

You could also run the VI job from a batch-file and use the scheduler to run it every hour so that it would be continuously updated. We created a non-VI program to do this for one of our customers.

@MichaelBuscher - where is this ""Explore Item Qtys by Whse"" view you mention? @BillPfahnl, @AlnoorCassim - interesting option...assuming I knew how to do this. There is only one active whse for which they want to see qtys. What would it take to make this work?

Not to put words in @MichaelBuscher mouth, but I took that to mean a BIE view.