Skip to content

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

Feedback and Knowledge Base