Monday, April 29, 2019

CSV Import: Vendor Bill > To remove the Department/Location/Class field value(s) on Expense Line(s)

1. Create multiple CSV Import files:
*Primary File:
-Internal ID

*Expense File:
-Internal ID
-Line ID

*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

-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
-Data Handling = Update

--Under Advanced Options: Overwrite Missing Fields = True
-Primary and VENDORBILL:item (Linked File) = Internal ID
-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)

-Enter an Import Map Name
-Hit Save & Run


No comments:

Post a Comment