Feature - Add Serial Number Support to PO Warehouse Receiving Import

Release Date - 6/25/18

In Elliott, the PO -> Processing -> Utility -> Warehouse Recv Import application supports receiving through CSV file import. The CSV file currently supports the following columns:

• Vessel ID 
  
• Vessel Comment
  
• Vessel Receiving
  
• Vessel Inv/Doc No
  
• Vessel Shipped Date
  
• Vessel Arrival Date
  
• Trx PO Number
  
• Trx Line Number
  
• Trx Item Number
  
• Trx Quantity
  
• Trx Unit Cost
  
• Trx Comment
  
• Trx Receiver
  
• Trx Inv/Document No
  
• Receiving Description
  
• Close PO Line Item
  

This feature adds serial number support to the PO Warehouse Receiving Import application. This is supported by the addition of a new Serial Number column (Column Q) in the CSV file layout.

 
Serial Number (Column Q): If the received item is serialized, then the serial number must be provided. Otherwise, the “Serial No” column should be blank. If the serial number is provided, then the “Trx Quantity” (Column J) should equal to “1.”  The total “Trx Quantity” is implied by the number of serial numbers provided In the CSV file.

In the example below, purchase order 531-00 line number 1 was for the serialized item CLSERIAL. Ten lines were provided in the CSV file. Each has a transaction quantity of 1. They are accumulated and shown as a total receipt quantity or 10. 

NOTE: This program will analyze the entire CSV file, looking for errors. If any are encountered, this is noted with the "Errors" message in the status column. If the errors are found during the interface process, none of the records in the CSV file will be imported. The errors must be corrected before the records can be imports. If this occurs, the message "Errors Present - Import Aborted! - CSV file not deleted" is provided at the end of the report.

Programs Modified: POWRIMNT, POWRIIMP

DLM and CLS

• Related Articles

• Create PO Receiving Event to Trap Negative Qty on Hand Problem

  Q - Sometimes our receiving department is behind with their tasks in updating received quantities in the Elliott inventory. As a result, it creates a negative quantity on hand in Elliott. The items sold during the period use the old average cost. ...

• Feature - Support Serial Cross Reference in PO Warehouse Receiving Maintenance and Import

  Release Date: 2/7/19 This feature adds support for the entry of a box or case for serialized items in PO Warehouse Receiving. This option is available if serial cross reference is enabled in Global Setup-> System-> Serial No. Tracking Control-> Field ...

• Feature - Warehouse Receiving Serial Number Validation

  Release Date: 7/26/2016 When processing receipts through PO -> Processing -> Warehouse Receiving, the new feature will validate serial numbers that are entered/scanned for the item and prevent invalid serial numbers from being received into Elliott ...

• Can You Explain How Elliott Stores Serial Numbers in Its Database?

  Q - Can you explain the various Lot/Serial files (IMLSHST, IMLSTRXS, IMSERREF, etc) - how/when they are populated/updated by the Elliott application and how they relate to other files? A - Here is a highlight of each one of the Elliott database ...

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