Inventory

Feature - Toggle Equal Sign Export in User Defined CSV Export Report

Release Date: 03/14/2025
Version: 8.5 & up

Added an F5 option to I/M, Report, Reorder Advice/User Def CSV, Print, User Defined CSV Export and field 7, "Item Has Attribute" to toggle the value of Export Equal Sign between Y, N, and blank.  Blank is the default, which will use the value in Global Setup, System, Company Specialized Control, and field 1, "Add Equal Sign to the CSV Export Fields Below?"

There are many ways to export data in Elliott to a CSV file.  Some fields, like item number and UPC, may begin with one or more zeros.  If the CSV file is opened in Excel, the leading zeros may be lost if the field is all numeric.  We added a Global Setup flag that would add an equal sign to the beginning of these fields so the leading zeros would be preserved.


The exported data would include the equal sign in the CSV for those fields.



Some programs that use the CSV file for an inventory feed do not allow the equal sign to be used.  We added an option to the User Defined CSV Export to allow the equal sign to be suppressed in the export.  In the report screen, the F5 key can be pressed on field 7 and this will display the status of the export of the equal sign.


You don't have to select an Attribute.  The export status will still be used.


By selecting N, the equal sign no longer appears in the CSV file.



If the status is blank, the default from Global Setup will be used. 


Programs Modified: IMSLSHCP, IMSLSHCS, CSVOUTPT.PL, CSVOUTPT.WS

MAD

    • Related Articles

    • Change - Change Definition of Usage Type's in User Def CSV

      Release date: 6/19/20 Version 8.5 & Up In IM --> Report --> Reorder Advice/User Def CSV --> Maintenance --> User Defined CSV Layout, we changed the definition of UA, U1, U2, U3, U6, and UA type column values so they do not include usage from the ...

    • CPR01MNT Customer Order Processing User-Defined Code Maintenance

      User-Defined Code Maintenance Application Overview This feature gives you the ability to assign a “User-Defined Code” in the COP line item screen for special tracking purposes. In the Order Line Item Entry Screen, the system will prompt you to enter ...

    • Developing a New Elliott V8.6 Report Desk User Defined Report (UDR)

      'Release Date: 6/20/2018 Version: 8.6 & Up This document is written for licensed Elliott Software developers. It is not relevant for regular Elliott users. Overview With proper licensing, Elliott developers can follow these three steps to create a ...

    • Feature - User Defined CSV Export Item Batch Support

      Release Date - 2/5/18 This feature gives the user the ability to define a batch that can be used when running the User Defined CSV Export. The batch can be defined from I/M-> Reports-> User Defined CSV Report-> Maintenance-> User Defined CSV Batch. ...

    • Can System Default Item User-Defined Code?

      Q - When I add an item, can the system automatically default field "4. User Def Code" to "1"? See sample screen below: A - Yes, you can do so by first defining an item "DEFAULT-ITEM." Set the field "4. User Def Code" to "1." See sample screen below: ...