Skip to main content
Entry Verification (EV)
Search
Search ONESOURCE Global Trade Support Help and Support.

This article applies to:

  • Product: ONESOURCE Global Trade
  • Sub-Product: Entry verification

Creating ACE Import Declaration Reports Through the U.S. ACE Web Portal

In order to access a client’s US ACE web portal, use the following link:
After successfully logging in, open the
Accounts
 tab.
In the
View
 drop-down list, select
Importer
 and then click the
Go
 button.
In the
Select Task
 list, select
Reports
.
In the
Launch Reports and Quickview Tool
 section, click on the
Launch Tool
 button.
A new window page will pop up. In the left-hand corner, two tabs will appear:
Home
 and
Documents
. Select the
Documents
 tab. This tab will typically contain personal reports as well as public share reports.
Next, select the
Folders
 tab and navigate to Public Folders > ACE > ACE Home > open
ACE Reports Home Page
.
On the newly opened
ACE Reports Home Page
 tab, choose
Importer
 in the available work spaces.
A new tab will open. Choose the
Entry Summary
 section and open the
ES-003_Entry_Summary_Line_Tariff_Details
 canned report.
The
Prompts
 pop-up will appear on the screen. Press the
Cancel
 button.
To enable editing the report, press the “design” button on the top left side of the screen.
To enable the automatic data load of the report data extracted in Excel, remove all objects located above the table on the report header (all objects inside red square on screenshot below).
ES-003 is a canned report and includes only 27 columns. In order to add additional data elements available in New Universe, press the
Edit Data Provider
 button (or click “Ctrl + Q”).
On the
Query Panel
 pop-up, new Entry Summary Universe fields are provided, located in folders. Additional columns should be dragged from the universe tab and dragged to the
Result Objects
 tab.
Please add the following 21 columns to the
Result Objects
 tab.
Column Name
Folder Name
Filer Code
Entry Summary
Filer Name
Entry Summary
Importer Name
Entry Summary
Ultimate Consignee Name
Entry Summary
Estimated Arrival Date
Entry Summary
Release Date
Entry Summary
Mode of Transportation Code
Entry Summary
Carrier Code
Entry Summary
Carrier Name
Entry Summary
Foreign Exporter Name
Entry Summary Line
Manufacturer Name
Entry Summary Line
Line Gross Shipping Weight (KG)
Entry Summary Line
Exportation Date
Entry Summary Line
Line HMF Amount
Entry Summary Line
Line MPF Amount
Entry Summary Line
Foreign Port of Lading Code
Entry Summary Line
Port of Unlading Code
Entry Summary Line
Related Party Indicator
Entry Summary Line
NAFTA Reconciliation Indicator
Entry Summary Line
Reconciliation Status Code
Entry Summary Line
Upon finishing, press
Close > Apply Changes and Close
.
Newly added columns will be available on the
Available Objects
 tab.
This report needs 21 additional blank columns. To add these columns, press the last column (Line Tariff Duty Amount) and press
Insert > Insert columns on Right
 21 times.
Next, drag the newly added column and place on the blank column header.
In order to make sure the report column sequence will be consistent, please add 21 columns in the following order:
  1. Filer Code
  2. Filer Name
  3. Importer Name
  4. Ultimate Consignee Number
  5. Ultimate Consignee Name
  6. Estimated Arrival Date
  7. Release Date
  8. Mode of Transportation Code
  9. Carrier Code
  10. Carrier Name
  11. Foreign Exporter Name
  12. Manufacturer Name
  13. Line Gross Shipping Weight (KG)
  14. Exportation Date
  15. Line HMF Amount
  16. Line MPF Amount
  17. Foreign Port of Lading Code
  18. Port of Unlading Code
  19. Related Party Indicator
  20. NAFTA Reconciliation Indicator
  21. Reconciliation Issue Code
Next, press
File> Save As
 and save the report to the following location: Public Folders > ACE > Shared Reports > Trade > @US Importer Name - @Tax Identification Number with the following name:
ES-003_Entry_Summary_Line_Tariff_Details_-_EV.xlsx
.
This will ensure that all importer type account holders will have access to the newly created report.

Running Your ACE Report

In order to run and extract a report in Excel format, login to ACE and go to the
Accounts
 tab. Next, select
Importer
 from the
View
 drop-down list and press the
Go
 button. In the
Select Task
 list, select the
Reports
 option. In the
Launch Reports and Quickview Tool
 section, press
Launch Tool
.
A new window page will pop up. In the left-hand corner, there will be a
Home
 tab and a
Documents
 tab. Select the
Documents
 tab. This tab will typically contain personal reports as well as public share reports.
Next, select the
Folders
 bar. Select Public Folders > ACE > Shared Reports > Trade > @US Importer Name - @Tax Identification Number.
Double-click to run the report. Once the report has finished rendering, click the drop-down list icon and select Export Document As > Excel. This will export the document selected to an Excel format file.
In order to complete exporting the document to an Excel file, you will be required to click either the Open or Save icon in Internet Explorer notification displayed at the bottom.

Submitting Your ACE Import Declaration Reports Over FTP

The generated file should be placed on the specially created FTP folder by the ONESOURCE Global Trade team. The easiest way to do this is to open Windows Explorer and paste following the address (ftp://ftp2.integrationpoint.net/) and press enter.
The FTP Authentication window will appear. The user will need to enter the username and password that will be provided by ONESOURCE Global Trade and press log on.
The user will be navigated to the FTP folder where they can place the generated Excel report.

Related Content