Feature - Stock Analysis Processing

Release Date: 10/28/16

This new feature is available under COP -> Processing -> Pick/Pack Tickets/Ship Labels-> Stock Analysis.

This new feature is only available when the QTYAVAILBYCOMP, QTYAVAILBYCOM2 and QTYAVAILBYCOM3 attributes are in use. These attributes should be set up with the following values:





QTYAVAILBYCOMP attribute is designed for a special industry (faucets) where most of Elliott users does not apply. Therefore, this Stock Analysis feature is special add-on feature that's not applicable to most of Elliott users.

Stock Analysis function can perform the following:
Create Batch for up to 10 customers, based on an order number and entry date range.
User can review the orders in this range by line item and determine whether the order should be:
Canceled (it is not stocked, not possible to make, and not scheduled to be received).
Back Order (it is not stocked, not possible to make, but scheduled to be received).
Create Work Order (it is not stocked, but we have inventory to make the work order).
Pick from Stock
User can assign the status to the line item for the proper action. But the action does not take place until the user posts the batch.
User can optionally print an edit list to view all line items on the batch. This will provide similar information as the review screen, but in a print format.
Posting the batch will result in performing the actual actions. This includes:
Cancel the line item or order (if all line items on this order are canceled)
Back order the line item
Create Work Order


Even after the batch is posted, the user can still come back and see the progress status of the batch. When print edit list is chosen after the batch is posted, the system will provide additional information on the status of the line item.

The batch will be deleted once all line items in the batch are posted, canceled, or deleted. This action will be evaluated at the time of invoice posting.

Stock Analysis Processor

The main user interface will bring up the following window:



The cursor will be at the “Bat#” field. At this moment, the user can either enter an existing batch number or create a new batch. The F7 search key is supported.  The user is prompted for “User” first, which will default to the current USER ID. The user can erase it to make it “All” users. Or the user can press the F7 key to search for users who currently have batches on file.


After the user is selected, the search will prompt for “Batch” which defaults to blank. If user hits enter, then “All” batches will be returned for the user specified. The user can also enter a partial or full Batch ID to search. 


When creating a new batch, the application will prompt for up to 10 customers, an order number range, and a date range for each customer.



Based on the customers and ranges entered, the application will read the Elliott Order Files and import all related line items to create the batch.

In the above screen, a list of line items in the batch is displayed in the window. By default, the list is sorted by order number and line item sequence. The user can then evaluate the orders on a line item by line item basis to decide what to do for each line. Pressing Enter on the highlighted line item changes the status of the line item. Before the batch is posted, the line item status can be:
                Blank = Status is not assigned yet
                I = From Inventory
                C = Close This Line Item
                B = Back Order
                W = Create Work Order

Before the batch is posted, the user can change the above status from one to the other. But once the batch is posted, the user can no longer change this status. When the user reviews the posted batch, each order line item, in addition to above, could have the following status:

B = Back Order
W = Work Order Created
P = Pick Ticket Printed
T = Tracking Number Created
5 = 855/865 Sent
H = Order is on Hold
D = Order/Line Item Deleted
C = Line Item Has Been Closed
X = Line Item Has Been Cancelled 
A = ASN sent                
S = Selected/Invoiced
Z = Order Posted


The status field shown on the screen is a 5-character field that consist of 5 flags.

Flag 1 – Action Code can be Blank, I, C, B or W. This is the action that the user manually entered.
Flag 2 – Status (any value except P, 5 and A) – this can be Blank, B, W, H T, D, C, X, S, or Z. This is the current status of the line item.
Flag 3 – Pick Ticket Printed Status can be P or blank.
Flag 4 – 855/865 Sent Status can be 5 or blank.
Flag 5 – ASN Sent Status can be A or blank.

When the batch was first created, it was also possible that some of the orders and line items had been processed already, which may result in status code of the above value.

In the above sample screen, line 06/07 represents the total summary:
Stock – Total number of line items will or have been shipped from stock (before or after post)
BOMP – Total number of line items will or have created work order (before or after post)
BO – Total number of line items will be or have been back ordered (before or after post)
Cancel – Total number of line items will be or have been canceled (before or after post)
TtlLine – Total number of line items in this batch. Ideally, TtlLine = Stock + BOMP + BO + Cancel. If not, it’s an exception (like delete)
TtlOrd# - Total number of orders in this batch.
Pick – Number of orders have been printed with pick ticket already.
W/Trx# - Number of orders that have a tracking number.
Sel/Inv – Number of orders that have been selected for billing or printed with invoice.

