Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Harmonized Tariff Schedule Field: Exporting HTS code to Excel

  • 1.  Harmonized Tariff Schedule Field: Exporting HTS code to Excel

    Posted Nov 27, 2018 04:52 PM

    My company is frequently asked to provide the HTS code (harmonized tariff schedule) for various items. Currently the only way we know to pull this information from AX 2012 R3 is by looking up each item one by one and copying and pasting this data to an Excel sheet. This is a very time consuming operation for our Order Entry folks. For other pieces of information, we can personalize a screen in AX and export the entire list of data to Excel. However, we have never been able to find the HTS field for the purpose of personalizing an AX screen and exporting this information for a select set of items.

    Does anyone happen to know if this functionality is possible?

    Ade Adeniyi-Williams
    Business Analyst
    Beverage Air Corp
    Cedar Rapids IA

  • 2.  RE: Harmonized Tariff Schedule Field: Exporting HTS code to Excel

    Posted Nov 28, 2018 03:54 AM
    Hi Ade Adeniyi-Williams.
    This might not be the answer to your question, but it is quick way of getting data out.

    Use the tablebrowser on InventTable, do some filtering and copy/paste to excel.
    If you know SQL, you can modify the list from the tablebrowser.

    Best regards

    Glenn Linaa
    Tasklet Factory Mobile WMS
    Aalborg, Denmark

  • 3.  RE: Harmonized Tariff Schedule Field: Exporting HTS code to Excel

    Posted Nov 28, 2018 09:04 AM
    Hi Ade,
      Yes this is possible but its a little tricky to do.  A couple things to note:

    1.) I'm doing this from the Products list page, not Released Products.  Watch out in case your product numbers are not the same as your item numbers.

    2.) The actual table this data resides in is WHSEcoResProductTransportationCodes, if you have access to the Excel add-in, you can just pull this table down to get the Product # and HTS.

    Go to Product Info Mgmt -> Common -> Products -> All Products & Product Masters.

    Press the Edit in Grid button to launch the product details form.

    Right click personalize here, but we are not going to use the "Add fields" button.  Expand the personalization form so you can see the whole tree on the Layout portion:

    Expand the Details -> General -> Warehouse Management -> Additional codes nodes until you see "Harmonized System".

    Left mouse click the Harmonized system field and drag it to the "Header Grid", just below "Identification".  Final result should look like this.  If it doesn't look like this, you may have placed the field in the wrong spot such that you can only see the data for one product at a time.
    Close the personalization form, and you'll notice you're product details form reverted to single product mode.  Hit the "Grid View" button at the bottom left of the screen, two to the right of the edit pencil.

    You should end up with this, which you can CTRL+T / export to excel:

    Colby Gallagher
    Manufacturing Systems Consultant
    Agility Business Solutions
    Brecksville OH

  • 4.  RE: Harmonized Tariff Schedule Field: Exporting HTS code to Excel

    Posted Nov 28, 2018 11:10 AM
    ​Hi Ade,

    As with Colby, I used the Edit in Grid form, but I was able to do this very easily using the Edit in Grid from Released Products.  After I got the Edit in Grid form opened and ready to Personalize, I did use the Add Fields button and chose Product Transport from the list of available tables, then chose HTS Schedule B from there.

    I don't think most people realize how much more you can see and do from the Edit in Grid form.  There are fields that you can add to your view in the Edit in Grid form that you cannot from the standard view of the same data, ie. Released products.  And, if you are not used to how it works, as in switching between the grid and details views, it can be a little frustrating at first, as you inadvertently close the grid.  But after you use it and see the ability to make changes quickly to common fields without having to open each released product, or you can see the other fields that you can personalize onto it, you will come to like it.

    Susan Lindner
    The Shepherd Holding Company
    Monroe OH

If you've found this thread useful, dive deeper into User Group community content by role