Hi guys I need help with modifying the AR Invoice form by adding the Inventory items upc number from the xref table. Has anyone done this or will ing to assist me. I could really use some help on this.
Answer
Please need help adding the UPC xref to the AR Invoice form in Report Designer.
Best answer by bwhite49
Add this join to your report to link to the item UPC code and use this field [INItemXRef.AlternateID] to display the value.
+11Add this join to your report to link to the item UPC code and use this field [INItemXRef.AlternateID] to display the value.
+11In report designer, you have to use these buttons to add customized joins. So click parent formula and add =[INItemXRef.AlternateType] and then save, and then click child formula and to add =’GIN’
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.