Upload Trade Operation Charges in a Spreadsheet
You can use a spreadsheet for bulk data updates to an existing Trade Operation. Add, edit, and delete operations can be performed to update the charge information. You can use a spreadsheet to complete bulk updates for the following:
-
Landed cost charges
-
Landed cost charge references
-
Landed cost related charges
The ADF Desktop Integrator is a prerequisite for capturing charges in a spreadsheet, and can be installed from the Tools section of the Navigator menu.
To capture Trade Operation charges in a spreadsheet, complete the following steps.
-
From the Navigator menu, select Receipt Accounting.
-
From the Landed Costs tasks list, select Capture Trade Operation Charges in Spreadsheet.
-
Download the Capture Charges spreadsheet.
-
Open the spreadsheet. A pop-up message asks if you want to connect to an application. Click Yes, and enter your sign-on credentials.
-
Search on the Capture Charges tab for the Trade Operation to be updated. The spreadsheet is populated with the charge lines and corresponding Trade Operation data from the result set.
-
Perform the required edit, add, or delete operations. The Changed column is automatically updated with a change indicator icon to confirm which rows have been modified.
-
Click Upload to apply your changes.
-
Repeat the above steps for any changes required on the Capture Charge References tab and the Capture Related Charges tab.