This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hello group,
I have a request to get all inventory balances from a site. The result set should have the following columns:
inventory.itemnum
item.description
inventory.location
item.commoditygroup
invbalances.curbal
invenorty.minlevel
Additionally they would like item current balances to show on a storeroom level and not a bin level. So if storeroom A, bin x has 4 and storeroom A , bin y has -1 there should only be one line showing a total of 3 items in storeroom A instead of two lines showing the different bins. I tried to sum the curbal but my query still returns two lines for each bin with a total of 3 items per line. Any help is much appreciated.
I found the problem with my sql statement and its running fine now.
Thanks
On Thursday, November 21, 2013 3:38 PM, aki porter <akiporter@yahoo.com> wrote:
Hello group,
I have a request to get all inventory balances from a site. The result set should have the following columns:
inventory.itemnum
item.description
inventory.location
item.commoditygroup
invbalances.curbal
invenorty.minlevel
Additionally they would like item current balances to show on a storeroom level and not a bin level. So if storeroom A, bin x has 4 and storeroom A , bin y has -1 there should only be one line showing a total of 3 items in storeroom A instead of two lines showing the different bins. I tried to sum the curbal but my query still returns two lines for each bin with a total of 3 items per line. Any help is much appreciated.