Item Purchase Cost Import/Export

Without this utility a user would have to:

• Open the Items form and create a new record with the appropriate information.
• Open the Item Purchase Costs form and update the pricing information for the item.

This can be very time consuming as a vendor price book could potentially contain thousands of entries that need to be either created or updated. With the new flow the vendor price book information is copied into a spreadsheet format that contains the essential information. A user can then review the information and select what records to include for the utility processing. The import does the following:

• Creates a new item if one does not already exist.
• Creates a new item purchase cost record for the begin effect date from the spreadsheet.
• Assigns the end effect date of any previous item purchase cost records already in the system to a day before the new begin effect date.