Feature - Added a Function "Create Inventory Trx CSV Import"

Release date: 12/29/2016

Updated:          2/21/2017

Updated:          4/25/2017
Updated:          5/2/17

Added a function to IM / Maintenance / Item file / Create /  Create Inventory Trx CSV Import to automate the receipt of inventory items thru returned inventory. This application also generates a report of all of information that was entered on the screen.

Notes on the import screen:

1) The Dist Type is required and cannot be blank.

2) When on the Item No/SO# field, you may press F4 to see transactions created to this point, enter a valid item number, or enter a sales order number. As of 4/25/17, you may also enter a number, from 1 to 99.  The number will be understood to be the quantity.  If no number is entered, the quantity will default to 1.  The quantity field is no longer directly updated.

 If a sales number is entered, a separate window will appear with valid lines for that sales order.  See further explanation below.

Pressing F4 on the Item No/SO# field will open this screen, which allows delete, change and F1 for stock status.

If a sales order was entered, valid line items will appear on this screen.  Enter "C" to change, "N" to avoid creation of any transactions,

and "Y" to create a transaction for each line item (multiple screens are possible).

When using Multi-Bin and transactions are created, the bin will come from the item/inventory location picking sequence.  If the user needs to use a bin other than the default pick bin, the created CSV file may be changed before importing the file.

The created CSV file may be used as input to the IM / Processing / Inventory Transaction Processing / Import function.

The report is that is generated can be printed in either entry or bin number order. This is controlled via Util-Setup-> Global Setup-> Dist-> I/M Global Control-> Screen 3-> 17. Create Inventory Trx CSV Import Print Seq.


Valid options are E=Entry Sequence and B=Bin Sequence. The default is "E". Here is an example of the report printed in Bin Sequence order.

Modified programs: IM0101, IMTRXCSS, IMLABSC3, IMTRXDTL, IMTRXCSP, IMSELTRX(DS, FD, SL, WS), IMITMTRX(DS, FD, SL, WS), NSCTLFIL.FD, NSCTLFIL.W30, NSCTLINI, NSCTLMN3

DLM

• Related Articles

• Feature - Added Support to “Create I/M Trx CSV Import” for Kit Items

  Release Date: 3/29/17 Added a new feature to “Create I/M Trx CSV Import” for Kit items. If the following flag in Global Setup-> Dist -> I/M Global Control, Screen 3: 16. Use Kit Components in Create I/M Trx CSV Import is set to "Y" as follows: the ...

• Feature - Inventory Transfer Management Batches Using CSV Import

  Release date: 8/3/2018 "Free" Inventory Transfer Management batches are batches that have been entered by hand through the Inventory Transfer Management application and not automatically generated by Elliott when inventory needs to be transferred. ...

• Feature - Create Hold Trx when Posting Inventory Trx

  Release Date: 12/21/2020 Version 8.5 & Up In PO Warehouse Receiving File Maintenance, a "Create Alloc ?" flag exists to signify that during posting of the transactions a record will be created in the Hold Transaction file. That is to say that even ...

• Feature - WMS Inventory Move Import

  Release Date: 5/16/24 Version: 8.5 and Above Introduction While Elliott has a built-in WMS solution, Elliott WMS does not support integration with third-party machinery. On the other hand, Elliott also supports integration with third party WMS or ...

• Feature - New Item Import Through CSV File

  Program Original Release Date: 05/15/2007 Document Release Date: 08/21/2020 Version: 7.5 & up The feature can be accessed in I/M, Utility, and New Item Import. It allows you to import new items from either an ASCII or CSV file. This document only ...