r07.3 patch notes enhancements -...

R07.3 Patch Notes Enhancements

Published: November 15, 2010

R07- Patch 3 Notes

Copyright © 2010 by Kewill Inc.

Table of Contents

Table of Contents............................................................................................................................... 2

R07 Patch 3 Overview ........................................................................................................................ 3

Summary List of R07 Patch 3 Enhancements................................................................................... 4

Changes to Harmonized Tariff Update .............................................................................................. 7

Country Tariff Quota Exclusions ....................................................................................................... 8

Unified Filing Changes..................................................................................................................... 11

Lacey CAT Changes......................................................................................................................... 15

Kewill ISF Alliance Integration......................................................................................................... 20

ACH Credit Change .......................................................................................................................... 21

Bulk Liquor/Beer Entry..................................................................................................................... 22

R07- Patch 3 Notes


R07 Patch 3 Overview

Overview Based on customer needs that have been expressed over many months, Kewill is releasing Patch 3, with the following:

1. Round-Trip Integration between Kewill ISF & Alliance Customs Brokerage Allow users, while preparing the Customs Entry, to connect one/more ISF’s to a Customs Entry. The result of this action is as follows:

• ISF Tracking Dates and Notes will be available for viewing in Alliance Shipment Tracing, as well as Internet Tracking.

• Users will be able to print/fax/email an ISF Form, which can then be included in the Entry Document Package delivered to the Importer.

• The ISF Form, once printed, can also be delivered to Internet Tracking, allowing an Internet Tracking user to view/print/email the ISF Form.

• Billing for ISF Services can be automated, so it automatically is included on the Billing Invoice for the Customs Entry; the Billing Invoice would then, automatically, include the CBP SF Transaction Number (as evidence that the ISF was accepted by CBP).

• Finally, when a user has connected one/more ISF’s, to a Customs Entry, it's highly likely that the Billing Invoice will include a charge for ISF services; it's highly likely because Patch 3 includes a feature to automatically calculate the ISF Fee and include it on the Billing Invoice. Then, to complete the round-trip, Alliance sends the data associated, with the connection, between the Custom Entry and the ISF, to the Kewill ISF web application. The result of that process is the following:

o Broker Reference (File) Number and Customs Entry Number can be viewed on an ISF web page.

o You will be able to run a report showing all ISF’s without a Broker Reference (File) Number. This can be considered as the first line of defense to ensure that you have billed for the ISF Services. In other words, an ISF without a Broker Reference (File) Number is highly likely to be evidence that the ISF Services were not billed.

2. CAT Includes Lacey Filing Data With the expansion to more HTS Chapters & Headings (e.g., furniture), Kewill customers, who use the CAT to ease the process of classifying items from a Commercial Invoice, expressed the need to include Lacey Filing Data in the CAT. That data can now be added via CAT Maintenance. So, with Patch 3:

• Commercial Invoice Line Items that include an Item/Part Number that is subject to the Lacey Filing Regulation....

R07- Patch 3 Notes


• Where the Item/Part Number is in the CAT with Entry Filing and Lacey Filing Data.....

• Can significantly reduce the data entry effort to create the Lacey Filing, since the Lacey Filing Data from the CAT, will be pulled into the Lacey Filing associated with the Customs Entry....

• This is true for Item/Part Numbers entered via the screen, as well as those received in an Electronic Invoice Message (e.g., EDI).

3. Software Enhancements A significant number of enhancements have been made to Alliance via Patch 3. You should carefully read the documentation, which provides a complete list of these enhancements, so you are able to determine what impact, if any, these enhancements have on your business. A summary of these enhancements is provided below.

4. Software Modifications A significant number of modifications have been made to Alliance via Patch 3. You should carefully read the documentation, which provides a complete list of these modifications, so you are able to determine what impact, if any, these modifications have on your business. This documentation is available through the following link: http://www.tradepointsystems.com/documentation/alliance/2010-Alliance%20R07-Patch%203%20Notes_Soft%20Mods.htm

Summary List of R07 Patch 3 Enhancements

The following tables lists the specific enhancements that have been made to the Alliance software for this Patch.

Harmonized Update Changes

• CSMS message 10-000062 announced a change to the ABI Harmonized Tariff Query and Extract Reference File Query programs. In order to accommodate tariff numbers that have more than eight (8) special rates, CBP has added seven (7) new output records to the results of these queries. The new output records have been added to the Alliance database and the information from these new records has been added to the Tariff Number Report and the Tariff Query Report. Tariff Class. Maintenance Rates screen now accommodates additional special rates.

Country Tariff Quota Exclusions

• A Quota Exclusions table has been added to Country Maintenance to allow users to indicate a range of tariff numbers that are not subject to quota when imported from certain countries.

