. Create multiple CSV Import files:
*Primary File:
-Internal ID
*Expense File:
-Internal ID
-Line ID
-Department/Location/Class
*Users may create a Vendor Bill Transaction Saved Search to pull up above fields.
–Lists > Search > Saved Searches > New.
-Click on Transaction link.
-Under Criteria tab > Standard subtab > Add the following fields:
-Type = is Bill
-Account = is not (Select the Accounts Payable Account used for Vendor Bill records)
-Under Results tab > Columns subtab > Add the following filters:
–Internal ID
–Line ID
–Department/Location/Class
-Edit the Search Title as desired
-Hit Save & Run
-Hit Export – CSV button to export the file.
-Modify the exported file and set the Department/Location/Class field value(s) to Blank.
2. Navigate to Setup > Import/Export > Import CSV Records.
-Import Type = Transactions
-Record Type = Vendor Bill
-Character Encoding = Western (Windows 1252)
-Select Multiple files to upload
–Primary File – Vendor Bill
–Linked File (Optional) – Vendor Bill Expenses
-Next
-Data Handling = Update
–Under Advanced Options: Overwrite Missing Fields = True
-Next
-Primary and VENDORBILL:item (Linked File) = Internal ID
-Next
-Map the following fields:
–Internal ID = Internal ID (Found under Vendor Bill folder)
–Line ID = Expenses : Line (Found under Vendor Bill Expenses folder)
–Department/Location/Class = Expenses : Department/Location/Class (Found under Vendor Bill Expenses folder)
-Next
-Enter an Import Map Name
-Hit Save & Run