Is there a way to add report logic to pull the vendor type alternate ID based on the vendor on the purchase order?
We have items with multiple alternate ID types, and in several cases there are multiple vendor numbers listed. I need some sort of logic to specify the alternate type, then match the Vendor ID with the vendor on the PO.
Thanks in advanced!
Best answer by craig2
Hey
This is for the printed Purchase Order form, it sounds like? If so, a join from POLine to POVendorInventory, then another from POVendorInventory to INItemXRef does the trick for me:
I think Alternate ID’s automatically pull on to the PO Line (based on Vendor as well), but I do this to grab the XRef Description, when we need to tweak the verbiage of what we’re buying.
Hope that helps some!
+3Hey
This is for the printed Purchase Order form, it sounds like? If so, a join from POLine to POVendorInventory, then another from POVendorInventory to INItemXRef does the trick for me:
I think Alternate ID’s automatically pull on to the PO Line (based on Vendor as well), but I do this to grab the XRef Description, when we need to tweak the verbiage of what we’re buying.
Hope that helps some!
Craig, you are the man! Thank you so much, that was a huge help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.