This is a user-maintained table and you are responsible for adding and maintaining the ranges of tariff numbers that are excluded from quota for China and any other country for which some tariff numbers are not subject to quota.

http://www.tradepointsystems.com/documentation/alliance/2010-Alliance R07-Patch 3 Notes_Soft Mods.htm

R07- Patch 3 Notes


Unified Filing Changes • The following changes have been made to Unified Filing programs in Alliance:

o The Flexible Timing (FT) and Flexible Range (FR) can no longer be used with Unified Filing.

o ISF Header screen – field changes: added Bond Reference No field.

o ISF Entities screen – Entities Required field changes, due to the removal of the Flexible Timing option.

o ISF Entities Maintenance – field changes, due to the removal of the Flexible Timing option.

o Shipment Type Codes Maintenance – added new field, Req ISF Bond Info. Codes 03, 05, and 06 are no longer valid for Unified Filing. Added codes 08 (FTZ Shipments) and 09 (Intl. Mail Shipments).

Unified Filing

July 2010 changes

• New Disposition Codes.

There are some new disposition codes for Unified Filing transactions that will now be properly accommodated in Alliance.

Previously, CBP compared the Bill of Lading number submitted with an Importer Security Filing (ISF) against that filed in the Automated Manifest System (AMS), and issued a NO BILL ON FILE status advisory message when the bill number was not in AMS or there was a discrepancy with the bill type. With the July 2010 change, a distinction will be made between a bill number not being on file in AMS and a bill number being on file in AMS, but with a different type than what was filed in the ISF.

a. When a Bill has not been filed in AMS, the ISF Filer will receive a status message with an S2 disposition code and a 'NO BILL MATCH (NOT ON FILE)' description.

b. When a Bill has been filed in AMS, but with a different type than what was filed in the ISF, the ISF Filer will receive a status message with an S6 disposition code and a 'NO BILL MATCH (WRONG TYPE)' description.

c. When a Bill has not been filed in AMS, the ISF Filer shall receive reminder status messages with S3, S4, and S5 disposition codes and a 'NO BILL MATCH (NOT ON FILE)' description after 5, 20, and 30 days, respectively.

d. When a Bill has been filed in AMS but with a different type than what was filed in the ISF, the ISF Filer shall receive reminder status messages with SA, SB, and SC disposition codes and a 'NO BILL MATCH (WRONG TYPE)' description after 5, 20, and 30 days, respectively.

• Duplicate ISF Filings

If an ISF is received by CBP with the same Bill Number and ISF Importer Number as one submitted in a previous ISF by a different filer, CBP

R07- Patch 3 Notes


accepts the duplicate ISF with a warning to let the filer know that a different party previously filed an ISF against the same shipment.

With the July 2010 change, in addition to the above behavior, a status message with an S7 disposition code and a 'DUPLICATE ISF BY ANOTHER FILER' description will be sent to the initial ISF filer indicating that a duplicate ISF was filed.

Lacey CAT Changes • Lacey PGA information has been added to CAT Maintenance, the EDI Parts Upload process, and the EDI Upload Process. When a CAT part number is used in Shipment Processing, the Lacey information is uploaded into the shipment. The Lacey CAT files have been added to all maintenances, purges, and reports that access the CAT data files.

Lacey Act Disclaimer • A new (D)isclaimer option has been added to the OGA pop-up screen in Cargo Release and Entry Summary. If the tariff number is flagged as requiring Lacey information, but there is no wood contained in the product on the shipment being entered, enter “D” in the Lacey field on the OGA pop-up. You will not be required to enter Lacey information, and “PPQ 505-Paper” will not print on the 3461 or 7501.

Kewill ISF/Alliance Integration

• The downloading of Kewill ISF data into the Shipment Processing program has been added to Alliance. A separate document describing the set-up requirements and processing instructions is included with this Patch.

ACH Credit change • A change has been made to the setup required for your customers who are allowed to do ACH Credit when doing ACH Payment Authorizations. Once you have installed Patch 3, for any customers that you are allowing to do ACH credit, you must go into Customer Maintenance and flag them as allowed to do ACH credit by setting the Allow ACH Credit flag on the Import Info screen to “Y” for each of these customers.

Bulk Liquor/Beer Entry • How to documentation has been added explaining how to enter bulk liquor/beer entries.

http://www.tradepointsystems.com/documentation/alliance/ISF_08a_Downloading from Kewill ISF Web Portal to Alliance.htm

R07- Patch 3 Notes


Changes to Harmonized Tariff Update

Overview CSMS message 10-000062 announced a change to the ABI Harmonized Tariff Query and Extract Reference File Query programs. In order to accommodate tariff numbers that have more than eight (8) special rates, CBP has added seven (7) new output records to the results of these queries. The new output records have been added to the Alliance database and the information from these new records has been added to the Tariff Number Report and the Tariff Query Report.