The lines 09-18 are the line items area, which has the following columns:
Order# - This is the order number
Item# - This is the item number
Order – This is the line item quantity order
Stock – This is from attribute QTYAVAILBYCOMP3 – Stock Qty Avail (Neg) 
BOMP – This is from attribute QTYAVAILBYCOMP – BOMP Qty Avail
Schedule – This is from attribute QTYAVAILBYCOMP – Schedule Qty Avail
S – This is a Y or N field from QTYAVAILBYCOMP – Schedule Qty from Stock
Sched-Dt – This is from QTYAVAILBYCOMP – Next Schedule Date
R – This is a Y or N field from QTYAVAILBYCOMP – Sched Qty-RR Status
Prom-Dt – This is the promise date of the line item. User can back order this line and change to a different date.
Status – This is the status field as described previously.

As the user highlights each order line item, the application will display the Bill To Name and Ship To Name of the order on the top at line 04/05. The Ship Via, Order Number Range, Order Entry Date Range and BOMP Work Order Number are displayed on line 6. Also, the bottom lines under the item list will also be re-displayed to reflect the item following information:


Item# - Item Number
Desc1 – Item Description 1
Desc2 – Item Description 2
PO Sched-Dt – This is from QTYAVAILBYCOMP3 – Next PO Date
PO Qty – This is from QTYAVAILBYCOMP3 – Next PO Qty
PO RR – This is a Y or N field from QTYAVAILBYCOMP3 – next PO Qty-RR Sts
BOMP Sched-Dt – This is from QTYAVAILBYCOMP3 – Next BOMP Date
BOMP Qty – This is from QTYAVAILBYCOMP3 – Next BOMP Schedule Qty Avail
BOMP RR – This is a Y or N field from QTYAVAILBYCOMP3 – Next BOMP Qty-RR Sts
Prod Cat - Product Category
Product Class - User-Defined Code
The “Weight” field represents the “Extended Weight” = Qty Order * Unit Weight.
The field “Max” at the bottom represents the “Maximum Qty Order” by reading through ATP for all sales order type
The P/M column value could be P, M, MP, MM and K (kit).


The very bottom line contains the literal of what function keys the user can use in this window:

Up – Up arrow key
Dn – Down arrow key
PgUp – Page Up key
PgDn – Page Down key
Ent=ChgSts – When the user presses Enter on a line, it means to change the status of this line. See above detail on status field
F1=Sort – By default, the line item will be sorted by order number + line item sequence number. User can use this key to re-sort by the following sequence:
Item Sequence – sort by item number + order number sequence
Stock Sequence – sort by stock qty, bomp qty, schedule qty and schedule date
Status Sequence - sort by status, order number, item number
F2=Stk – This will drill down to stock status inquiry screen
F3=Ord – This will drill down to order inquiry
F4=WO – This will drill down to work order inquiry if the line item is copied to BOMP.
F5=Refresh – As the user changes the status of each line item, the stock, BOMP or schedule qty is not changed. Therefore, it is possible that users may go over certain quantities without knowing it. The solution is the user can press F5, which results in the system re-evaluating the status that was entered and will set the current quantity balance of stock, BOMP and schedule. When the user exits out of the batch and comes back in again, these quantities will be recalculated again. This includes considering quantities on other batches as well. The following lines items should be used to deduct quantity: When the user brings up a batch, or when the user presses F5=Refresh, the system will calculate the following columns in real time:
Stock – This is from attribute QTYAVAILBYCOMP – All Loc Qty Avail
BOMP – This is from attribute QTYAVAILBYCOMP – BOMP Qty Avail
Schedule – This is from attribute QTYAVAILBYCOMP – Schedule Qty Avail
S – This is a Y or N field from QTYAVAILBYCOMP – Schedule Qty from Stock
Sched-Dt – This is from QTYAVAILBYCOMP – Next Schedule Date
R – This is a Y or N field from QTYAVAILBYCOMP – Sched Qty-RR Status

