Good Afternoon,
I am looking for some assistance with creating a GI. I am using the Inventory “Issues” GI as the basis. I am trying to modify it to include information from the INTrans table. I would like to bring in the following Properties:
INTrans.SiteID
INTrans.InventoryID
INTrans.Qty
INTrans.TranCost
Then add an additional condition to only show item that have INTran.ReasonCode of “Damaged”
Essentially I am trying to create a GI that shows me the total cost/qty by site and Inventory ID of all “Damages”. Using this to begin tracking manufacturing shrink/waste.
Currently I am getting error when trying to view the GI so I am sure I did something wrong with the tables and relations.
Attached is the GI as it is now.
Thank you for the assistance.