Tuesday, December 18, 2018

Withholding Tax > Update the withholding tax code of Vendors using CSV import


Problem :

WH Tax Code field  is not available for mapping when importing vendors via CSV

Solution:

We can update the withholding tax code of Vendors using CSV import, please follow the steps below:

A. Create a CSV file with the following columns
1. Internal ID (Contains Internal ID of the Vendor)
2. Default WT Code (Contains Internal ID of the withholding tax code)

B. Import the file.
1. Go to Setup > Import/Export > CSV Import Preferences.
2. Check the box to enable Run Server SuiteScript and Trigger workflows.
3. Click Save
4. Go to Setup > Import/Export > Import CSV Records
5. Import Type = Relationship
6. Record Type = Vendors
7. Select the CSV file created
8. Click Next
9. On the Data Handling select Update
10. Click Next
11. On the mapping page, Map the following
-- Internal ID > Internal ID
-- Default WT Code > Default WT Code (Click the pencil icon next to this field and select Internal ID as the reference type)
12. Click Next
13.Name your import and click Save and Run.

No comments:

Post a Comment