Support FFL Number & Expiration Date with Ship-To CSV Import Utility

Support FFL Number & Expiration Date with Ship-To CSV Import Utility

Release Date: 8/30/2019
Version: 8.5 & Up

There has been a ship-to CSV import utility in Elliott Business Software for many years. You can access it from COP -> Maintenance -> Ship-To File -> Import. This utility allows users to add new ship-to records for a customer from a CSV file.  This is very handy when you are adding a customer with many store locations. It is especially useful with EDI scenarios.  The following is a sample screen of the layout for the CSV file:


This utility was not available with Elliott Firearms Industry add-on software because there are custom fields like FFL Number and Expiration Date which are not supported with the standard utility. Starting with Elliott 8.5, we are now supporting the importing of ship-to records for the Firearms Industry software by adding the support of FFL Number and Expiration Date columns. See layout sample screen below:




EMK



    • Related Articles

    • CSV Import Supports Both MM/DD/YY and MM/DD/YYYY Date Formats

      Release Date: 12/18/2018 Q - Recently, I tried to import a future price code file through CSV. I saw that on the screen layout, it states the date format should be in the MM/DD/YY format. MM stands for the two-digit month. DD stands for the two-digit ...

    • Change Customer Number or Create New Customer and Import Ship-To

      Release Date: 02/18/2022 Version: 8.5 & Up Q - We had to create a new customer number for our T&EAZ account. We are doing a web project and the website does not like the "&" symbol that is in this customer number. My question for you is…. Is it ...

    • APINVIMS Accounts Payable Invoice Import Utility

      A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...

    • Common Issues with Importing CSV Files Into Elliott

      Release Date: 12/18/2020 Version: 7.0 & Up Elliott Business Software has extensive features with CSV file export and import. It provides a gateway to view Elliott's data in Excel spreadsheets and optionally allow users to edit the data in ...

    • Change - CSV Import Programs to Support File Names Longer Than 20 Characters

      Release date: 5/5/2021 Version 8.5 & Up There were many Elliott CSV Import programs which had a limitation that the maximum file name could not be greater than 20 characters. See the following KB article: ...