Feature - Mass Billing by CSV Multi-Bin Support

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." This change adds multi-bin support to the Mass Billing application.

When the user chooses the Mass Billing by CSV option, the user is presented with three menu options: Pre-Interface, Interface, and Layout. The bin number is supported in column H of the CSV import file:



The following are the possible error messages related to changes for multi-bin support:
Bin No Size Exceeds Maximum Length of 8
Bin No Must Provided For Non-Serialized Item
Bin Inventory Record Locked At Another Workstation
Order On Staging Batch - Process Through Shipping Verification
Shipping Bin Not On File
Order Location Not On File
Invalid Write to Bin Work File

3PL/WMS Specific Messages:
Bin No Should Default Staging Bin No
Pick Ticket Cancelled - Order Cannot Be Billed

Warnings:
Total Line CSV Qty > Qty Available in this Bin
Item CSV Qty > Qty Available in this Bin
Location Not Multi-Bin. Bin No Ignored

The Pre-Interface output prints the detail information from the CSV import file. A bin number column has been added to the report.



The interface output includes the bin number in the CSV line print area.



3PL/WMS Support

If the third party WMS interface is enabled, this application works in conjunction with the WMS Inventory Move Import. This application will check if the inventory has previously been moved to the staging bin. If true, then the inventory is expected to be transferred from the STAGING bin (per Global Setup) to the Shipping bin as defined in the location file. However, if the picking ticket has been cancelled, the order cannot be billed through this application. If the inventory was not previously moved to the STAGING bin, the bin number should be provided through the CSV fileespecially if it is a non-serialized item. This is considered a one-step processing where inventory is directly transferred from the stocking bin to the shipping bin.

See the following for further information on some of the features of the Mass Billing by CSV application:


Programs Modified: CP0300, CPSELIMP.PL, CPMASBWK.FD
Programs Added: CPBINWRK,SL, CPBINWRK,FD, CPBINWRK.WS, CPBINWRK.DS, CPBINWRK.IO, CPSELIBS.CBL, CPSELIBV.CBL
CLS




    • Related Articles

    • 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 - 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 Initialize Freight Option

      Release Date: 8/28/24 Version: 8.5 and Above The Global Setup-> COP-Func-> Order Billing Screen option "Initialize Freight Amount In Order Billing" controls whether the freight amount on an order is set to zero when the billing screen is accessed in ...
    • 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 ...
    • 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 ...