Tariff Classifications Rates screen:

Tariff Classification Rates Screen

Three (3) additional Tariff Rates have been added to the Tariff Classifications Rates screen. For tariff numbers with more than ten (10) rates, press <RETURN> to see the additional rates.

R07- Patch 3 Notes


Country Tariff Quota Exclusions

Overview A Quota Exclusions table has been added to Country Maintenance to allow users to indicate a range of tariff numbers that are not subject to quota when imported from certain countries.

This is a user-maintained table and you are responsible for adding and maintaining the ranges of tariff numbers that are excluded from quota for China and any other country for which some tariff numbers are not subject to quota.

Country Maintenance screen:

Displaying the Quota Exclusions screen

After finding the correct country by entering the country code, enter “34” in the ACTION field to go to the Quota Exclusions screen.

R07- Patch 3 Notes


Country Tariff Quota Exclusions screen:

Country Quota Exclusions screen

The table below describes the data entry requirements for this screen.

Field Name Data Entry Description

Stopping Tar Enter the stopping tariff number in the range of tariff numbers that are not subject to quota when imported from this country.

This is the stopping tariff number in the range of tariff numbers that are not subject to quota when imported from this country.

Eff Date Enter the effective date of the country tariff quota exclusion.

Exp Date Enter the expiration date of the country tariff quota exclusion.

This expiration date must be later than the effective date entered; otherwise an error message will display.

R07- Patch 3 Notes



Starting Tar Enter the starting tariff number in the range of tariff numbers that are not subject to quota when imported from this country.

This is the starting tariff number in the range of tariff numbers that are not subject to quota when imported from this country.

Modified By

Date/Time Upd

No data entry allowed. These fields are automatically updated by the system with the username and date and time the record was updated.

ACTION If you added or changed any information on the screen, press US or UR to update and save the information.

If you press UR, the program will return you to the opening Country Maintenance screen.

R07- Patch 3 Notes


Unified Filing Changes

Overview The following changes have been made to Unified Filing programs in Alliance:

• ISF Header screen – Field changes: added Bond Reference No field.

• ISF Entities screen – Entities Required field changes due to the removal of the Flexible Timing (FT Action Reason) option.

• ISF Entities Maintenance – Field changes due to the removal of the Flexible Timing option.

• Shipment Type Codes Maintenance – New field added: Req ISF Bond Info. Codes 03, 05, and 06 removed. Codes 08 (FTZ Shipments) and 09 (Intl. Mail Shipments) added.

ISF Header screen:

ISF Header screen If the Importer of Record for the shipment is the same as the ISF Importer, no bond information should be entered on the ISF Header screen.

R07- Patch 3 Notes


Changes have been made to this screen including the removal of the following fields: Date of Birth, Country of Issue, ISF Bond Indicator, Bond Number fields, and the following field has been added: Bond Reference No.


11 Bond Reference No.

Enter the bond reference number when the Bond Type is “09” (Single Entry Bond); otherwise, this field will be skipped. This field allows up to fifty (50) characters.

If this field is enabled (e.g., if the Bond Type is 09 above), then the bond reference number is required.

Note: This is not the same as the bond number.

ISF Entities screen:

ISF Entities screen Due to the removal of the Flexible Timing option, changes have been made to the Entities Required field. The “#Req before Arrivl)” note will no longer be used.

R07- Patch 3 Notes


ISF Entities Maintenance screen:

ISF Entities Maintenance

Due to the removal of the Flexible Timing option, the options for fields 03, 04, and 05 (Valid C/R Entity, Valid E/S Entity, and Valid FTZ Entity) have been changed to “N” for Not to be used, “O” for Optional, or “R” for Required.

R07- Patch 3 Notes


Shipment Type Codes Maintenance screen:

Shipment Type Codes Maintenance

New field, Req ISF Bond Info has been added. Codes 03 (Household Goods), 05 (Diplomatic), and 06 (Carnet) are no longer valid for Unified Filing; codes 08 (FTZ Shipments) and 09 (Intl. Mail Shipments) have been added.

Shipment Type codes 01, 02, and 07 will require bond information if the ISF Importer is different from the Importer of Record on a Unified Filing shipment.

R07- Patch 3 Notes


Lacey CAT Changes

Overview Lacey PGA information has been added to the CAT Maintenance and the EDI Upload Process.

When a CAT part number is used in Shipment Processing, the Lacey information is loaded into the shipment.

The Lacey CAT files have been added to all maintenances, purges, and reports that access the CAT data files.

CAT Maintenance screen:

