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 file, especially 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

    • Avalara Attribute Support

      Release Date: 4/28/23 Updated: 1/26/28 Version: 8.6 and Above For Elliott to work with the Avalara Sales Tax Interface, there are additional data to be stored on the Elliott side. Our implementation chooses to store these data in the following ...

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

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