Feature - Credit Hold Flag Now Supported in Customer Mass Update by CSV Utility

Feature - Credit Hold Flag Now Supported in Customer Mass Update by CSV Utility

Release Date: 3/20/2023
Version: 8.5 and Above

Background


This article is an add-on to the primary article on the Mass Change Customer Import utility. If you would like more details, click here. For now, we quickly summarize the purpose of the Mass Change Customer Import utility. Elliott has an import utility that allows a user to update multiple customers via CSV file. It is convenient if you have many customers who need to be mass updated at one time rather than manually going into the Customer File Maintenance and individually changing each field. This import utility It is located at Accounts Receivable > Utility > Customer/eContact Import. From there, select Mass update utility > mass change Customer. 



Note the tab named "Layout" in the taskbar. If you click on it, it will list the column layout needed for the CSV file to be imported properly. This article is about a new column that the CSV import file now supports: "AF) Credit Hold."

Feature


Credit Hold is a feature that halts a customer's orders, usually if they are not paying you on time. If a customer fails to make payments, you have the option to set Credit Hold to "Y." Otherwise, you set it to "N."

Mass Change Customer Import now supports a Credit Hold column. You can use your preferred CSV editor (e.g., Excel) and column AF will support Credit Hold entries. It accepts either a "Y" or "N" value. Leaving the field blank in your CSV import file will do nothing, and using the $$BLANK$$ string will throw an error.



Programs Modified: SYCUSMAS.CBL, SYCUSMAP.CBL
AWK




    • Related Articles

    • Feature - Added a Generic Utility to Mass Update Customer by CSV

      Release Date: 9/26/18 Last Updated: 3/20/24 Added a generic utility to Mass Update Customer by CSV. Access to the new utility is found in two places: In AR: A/R-> Util-Setup-> Customer/eContact Import-> Update Salesman Utility has been changed to ...

    • Feature - Mass Change Salesman Utility

      Release date: 1/17/2017 A new Mass Change Salesman utility has been added to Global Setup, Utilities, and A/R Utilities. This utility can assist in situations where a salesperson has left the company and their customers are reassigned to a new ...

    • Feature - Add Support Customer Finance Charge Flag to the Mass Change Customer CSV Import

      Release date: 4/17/2019 Version: 8.2 and Up Added support for column AB - Customer Finance Charge Flag to the Mass Change Customer CSV Import. Valid values are "Y," "N" or spaces. Modified Programs: SYCUSMAS, SYCUSMAP DLM

    • Feature - Utility to Update eContact PDF PostOffice Flags

      'Release Date - 4/26/17 The purpose of the feature is to provide a mechanism for the user to mass update the PDF PostOffice flags that were introduced in the eContact Manager in V8.2. A new utility program is available from Global Setup -> Utilities ...

    • Feature - Customer CSV Import

      Release date: 9/25/2019 Version: 8.5 and up For the Customer CSV Import, select AR --> Utility --> Customer/eContact import --> customer/econtact Import --> Customer import This new screen program will have three menu options: Pre-Interface, ...