Hey All - Quick Workbook question. Trying to merge a transaction line (PO) to current on hand inventory for a specific location. Has anyone been able to locate the appropriate field to join to the transaction line attributes. I have all the PO elements, but inventory is not there. I can find inventory for all loctions, but not for a specific location. TIA for any help/ideas.

If you want to join to the location lines on the item record, you are going to need to add a criteria as well to remove the line duplication. Something like

{transaction.transactionlines.item^item.location} == {transactionlines.location}

, (i just made that formula up, not tested) otherwise joining to the location sublist on the item record will give you every line.

@Sandii thanks for the tip on the join. I can see the location element, but what field actual has the 'Quantity on Hand' value?

same join, its on

locations

, not location

noted...but still not seeing the field in the locations record that has the 'Quantity on Hand'

Dont look at the dropdown below

locations

, when u click on locations all the fields associated with it are to the right

Thank you!