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 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 - Create Shipment Verification Box Records Through Billing CSV Interface

      'Release Date: 9/19/19 Version: 8.5 and up This feature gives the user the ability to import the box number and the box ID when running the Mass Billing by CSV Import application. This feature is available to users running the add-on Shipment ...

    • 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 ...