CAT Maintenance The Lacey screens can be displayed from the Tariff Lines sub-screen (e.g., enter “26” (Tariff Lines) in the ACTION field to go to the Tariff Lines screen.

R07- Patch 3 Notes


CAT Maintenance Tariff Lines screen:

CAT Maintenance Enter the Tariff Lines field number (26) in the ACTION field on the CAT Maintenance screen to display the Tariff Lines screen. The data entered in CAT Maintenance will load into Shipment Processing when this part number is used.

CAT Maintenance OGA Selection screen:

R07- Patch 3 Notes


OGA Selection pop-up Enter “Y” in the OGA field at the end of the line data on the Tariff Lines screen to display the OGA pop-up screen.

CAT Maintenance Lacey screen:

CAT Maintenance Enter “Y” in the Lacey (PGA) field of the OGA Selection pop-up screen to display the Lacey screen.

R07- Patch 3 Notes


CAT Maintenance Lacey Ingredients screen:

Lacey Ingredient screen

Enter “Y” in the Ingred field of the Lacey screen to display the Lacey Ingredient screen. The data entered in CAT Maintenance will load into Shipment Processing when this part number is used.

R07- Patch 3 Notes


CAT Maintenance Lacey Product Component screen:

Product Component screen

Enter “Y” in the Prod Comp field of the Ingredient screen to display the Product Component screen. The data entered in CAT Maintenance will load into Shipment Processing when this part number is used.

R07- Patch 3 Notes


Kewill ISF Alliance Integration

Overview Kewill recognizes the efficiency that users of Alliance will gain from having access to certain information entered through the Kewill ISF web portal while completing Shipment Processing data entry for these ISF transactions. In order to provide the information for use in Alliance, we are providing the capability for performing downloads from Kewill ISF.

Review the Kewill ISF Alliance Integration document for detailed information of setup, downloading and billing for ISF fees. Included in the document are the following sections:

• Interface setup instructions

• The download process

• Billing for ISF fees

Note: You should expect a time lag between when Kewill ISF has noted that the ISF is Accepted by CBP and when the ISF data is available to be downloaded into a Customs Entry. It will be no more than 7 to 10 minutes.

http://www.tradepointsystems.com/documentation/alliance/ISF_08a_Downloading from Kewill ISF Web Portal to Alliance.htm

R07- Patch 3 Notes


ACH Credit Change

Overview A change has been made to the setup required for your customers who are allowed to do ACH Credit when doing ACH Payment Authorizations. Once you have installed Patch 3, for any customers that you are allowing to do ACH credit, you must go into Customer Maintenance and flag them as allowed to do ACH credit by setting the Allow ACH Credit flag on the Import Info screen to “Y” for each of these customers.

Customer Maintenance Import Info screen:

48 Allow ACH Credit

If this field is Y, and the ACH Credit Importer in the System Parameters Maintenance has been set to a Y then the Payer Unit may be left <blank> when doing an ACH Payment Auth.

If this field is not set to Y, then the payer unit number cannot be left <blank>, regardless of the other switches.

This field determines whether or not the Payer Unit can be left blank when doing an ACH Payment Authorization.

R07- Patch 3 Notes


Bulk Liquor/Beer Entry

Overview For importers of bulk liquor, CBP does not collect the IR tax. The Entry Summary (e.g., the 7501 hard copy) includes a statement that the tax is deferred under 26 U.S.C.5232(a). In this case, the filer does not transmit any IR tax in the 60-record. The filer normally will receive a warning message about the IR tax but not a rejection of the Entry. Later, when the liquor/beer gets bottled, the importer will send the IR tax directly to Internal Revenue. There are no taxes included on the 90-record and therefore, no code included for the tax deferral.

• Other Brokers can request permission to defer the IR taxes (Note: it is a two-week deferral). The request should be sent to the Port Director (see 24.4 of the regulations). Bills for the tax will be sent to the broker a couple of weeks after the duty is paid.

• EFT If the broker requests to pay by EFT, the Finance Center has to be notified to ensure that everything is set up and in order for the transfer of funds. If the filer sends code 2 for the deferral on the 90-record, the bills will be sent to the importer and copies of the bills will be sent to the NFC so they can check whether all payments have been received in a timely manner.

• Non-EFT

If the broker is not using EFT to pay the deferred tax bill, the broker will receive the bill and a copy of the bill will be sent to Entry at the local port. The broker will send his checks with the bill to the local port – and the Entry staff will do the collection.

[See How To documentation for Bulk Liquor/Beer Entry in the Special Entries section of the Shipment Processing documentation.]

Copyright © 2010 Kewill Inc. [Last revision date: 12/03/10]

http://www.tradepointsystems.com/documentation/alliance/Bulk Liquor Entry.htm

r07.3 patch notes enhancements -...

Documents