Feature - Release Manually Held Orders

Release Date: 8/8/19
Updated: 10/16/19 - Support for Include/Exclude States added

Version: 8.5 and up

This new feature is similar to the Mass Release Held Order application in Global Setup -> Utilities -> COP Utilities -> Release Held Order. The Release Held Order utility can only be used to release orders that were put on hold by Elliott automatically. These orders will have a hold reason note that explains why the order was put on hold. The Release Held Order utility will check if such a note exists. Even though the Release Held Order utility can also print those orders that were put on hold manually (orders without a hold reason note), the utility will not release those orders. This is because the application does not know the reason why the operator manually put the order on hold in the first place. 

However, some users take orders on their website and place those orders on hold by passing the freight pay code = “H” when the order is created. This is equivalent to putting the order on hold manually and there is no held order note for that order. These orders have to be released  manually through the “Held Order Release” application. Due to the volume of orders created through the website, it may tedious to release all of the orders by hand. This new feature gives the user a way to automate this procedure.

Another menu choice  has been added to Global Setup for this new application - Global Setup -> Utilities -> COP Utilities -> Release Manually Held Order. 


1. Starting/Ending Order Number - Enter a range of order numbers or press Enter for all orders.

2. Starting/Ending Customer Number - Enter a range of customer numbers or press Enter for all customers. F7/F8 search by customer number/name is available.

3. Include or Exclude Customer Type - Valid options are: I=Include and X=Exclude. The default is “I.” Enter up to 5 customer types after entering I or X. If I=Include is used, the user can press Enter for all customer types. If X=Exclude is used, at least one valid customer type must be entered. F7 search is available for the customer type fields.

4. Include or Exclude Terms Code - Valid options are: I=Include and X=Exclude. The default is “I.” Enter up to 10 terms codes after entering I or X. If I=Include is used, the user can press Enter for all terms codes. If X=Exclude is used, at least one valid terms code must be entered. F7 search is available for the terms code fields.

5. Include or Exclude Ship Via Codes  - Valid options are: I=Include and X=Exclude. The default is “I.” Enter up to 10 ship via codes after entering I or X. If I=Include is used, the user can press Enter for all ship via codes. If X=Exclude is used, at least one valid ship via code must be entered. F7 search is available for the ship via code fields. 

6. Include or Exclude States  - Valid options are: I=Include and X=Exclude. The default is “I.” Enter up to 10 states after entering I or X. If I=Include is used, the user can press Enter for all states. If X=Exclude is used, at least one valid state must be entered. F7/F8 search is available for the state fields.

7. EDI Orders - Valid options are Y=Yes (only EDI orders), N=No (only non-EDI orders), or A=All (all orders regardless of the EDI flag). The default is A=All.

8. Order Ship Date <= - Press Enter for the System Date or enter a specific date. Entry of zeroes for "All" dates is not allowed. Users can manually enter 12/31/30.

9. Order Salesman - Enter a valid salesman or press Enter for all salesmen. F7 search by salesman is available.

10. Shippable Total Amount GE or LE - Valid options are: G=Greater Equal and L=Less Equal. The default is "G." Enter a comparison amount after entering G or L. The default is zero, which means all amounts.

11. For Orders with Shipping Instructions - Valid options are: N=Orders with No Shipping Instr. Only, Y=Orders with Shipping Instr. Only,  and A=All. The default is A.

12. Preview? - Enter "Y" to only preview orders for the release process. No update of files will occur. Enter "N" to process all orders with status of "Rel." The application will remove the held status on the Order Header record and write to the "release held order CSV log" if this feature is enabled.

13. Create CSV File ? Enter "Y" to create a CSV file using data found on the report.  Keep in mind that this is not the same as "release held order CSV log."

14. File Path & Name

A report is generated listing orders that meet the selection criteria an whether or not they will be released.


If the Create CSV file option is set to Y, a CSV file will be created with the following columns:

Order# - the order number

OrdDate - the order date

ShipDate - the shipping date

Cust# - the order customer number

ShpToName - the order ship-to name

ShipAmt - the order total amount to be shipped

Sts - the release status (either REL for release or blank if the order will not be released)

ReasonNotEligible - the reason the order will not be released

Also, you should be aware that when an order is released through the auto release manually held order utility, it carries a different weight than order is released through the "Release Held Order" function.  For example, you may choose to re-check order credit during pick ticket printing per Global Setup.  If the order is released through "Release Held Order," it will not be subject to pick ticket credit checking again.  If the order is released through "Auto Release Manually Held Order Utility," it still will be subject to pick ticket credit checking.  

Programs Modified: NSCTLUT4

Programs Added: CPRESMHS, CPRESMHP

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