Custom label will not populate when production order is in Released status

Two things:

Have you confirmed the report doesn't have a condition driving this behavior?

Please attach the report for someone to look at.

This report is in report designer. I cannot attach a rpx. file. 

Try zipping it

Here is the zipped file.

Change your join on InventoryItem to AMProdItem.  You have LEFT, I’d use RIGHT.  That should fix it.  What that is telling it is to get ALL of the inventory ID’s in AMProdItem and try to match it to InventoryItem.  

The correct (in my opinion) way though is since you’re going from AMProdItem (those are your filters), I would use AMProdItem as my Parent Table and InventoryItem as your Child.  You want to start at the top level, AMProdItem, then build the lower level (children) table joins.  

Change your join on InventoryItem to AMProdItem.  You have LEFT, I’d use RIGHT.  That should fix it.  What that is telling it is to get ALL of the inventory ID’s in AMProdItem and try to match it to InventoryItem.  

 

The correct (in my opinion) way though is since you’re going from AMProdItem (those are your filters), I would use AMProdItem as my Parent Table and InventoryItem as your Child.  You want to start at the top level, AMProdItem, then build the lower level (children) table joins.  

 

 

 

 

Thank you, but I am still unable to get this to work

Hi ​@ChantellBeaty were you able to find a solution? Thank you!