This is the same calculation as in the utility program to “Update Qty Avail. By Comp. Attribute” in Global Setup. After the system is done with the calculation in real time, it will update the QTYAVAILBYCOMP attribute and reflect the last changed user, date and time.


F6 (implied note support) - Allow adding notes to the order
F7=Opt – Advanced Options:
Provide a function “Assign ‘I’ status for rest of items”. This function will look at all line items with a blank status and convert them to “I” (from Inventory).
Allow users to print pick ticket or packing list (including DYO), one at a time.
Allow user to change the Order Frt/Ord Status
Allow user to Release a Held Order
Allow user to change the Ship Via Code
Allow user to change the Order Shipping Date
Ability to delete a batch
Ability to delete an order from the batch
Ability to add a range of orders to a batch (not allowed once it is posted)
Ability to merge on batch with another
Display a legend explaining the status field

Security – The user who created the batch can change and delete the batch. The supervisor (base or supervisory relationship) of this user can also change/delete the batch. The hardcoded user SUPERVISOR is always considered as the supervisor regardless of the supervisory relationship. A user who is not the creator of the batch or the supervisor of the creator of the batch cannot change, delete, or post the batch. However, they can print the edit list for the batch or they can view the batch through the Stock Analysis Processing application.

Stock Analysis Processing Edit List



Starting Batch - With F7 search
Ending Batch - With F7 search
User ID – Spaces for all
Export to CSV? – Store answer in registry and default to last entry. Default is N.
CSV File Path & Name – Store answer in registry.



This report will also have CSV Support. The following columns are included:
Batch - CPSABATL-BATCH    
User – CPSABATH-USER-ID
Date – CPSABATH-DATE
Time – CPSABATH-DATE
Cust# - ORDER-CUSTOMER-NO 
CustName – ORDER-BILL-TO-NAME
Order# - CPSABATL-ORDER-NO
PONo - ORDER-PURCHASE-ORDER-NO + ORDER-EDI-PO-NO-CONTINUED
ShipToName – ORDER-SHIP-TO-NAME
State - ORDER-SHIP-TO-ST
ZipCode - ORDER-SHIP-TO-ZIPCD
Via – ORDER-SHIP-VIA-CODE
Terms – ORDER-TERMS-CODE
Slsmn – ORDER-SALESMAN-NO(1)
Enter – ORDER-DATE-ENTERED
Order - ORDER-DATE
Ship - ORDER-SHIPPING-DATE, show "A.S.A.P." if zero value.
Pick – ORDER-DATE-PICKED
Sel – ORDER-DATE-BILLED
Inv – ORDER-INVOICE-DATE
TrackNo – tracking number in the NOTE file      
Loc – ORDER-MFGING-LOCATION
FrtPayCD – ORDER-FREIGHT-PAY-CODE
ShipInstr1 – ORDER-SHIP-INSTRUCTION(1)
ItemNo – CPSABATL-ITEM-NO
LineItemDesc1 – LINE-ITEM-DESCRIPTION-1
LineItemDesc2 – LINE-ITEM-DESCRIPTION-2
QtyOrd – LINE-ITEM-QTY-ORDERED
QtyShip – LINE-ITEM-QTY-TO-SHIP
QtyBO – LINE-ITEM-QTY-BACK-ORDERED
Price – LINE-ITEM-UNIT-PRICE
Disc% - LINE-ITEM-DISCOUNT-PCT
UnitWght – LINE-ITEM-UNIT-WEIGHT
StockQty - This is from attribute QTYAVAILBYCOMP – All Loc Qty Avail 
BOMPQty - This is from attribute QTYAVAILBYCOMP – BOMP Qty Avail 
SchedQty - This is from attribute QTYAVAILBYCOMP – Schedule Qty Avail
SchedDt - This is from QTYAVAILBYCOMP – Next Schedule Date
PromDate - If CPSABATL-NEW-PROMISE-DATE is not = zero, use that date. Otherwise, it is the LINE-ITEM-REQUEST-DATE or LINE-ITEM-PROMISE-DATE depending on Global Setup values.
WO – LINE-ITEM-BM-ORDER-NO
Sts – Status Field as defined above.

Stock Analysis Processing Register



Starting Batch - With F7 search
Ending Batch - With F7 search
User ID – Spaces for all



