Hi, is there a way where I can show all stock items their QTY on hand, available, location, and lot/serial number all on 1 GI? similar to inventory summary screen (whether it has a lot/serial or not) but in GI form? It seems like they are two separate tables being I would like to show lot/serial number as well. any thoughts are appreciated.
You can pull the information from the INLotSerialStatus DAC into a GI and then create Pivot Tables to gather the needed information.
Hi
Can you left join INSiteStatusSummary to INLotSerialStatus which will include qty on hand, available, location, etc. for items with and without serial numbers? If you need the warehouses as columns you can join with aliases tables with a lock(join) with the warehouse ID/CD. Then use the aliased tables to display the different warehouses as columns.
Hi
please see below. I also attached the GI XML file in case you want to take a look
Hi
Hi there. I was wondering if anyone found a solution to this? I’m running into the same issue as
Thanks for the update
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.