Reverse Pick Tickets - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

The Reverse Pick Ticket functionality is used to allocate the items scanned by Mobile Scan to the material issue report. To use this functionality, the items must be scanned using Mobile Scan to fill the m_mir_pick_tickets table.

On the C.20.22.01 MIR by BOM Commodity screen, you can either click the Populate List Nodes button or use the LOV in the BOM Path field to open the Window 5: Inventory Issue Allocations.

C202201W5

In this screen, only the BOM Path and Issued Quantity fields are editable.

The Scan # field shows the scan number which is a sequence number, incremented by 1 per each scan. The scan number is only used to identify scanned items that are split.

Scanned Qty shows the quantity that was originally scanned by Mobile Scan.

The issued quantity is copied from the Scanned Qty and displayed in Issued Quantity. If the scanned item is not split, the issued quantity must not be changed. If the scanned item is split, the sum(Issued Quantity) of all splits must be equal to the original scanned quantity. The issued quantity is copied to the Inventory Issues when creating MIR details.

R to Iss Quantity shows the required to issue quantity (required quantity - reserved quantity - issue quantity) of the list position.

Issue / Scan delta shows the difference between the scanned quantity and the issued quantity.

The Allocation Check field shows the result of the pre-check procedure.

At the bottom of the screen you can find buttons which describe the workflow step by step, and you must use the buttons in the exact sequence:

  1. Load Scans

  2. Set Start Node

  3. Proposal

  4. Pre Check

  5. Create MIR Details

Load Scans

Click Load Scans to load the scans from Mobile Scan that were made for this material issue report.

  • Scans for allocation can only be inserted if no data exists in MIR details

  • Only scanned items are inserted that do not exist in the allocation table

Set Start Node

Click Set Start Node to open the B.20.01 Edit BOM (LOV) screen, where you select the start BOM list node for the proposal or for the manual insert. Alternatively, use the LOV in the BOM Path field to select the start node.

Proposal

Click Proposal to execute a procedure that checks the list positions under the selected start list node. If the material is matching the inventory item, the BOM Path, List Node, List Pos, and R to Iss Quantity of the list position are filled in.

Alternatively, assign the BOM positions manually as described below under Manual Insert. If you want assign a scanned item to multiple BOM positions, you can split the item as described below under Split Scanned Items.

  • Only scanned items with a scanned quantity > 0 are considered.

  • Allocations are deleted with no entered list node or inventory item.

  • Starting from the selected start list node, the BOM positions are compared with reference to the ident and the open quantity (R to Issue = required issue quantity of the list position).

  • If a list position with matching ident is found, the inventory is checked against ident, warehouse, location, status and unit.

  • The allocation table is filled with proposed data.

Manual Insert

To manually assign BOM list positions to scanned items, double-click in the List Pos field to open Window 6 where the inventory items are displayed which:

  • Have matching ident, warehouse, location, status, and unit.

  • Do not exist in the allocation table with the same list position and inventory item.

  • Have an on-hand quantity > 0 (in consideration of allocated inventory issues).

You can select only one inventory item.

Split Scanned Items

To split a scanned item, press the function key F6 (new record) and then F4 (duplicate record above) to copy the scanned item. The new line will get the same scan number. Adjust the issued quantity of all splits belonging to a scan, that the sum of issued quantities is equal to the scanned quantity.

Pre Check

Click Pre Check to run a CIP procedure that performs several checks and writes the results into the Allocation Check field. The ALLOCATION_PRE_CHECK CIP procedure can be found in the M_PCK_REVERSE_ALLOC_CUSTOM package and can be customized to adjust the standard checks according to your need or to apply your own checks.

The standard check procedure which is delivered with the software performs the following checks:

  1. Are all scanned items inserted in the allocation table?

  2. Are list position (lp_id) and inventory item (ivi_id) entered on all positions?

  3. Are all scanned quantities of pick tickets allocated?

  4. Is the combination of list position and inventory item unique in the MIR details (m_inv_issues unique key check)?

  5. Is enough on-hand quantity available for the entered inventory items?

  6. If an overissue might be possible, is the overissue warehouse and location set on MIR header?

For more information about CIPs, see Customer-installed procedure (CIP) Tasks.

Create MIR Details

Click Create MIR Details to create the inventory issue records for the selected MIR, based on the defined allocations. Before the records are created, the same checks are performed as described under Pre-Check above, because data might be updated in the meantime. If the checks are passed, the MIR details (inventory issues) are filled in.

The pick ticket identifier (mpt_id, primary key of table m_mir_pick_tickets) is stored in the m_inv_issues table (MIR details).

Reverse Pick Ticket Workflow

This chapter describes the workflow how to complete a reverse pick ticket.

  1. Create a MIR header of type ‘Reverse Pick Ticket’ in C.20.22.01 MIR by BOM Commodity.

    Alternatively, create the MIR in Mobile Scan using the Initiate Issue > By Reverse Pick function (See Smart Materials MobileScan).

  2. Scan the items using Mobile Scan (to fill the m_mir_pick_tickets table).

  3. Click Populate List Nodes to allocate the scanned items.

    Alternatively, use the LOV in the BOM Path field

  4. Click Load Scans to insert the scanned pick ticket items.

  5. Click Set Start Node to set the start list node for the proposal.

    Alternatively, use the LOV in the BOM Path field.

  6. Click Proposal to insert corresponding data into the allocation table.

  7. To modify the proposed data, double-click in the List Pos field to open Window 6 where matching list positions and inventory items with sufficient on-hand quantity are displayed.

  8. To split scanned items, use the function keys F6 and F4 and adjust the issued quantities

  9. Click Pre Check to check the allocations per line.

    The result of the check is displayed in the Allocation Check field.

  10. If all checks are passed, click Create MIR Details.

    • The checks are made again because data could be updated in the meantime.

    • The inventory issues are filled in.

    • All allocations are deleted.

To start a new allocation, the MIR details must be deleted.