Pulling Batch attributes in to new batch with formatted search
My customer is a metal fabricator and uses batch control on all items. We have defined User Defined Fields on the Batch to store critical information about each batch based on industry standards, such as width, temper, alloy and thickness. When doing a receipt document (Goods Receipt PO, AR Credit Memo, etc.) the customer adds information to the UDFs on the document line. We would like this entered info to pull through to the Batches Setup screen so we don't need to re-enter the same information.
I'd like to create a formatted search to pull this information from the GRPO main document into the Batch Setup screen. I've read from other postings that the SBDR table is just a virtual table and doesn't store data and my attempts to pull data such as PDN1.U_Itm_Width into OBTN.U_Itm.Width have not been successful. I either end up getting a blank finder screen from my query or a screen with lists of widths. I haven't hit on the correct syntax to grab the specific width from the specific line from PDN1.
Does anyone have any suggestions on the syntax for my formatted search query that would allow me to pull this information correctly?
Thanks in advance for the help!