Programs Added: IMQACOMP.WS, IMQACOMP.PL, CPSABATH.SL, CPSABATH.FD, CPSABATH.WS, CPSABATH.DS, CPSABATH.IO,  CPSABATC.SL, CPSABATC.FD, CPSABATC.WS, CPSABATC.DS, CPSABATC.IO, CPSABATL.SL, CPSABATL.FD, CPSABATL.WS, CPSABATL.DS, CPSABATL.IO, CPSABATO.SL, CPSABATO.FD, CPSABATO.WS, CPSABATO.DS, CPSABATO.IO, CPSABGEN.WS, CPSABGEN.PL, CPSABMNU, CPSABGEN, CPSABSCN, CPSABLST, CPSABPRC, CPSABPSC, CPSABPST, CPSABUPD, CPSABGN2
Programs Modified: CP0200, CP0305, IMQACOMP, IMQACOMS

CLS


Customer Order Processing

  1. CP0000 Customer Order Processing Overview
  2. Common Reasons Why Pick Ticket Does Not Print
  3. How Do You Purge Quote Type Orders?
  4. Order Lookup by Customer and Ship-To
  5. Btrieve Error USE on COP Lock File
  6. How to Send Shipping Confirmation Email to Customer
  7. Order Inquiry Searching by Customer's PO (Purchase Order) Number
  8. Can We Turn Off the Ability for Users to Enter Orders for a Customer on Credit Hold?
  9. How Do I Remind Salesmen to Send Order Acknowledgment?
  10. Is There a Way to Export and Import Price Code Files?
  11. Can a Credit for Kits on an Order Return Components to Inventory?
  12. How to Add System Date and Time on Laser Pick Ticket
  13. What Triggers the Billing Edit List to Display an O/S Instead of Quantity in the Back Order Field?
  14. How to Subscribe to Add Order Event So I Only Receive E-mail When Credit Memo Is Created
  15. Manually Changed Sales Tax and Commission in Billing Screen Recalculates Again During Billing Selection
  16. Can Item Lead Time Be Added to the Sales Desk Screen?
  17. All of a Sudden COP Open Order Report Takes Forever to Complete
  18. Purge COP Sales Order with No Line Item
  19. The Top Barcode Will Not Scan on Pick Ticket
  20. Invoice Only Prints First 10 Characters of Purchase Order Number
  21. Why Would Invoice Balance Due Field Be a Credit?
  22. Open Order / Invoice History Inquiries GUI Windows Show No Column or Data
  23. Can the 'Design Your Own Picking Ticket' Feature Print in Pick Sequence?
  24. How to Lock a Sales Order from Being Changed
  25. What Do I Do With "Invoice Printed But Not OK" Orders?
  26. Warn Users When Entering COP Orders for Items Below a Certain Margin
  27. Can Elliott Support Gift Cards or Gift Certificates?
  28. How to Stop Changing Sales Order with Shipment Tracking (Starship) Note
  29. Received Message "Must Run COP Setup First"
  30. What Are CP3HSxxx.BTR Files? Can We Delete Them?
  31. Restrict User from Changing Price in COP Line Item Screen
  32. How to Determine Who Receives Shipping Confirmation Email
  33. How to Create Invoices and Credit Memos Without Updating Item Quantity through Phantom Invoice
  34. Feature - Print Outstanding Transfers Through Invoice Edit List
  35. Feature - Date Used to Determine Price When Adding Item to Existing Order
  36. Feature - Order Release Time by Warehouse Location
  37. Newly Received Items Inquiry Not Showing Proper Column as Labeled
  38. Credit Memo with Qty Return Will Reduce Qty Sold in Sales History
  39. Feature - Order Release Log File
  40. Feature - F7 to Print Duplicate Invoice in Invoice History Inquiry
  41. Feature - Receive COP Transfer Order Event
  42. Feature - Location Mask Added To Label File Name
  43. Feature - Support for Minimum Price Changes in Future Price Maintenance and Import
  44. Feature - Added Customer Type to Invoice Print Programs
  45. Feature - Order Acknowledgment Email Contacts
  46. How to Correct Wrong Invoice Date Once It is Posted
  47. Feature - Show Previous Qty OH in Newly Receive Inquiry
  48. Feature - Order Line Item Screen to Prompt WO Type, Buffer Days and Lead Time
  49. Feature - Add Selection Criteria to Print Duplicate Invoice Screen
  50. CP07S1 Customer Order Processing Backorder Audit Trail Report
  51. CP0102 Customer Order Processing Copy Order
  52. CP0308S1 Customer Order Processing Purge Invoice History
  53. CP0400M Customer Order Processing Order Inquiry
  54. CP0400V Customer Order Processing Void Invoice
  55. CP0406 Customer Order Processing Freight Calculation Inquiry
  56. CP0500 Customer Order Processing Sales History Processing
  57. CP0501 Customer Order Processing Sales History Trx Processing
  58. CP0502 Customer Order Processing Post/Purge Sales History Trx
  59. CP0200 Customer Order Processing Print Pick/Pack Tickets and Ship Labels
  60. CP0300 Customer Order Processing Order Billing
  61. CP0503 Customer Order Processing Sales History Reports
  62. CP0504 Customer Order Processing Sales Analysis Reports
  63. CP0507 Customer Order Processing Sales History Period File Maintenance
  64. CP0600 Customer Order Processing Order Status Reports
  65. CP0800 Customer Order Processing COP Setup
  66. CP0701 Customer Order Processing Fill Backorders
  67. CP0901 Customer Order Processing Price Code File Maintenance
  68. CP1001 Customer Order Processing Ship-To File Maintenance
  69. CP01012 Customer Order Processing Newly Received Item Inquiry
  70. CP1101 Customer Order Processing Product Cat/Loc Acct File Maintenance
  71. CP1200 Customer Order Processing Mass Price Change
  72. CP1400 Customer Order Processing Price List Report
  73. CP1600 Customer Order Processing Clear I/M & A/R Accumulators
  74. CP1700 Customer Order Processing Invoice History Inquiry
  75. CP1720 Customer Order Processing Invoice History Report
  76. CP1725S Customer Order Processing Print Duplicate Invoice
  77. CP1800S1 Customer Order Processing Purge Line Item Audit
  78. CP1900 Customer Order Processing Line Item Auditing Inquiry
  79. CP1920 Customer Order Processing Line Item Auditing Report
  80. CPCDPSCN Customer Order Processing Customer Delivery Performance Report
  81. CPCMSMNT Customer Order Processing Sales Commission File Maintenance
  82. CPCNLORD Customer Order Processing Cancel Order
  83. CPCNLPIC Customer Order Processing Cancel Picking Ticket
  84. CPCONMNT Customer Order Processing Contract Pricing
  85. CPCUSITM Customer Order Processing Customer Item File Maintenance
  86. CPCWLPSN Customer Order Processing Purge Customer Wish List
  87. CPCWLSCN Customer Order Processing Customer Wish List Report
  88. CPEXPMNU Customer Order Processing Sales Order Export
  89. CPFUTMNU Customer Order Processing Future Price File Maintenance
  90. CPIMPMNU Customer Order Processing Sales Order Input
  91. CPISSULS Customer Order Processing Issue Serial/Lot Component Items
  92. CPOLSMNT Customer Order Processing Order Serial/Lot File Maintenance
  93. CPOPNSSN Customer Order Processing Open Orders by Salesman Report
  94. CPPAYSCN Customer Order Processing Payment History Report
  95. CPPICMNU Customer Order Processing Pickup Processing
  96. CPPORGSN Customer Order Processing Generate P/O Reference
  97. CPPURSDQ Customer Order Processing Purge Sales Desk Quote
  98. CPQCMMNT Customer Order Processing Quotation Comment Maintenance
  99. CPR01MNT Customer Order Processing User-Defined Code Maintenance
  100. CPR02MNT Customer Order Processing User-Defined Code/Year File Maintenance
  101. CPR03MNT Customer Order Processing Customer User-Defined Code/Year File Maintenance
  102. CPRECMNU Customer Order Processing Recurring Order Processing
  103. CPRESORD Customer Order Processing Release Held Orders
  104. CPRMEMNU Customer Order Processing Print RMA Acknowledgement
  105. CPROIMNU Customer Order Processing Recurring Order Inquiry
  106. CPSBMENU Customer Order Processing Shipment Confirmation
  107. CPSETCUS Customer Order Processing Reset Customer Sales/Cost
  108. Feature - ACH Warning When Changing Order Terms
  109. CPSLSDSK Customer Order Processing Sales Desk
  110. CPFRMMNT Customer Order Processing Invoice Form Setup
  111. Feature - Transfer Qty On Order Status Reports
  112. Feature - Shipping Verification Item Event
  113. Why Does the Sales Order Date Not Match the Entered Date?
  114. Change – Add Salesman No. to Open Order Report by Customer, Change CSV Order of Fields
  115. Feature - Purge WMS Staging Batches
  116. Feature - Sales Order Import Line Item Event
  117. SCLAYOUT Sales Desk Change Customer Data Window
  118. SDLAYOUT Sales Desk Screen Layout
  119. XCP0352 Customer Order Processing Print Invoices
  120. Global Setup for Invoice Printing Time Release Flags
  121. Feature - Order Ship Status Auditing Report
  122. Feature - Check for Duplicate PO During Sales Order Import
  123. Feature - Print Staging Slip by Range Selection of Bin Numbers
  124. What's The Bar Code Symbology Used on Pick Ticket Heading Area?
  125. My Users Are Not Able to Void COP Invoice After Elliott Update
  126. Feature - Display Usage of Item Customer Usage from Inventory Transactions
  127. Feature - Sales Order Import To Warn If Sales or Weight Greater Than Certain Value
  128. Close Transfer Order Requires Resetting ATP and Qty. on Order
  129. Feature-Change EDI Flag in Order Entry
  130. Feature - Control Packing List Print Depending on Work Order Creation
  131. Feature - Sales Promotion Desk
  132. Feature - Staging Slip Ability to Select Only Order With or Without Work Order
  133. Feature - Stock Analysis Processing
  134. Feature - Cancel and Close Order Option Added to Cancel Pick Ticket Application
  135. Feature - Ability to Process Shipment Verification Over Multiple Days If Using Billing Selection
  136. Security Flag to Allow User to Change COP Incomplete Order to Complete
  137. Feature - Added Payment Inquiry Option to Order/Invoice Inquiry Applications
  138. Feature - Ability to Change EDI Import Path
  139. Feature - Two-Location Support In Sales Desk
  140. Feature - Print Packing List by Box Number
  141. What Do the Statuses Mean on the Order Inquiry Screen?
  142. Feature - Added “Show Customers with Pending Payment Only?” to Release Held Order with Filters
  143. Order Already Shipped. Cannot Be Cancelled Until Shipment Cancelled
  144. Feature - Auto Release Held Order Utility
  145. What Other Programs Can Update Order Date Picked Field?
  146. Feature - Added "Put Away Slip" Section to Staging Slip
  147. Feature - COP Custom Product Structure to Show Price & Cost
  148. Feature - Not Allowing All Customers When Printing Pick Ticket
  149. Feature - Restrict Access to the Open Credit Field in the Order Payment Window
  150. Feature - Add First Line Bin Number Sort to Picking Ticket
  151. In Order Line Item Screen, Got Message "Qty Available Had Changed While You Enter This Line Item"
  152. Feature - New Summary Area for Open Orders by Customer / Fill Back Orders by Customer Report
  153. Suggestion to Implement PDF PostOffice Invoice Based on Invoice History
  154. Why Order Taxable Flag Does Not Change After Customer Taxable Flag Is Changed
  155. How to Export Price Codes to CSV File
  156. How to Create Credit Memo from Invoice History
  157. Feature - Drop Ship Enhancement
  158. Feature - Negative Discount Percent Support
  159. Automatically Create Invoice History Summary by Date Through Defer Processing
  160. Feature - Option to Include Salesman 2 and 3 in the Order Edit List CSV File
  161. Feature - Replacement Sales Order Import to Keep Changed Promise Date
  162. Suppress Nothing in Range Message with Laser Order, Quote and RMA Acknowledgement
  163. Feature - How to Not Update Previous Tracking Note in Shipment Data Update
  164. Feature - Shipment Data Update Event
  165. Feature - Override or Filter Invoice Form Number
  166. Feature - Create ASN Label Records in Order Inquiry
  167. Feature - Print One Invoice with Form Selection

Feedback and Knowledge Base