...
Update the OOB Purchase Order PDF
Remove Brand column
Remove UPC column
Update Item Header = “AATC Item No.”
Add a new column “Vendor Item No.” to the left of “AATC Item No.”
For each Purchase Line
Select Cross Reference No from the Cross References Table where
Purchase Order.Buy-from Vendor = Cross Reference.Account
AND
Purchase Line.Item = Cross Reference.Line
Populate “Vendor Item No.” with the Cross Reference No.
If no Cross Reference No exists, then leave the “Vendor Item No” blank.