Feature - Add Serial Number to Mass Billing CSV Import

Feature - Add Serial Number to Mass Billing CSV Import

Release Date - 6/18/18

This feature allows the user to specify serial numbers when using the Mass Billing application and choosing the CSV Import option. The serial number is supported in column E of the CSV file:



The application will test for the following conditions in regards to the serial number field:
Error Conditions:
  • A serial number cannot be previously allocated
  • A serial number is not on file
Warning Conditions:
  • A serial number is provided for a non serialized item

If any error conditions are encountered, the application will not allow the import of the data and the user will see the message "Errors Present - Import Aborted! - CSV file not deleted ***".

Here is an example of the report output when an error condition has been encountered:



Programs Added: CPLSWRK.SL, CPLSWRK.FD, CPLSWRK.WS, CPLSWRK.DS, CPLSWRK.IO
Programs Modified: CP0300, CPSELIMS, CPSELIMV, CPSELIMP.PL, CPLINWRK.IO
CLS



    • Related Articles

    • Feature - Mass Billing by CSV Multi-Bin Support

      Release Date: 5/28/24 Version: 8.5 and Above Currently when a user chooses COP -> Billing Selection -> Mass-billing -> by CSV File and the multi-bin enhancement is enabled, the user will receive the error message "Multi-bin is not supported with this ...

    • Feature - Mass Billing By CSV Auto Select Negative Qty Ordered

      Release Date: 9/5/24 Version: 8.5 and Above A new Global Setup value has been added to COP-Func-> Billing that allows the user to specify if non-serial items with a negative quantity ordered will be automatically selected for billing if not provided ...

    • Feature - Mass Billing by CSV 3rd Party WMS and Event Support

      Release Date: 9/5/23 Version: 8.5 and Above If the 3rd Party WMS or Logistic Support is enabled, the first time a user runs the Customer Order Processing-> Processing-> Billing-> Mass Billing by CSV application the directory will default to the ...

    • Feature - Mass Billing by CSV Error Directory Support

      Release Date: 5/17/24 Version: 8.5 and Above This feature adds the ability to move Mass Billing import files that have errors to a separate directory when interfacing. This feature is useful to allow the user to correct the error with the CSV and to ...

    • Feature - Move Successful Mass Billing Import Files to Separate Directory

      Release date: 3/5/2019 Version: 8.2 and Up Added the ability to move successful Mass Billing import files to a separate directory. This feature is useful to create "Auditing" of the interfaced files if issues should arise later. First go to Global ...