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 Verification. This function is enabled through the setting Global Setup-> Add-Ons-> Shipment Verification-> Field 61. Import Box Info During Order Bill CSV Import.



61. Import Box Info During Order Bill CSV Import - The default value is N. If set to Y, users can specify two new fields during the Order Billing CSV Import - a box number and a box ID. 

Note: The box ID is only allowed if Shipping Verification is configured to collect box-level data. This is configured in Global Setup -> Add-Ons-> Shipment Verification-> Field 37. Collect Box Level Data. If this option is enabled, the collection of the data can still be disabled through a customer's EDI Trading Partner Profile.


 
If  Import Box Info During Order Bill CSV Import is set to Y, the Order Billing CSV Import layout screen will display the two new fields:




Column F: Box#
Column G: Global Unique Box ID

If these fields are not provided, the shipping verification files will not be updated. If the fields are provided, the following is a list of possible warning and error messages that may be received during the pre-interface or interface process.

Error: Box No Size Exceeds Maximum Length of 4 - Box number must be between 1 and 999.
Error: Not Configured To Import Box No.- This means a box number was provided but Elliott is configured to support this field during import.
Error: Box ID Size Exceeds Maximum Length of 9 - Box ID must be between 1 and 999999999.
Error: Box ID Already On File In CPBOXFIL - The box ID has been previously imported or created through Shipping Verification.
Error: Box ID Of Zero Already On File For This Box No. Box ID Should Not Be Provided - A box number was previously provided in the ASCII file without a box ID. 
Error: Box ID Provided Does Not Match Box ID On File For This Box No. - A box number was provided for a box ID with a different box number.
Error: Not Configured To Import Box ID - This means a box ID was provided but Elliott is not configured to use box IDs.
Error: Box ID On File For Another Box No. - A box ID is already on file with another box number. 

If using box IDs and only box numbers are provided in the ASCII file, the application will retrieve a new box ID from Global Setup for each unique box number per order.

If using box IDs and only box IDs are provided, the application will process the data in the order of the ASCII file and assign the box number based on the box ID provided.

If not using box IDs and the box numbers are provided, the application will use what was provided when creating the box shipment records.

If not using box IDs and the box numbers are not provided, it is assumed that box shipment records should not be created for the order.

BoxNo and BoxID columns have been added to the pre-interface report. If using box IDs and the box ID is not provided, the application will print TBD during the pre-interface. The box ID will not be assigned until the interface is run.



The Mass Billing By CSV File Journal now provides the user with a list of the data from the ASCII file for their reference.



Programs Modified: NSCTLFIL.FD, NSCTLFIL.W33, NSCTLINI, NSCTLMNV, CPSELIMP.PL, CPSELIMS, CPSELIMV
CLS

Elliott Version 8.5

  1. V8.5 Alpha Document Number Support
  2. Crystal Report Conversion for V8.5
  3. The Run Local or Hybrid Feature in Elliott 8.5
  4. How to Use EL850DB.EXE Utility to Create PSQL Databases
  5. Showing Document Date in Links After Elliott 8.5
  6. The Lessons We Learned from Upgrading Web Service 8.2 to 8.5 in eStore
  7. Feature - ASCII File Filter Condition in Mass Email and Export Processor
  8. Feature - List Users Acively Logged into Elliott and Optionally Send Email
  9. Feature - Allow Print One Invoice to Print Duplicate Invoices for Order Not Posted
  10. Feature - Print Range of Duplicate Unposted Orders
  11. Feature - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File
  12. Feature - Last Year Net Income Layout Support
  13. Receive Message "Not Found" When Trying to Set Up Run Local
  14. Receive 'Invalid Column Name' Message After Starting to Use Alphabetic Document Numbers
  15. Feature - Invoice Log Report
  16. Feature - Add Sales or Usage to Where-Used inquiry
  17. Feature - Case Size Support for Quantity Per Box
  18. Feature - Exclude Obsolete Customers from Customer Generic Search
  19. Feature - Refresh VICS Bill of Lading
  20. Feature - Support Item Case Size in New Item CSV Import and Change Existing Item Import
  21. Feature - Copy Notes, Attributes, and Links When Copying Item Through the New Item CSV Import
  22. Feature - Enhanced Cash Receipts Processing Apply-To Range
  23. Feature - Add Links Import to System Files Setup
  24. Feature - Shipment Email Acknowledgement for Bill-To Customers
  25. Feature - Restrict Sending Tracking Number to Bill-To Customer in Shipment Email Acknowledgement
  26. Feature - Allow Source Range on Credit Card Log Report
  27. Feature - Indented Bill of Material CSV
  28. Feature - Stock Status Reports Add Include with Alloc or On Order Quantity Option
  29. Feature - Release Manually Held Orders
  30. Feature - Create Shipment Records When Complete Bill Of Lading
  31. Feature - Print Warning Msg for Cancelled PO Line Item
  32. Feature - Export 25-Character PO Number in Expanded Aging Report CSV File
  33. Feature - Show Pending Cash Receipts in Payment History Inquiry
  34. Feature - Show Customer Note Fields in Payment History Inquiry
  35. Receive "Error Getting List of Override Reports" When Printing Report
  36. Feature - Fields Added to User-Defined CSV to Support EDI 846
  37. Feature - Credit Memo Warning When Fully Paid
  38. Feature - Create Shipment Verification Box Records Through Billing CSV Interface
  39. Feature - Show Box ID on Order Inquiry Shipment Data Screen
  40. Feature - Print Error Message If Inventory Transaction Distributions Are Missing
  41. Feature - Customer CSV Import
  42. Feature - Alleviate Error 25 When Two Users Import Sales Orders Simultaneously
  43. Feature - Use Note Type for Special Instructions on VICS BOL
  44. Feature - VICS BOL to Enforce Shipment Verification Before Printing of BOL
  45. Feature - Order/Invoice Inquiry Box Serial Number Drill Down
  46. Feature - Delete Order Tracking Note When Void Completed VICS BOL
  47. Feature - Picking Ticket For Customer 2 Event
  48. Feature - Set All Options to Allow or Disable in User Global Security
  49. Feature - Stock Analysis Creation by Customer Range
  50. Feature - Print Work Order Planned Hours on Plus Work Order Traveler
  51. How to Ensure Local Elliott Folder Is Up to Date
  52. Feature - Global Setup Flag to Update Tracking Note from Box Data Window
  53. Feature - Packing List by Box One Box Per Page
  54. Feature - Move EDI Profile Maintenance Maximum # of Item Per Label
  55. How to Update Elliott 8.5 License Key Code
  56. Installing Elliott 8.5 and Received "PSQL v11, v12 or V13 Is Required" Message
  57. Feature - Warehouse Receiving Missing Item Attribute Event
  58. Feature - Added a Drill Down to Order by Item Inquiry in Newly Received Items Inquiry
  59. Feature - Customer Type Display in Pick Order Processing
  60. Elliott V8.5 Configuration Utility (EL850CF.EXE)
  61. Feature - Add Customer Type to Pick Ticket Selection
  62. Feature - Void Checks after Posting Warning for Multiple Checks
  63. Error 1315 Unable to Write to the Specified Folder When Installing Elliott 8.5

Feedback and Knowledge Base