Improved product value logic for purchase order Excel spreadsheet import

When you format an Excel spreadsheet to import and create an order in Purchase Order Entry, a product value is required for each line item. You may include values in the Vendor Product and Distributor Product columns for the line item. The Distributor Product value takes precedence and is used, even if both values are imported.

To prevent the Distributor Product value from being replaced, the cross-reference logic for vendor products that was previously applied to the Distributor Product column has been removed. Now, the Vendor Product cross-reference logic is only applied to the Vendor Product column. When you import only a Vendor Product value in the line item, the value is used to determine the Distributor Product value, based on Product Extended Product Cross Reference Setup-Vendor and Product Warehouse Product Setup.