Feature - Add Serial Number Support to PO Warehouse Receiving Import

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

    • Feature - Add Global Setup Flag in Warehouse Receiving to Prevent User from Posting All POs

      Release Date: 05/06/2020 Version: 8.5 & higher We added the following flag in Global Setup -> Dist -> PO Warehouse Receiving: 11. Allow to Post ALL PO by ENTER a Starting PO? The default value is "Y." See sample screen below If you set this value to ...

    • Feature - Add Events for Addition of PO Header and Line

      Release date: 3/28/18 New events have been added that can be set up to trigger when adding new Purchase Orders. Purchase orders can be added through: PO -> Processing -> 1) Purchase order processing - Add 2) Purchase order processing - Change, F3 = ...

    • Feature - Mult i-Currency Amount Display Support in Purchase Order

      Release Date: 4/14/25 Version: 8.5 and Above This feature allows the purchase order application to show the line item cost in the vendor’s currency using currency conversion rates. This applies to the purchase order line item screen, several reports, ...

    • Feature - Purchase Order Line Item Discount

      Release Date: 4/14/25 Version: 8.5 and Above This feature adds a second option for handling purchase order line item discounts. The feature is controlled by the Global Setup, PO Global Control, field "43. Enter PO Line Item Original Price & Disc%.” ...

    • Feature - PO Header EDI Flag

      Release Date: 2/3/22 Updated: 2/15/22 Version: 8.5 & Up PO Header EDI Flag A purchase order header EDI flag has been added. See following sample screen. The purpose of this flag is to add finite control to determine which PO should be exported for ...