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

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

    • ARECIMNT Accounts Receivable Customers and Contacts Import Utility

      Last Update: 03/20/2024 Version: 8.0 & Higher Introduction This utility was the first utility we developed to handle the import and update of customers and contacts at the same time. Since then, we have developed a separate utility to import or ...

    • CP0300 Customer Order Processing Order Billing

      Order Billing Application Overview Order Billing is an application that will be used routinely. Regardless of which billing procedure you implement you will at least print invoices. The two billing procedures and other related concepts are explained ...

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