BorderConnect Wiki

ACE Shipment CSV Upload Feature (ACE Manifest): Difference between revisions

← Older edit
No edit summary
 
Line 3: Line 3:
{{#ev:youtube|bWwYYqaVZ0k|960|center|How to import shipments into an ACE eManifest.}}
{{#ev:youtube|bWwYYqaVZ0k|960|center|How to import shipments into an ACE eManifest.}}


[[File:Company-pref.jpg|thumb|360px|right|Selecting Company Settings from the Account menu]]This guide provides '''instructions on how to upload a large volume of shipments into an ACE Manifest''', using BorderConnect's CSV upload feature in an [https://www.borderconnect.com/ace-e-manifest/index.htm ACE Manifest]. The CSV upload feature is designed for users who have a significant amount of shipments on a single trip and would like to avoid entering data separately for each shipment. A common use case in ACE is used for Section 321 shipments.
[[File:Company-pref.jpg|thumb|360px|right|Selecting Company Settings from the Account menu]]This guide provides '''instructions on how to upload a large volume of shipments into an ACE Manifest''', using BorderConnect's CSV upload feature in an [https://www.borderconnect.com/ace-e-manifest/index.htm ACE Manifest]. The CSV upload feature is designed for users who have a significant amount of shipments on a single trip and would like to avoid entering data separately for each shipment.
 
== Enabling Import Buttons ==
== Enabling Import Buttons ==


Line 34: Line 33:
*Only the coded values listed in the table below can be used in this field.
*Only the coded values listed in the table below can be used in this field.


Below are the valid Shipment Type values. E.g. for a Section 321 shipment, the value SECTION_321 must be entered.<br>
Below are the valid Shipment Type values.<br>
(Please note that the shipment type values are '''case sensitive''', and the upload will fail if it is not entered ''exactly'' as specified below.)
(Please note that the shipment type values are '''case sensitive''', and the upload will fail if it is not entered ''exactly'' as specified below.)


Line 44: Line 43:
| PAPS
| PAPS
| PAPS
| PAPS
|-
| Section 321
| SECTION_321
|-
| Section 321 with FDA Considerations
| SECTION_321_FDA
|-
|-
| QP In-Bond
| QP In-Bond
Line 140: Line 133:
*The value of the commodity, in U.S. Dollars.
*The value of the commodity, in U.S. Dollars.
*'''Numeric only''', with one decimal allowed. Must not include dollar sign, commas, etc.
*'''Numeric only''', with one decimal allowed. Must not include dollar sign, commas, etc.
*Only required when Shipment Type is Section 321 or Section 321 with FDA Considerations
*For Section 321 or Section 321 with FDA Considerations, the maximum value is 800.
*System will round to nearest whole number, or up to 1 if less than 1 before transmitting to customs.
*System will round to nearest whole number, or up to 1 if less than 1 before transmitting to customs.


Line 295: Line 286:
<u>Country of Origin</u>:
<u>Country of Origin</u>:
*The country in which the commodity was manufactured, grown or otherwise produced.
*The country in which the commodity was manufactured, grown or otherwise produced.
*Only required when Shipment Type is Section 321 or Section 321 with FDA Considerations.
*Must use the 2 letter country code for the country, in upper case letters.
*Must use the 2 letter country code for the country, in upper case letters.
*The full list of acceptable country codes can be [https://www.borderconnect.com/data/countries.json downloaded here].
*The full list of acceptable country codes can be [https://www.borderconnect.com/data/countries.json downloaded here].
Line 311: Line 301:
== Importing 10,000 Or More Shipments To a Single ACE Manifest ==
== Importing 10,000 Or More Shipments To a Single ACE Manifest ==


{{#ev:youtube|LfbA8W-R9S0|360|right|Importing 10,000 or more shipments into an ACE Manifest}}By default users can only upload 9999 shipments into a single ACE Manifest, which is enough for most users who wish to import Section 321 shipments into an ACE for example. However, in some cases more shipments will need to be added to a single ACE Manifest.
{{#ev:youtube|LfbA8W-R9S0|360|right|Importing 10,000 or more shipments into an ACE Manifest}}By default users can only upload 9999 shipments into a single ACE Manifest, which is enough for most users who wish to import shipments into an ACE for example. However, in some cases more shipments will need to be added to a single ACE Manifest.


Importing 10,000 or more shipments into a single ACE Manifest involves creating multiple ACE Manifests and importing no more than 9999 shipments into each separate ACE Manifest, then moving the imported shipments from the second (or third) ACE manifest, back to the original manifest using the Link Shipments to Trip feature.
Importing 10,000 or more shipments into a single ACE Manifest involves creating multiple ACE Manifests and importing no more than 9999 shipments into each separate ACE Manifest, then moving the imported shipments from the second (or third) ACE manifest, back to the original manifest using the Link Shipments to Trip feature.
Line 332: Line 322:


[[File:Send-link-shipments-to-trip.jpg|300px]]
[[File:Send-link-shipments-to-trip.jpg|300px]]
If these ACE Manifests only contain Section 321 shipments no entry numbers will be provided and three blue bars is the status that will remain on the ACE Manifests until the driver arrives at the border. It’s also important to note that CBP will see all of the shipments on the original ACE Manifest that we created, so be sure to show the driver lead sheet for the original trip only when arriving at the border.


== Common Import Errors ==
== Common Import Errors ==
Retrieved from "https://wiki.borderconnect.com/index.php?title=ACE_Shipment_CSV_Upload_Feature_(ACE_Manifest)"