FTZ Management: Preparation - Zone to Zone Reconciliation

The
Zone to Zone Reconciliation
screen is used for reconciling quantities between zone to zone shipments and receiving zone transactions, matching via Transport ID.
This screen can be opened by choosing
Zone to Zone Reconciliation
from the
Preparation
menu and is broken into two tabs:
Exact-Matches
and
Non-Matches
. These tabs are described in more detail below.

Exact-Matches

The
Exact-Matches
tab includes all Transport IDs where the transaction quantities on the zone to zone shipment records match the receiving zone transaction quantities for the products. When the
Zone to Zone Reconciliation
screen is initially loaded, this tab is opened by default.
If a Transport ID has one or more products with a transaction quantity discrepancy, the Transport ID will move to the
Non-Matches
tab and not be visible in the
Exact-Matches
tab.
To process a Transport ID:
  1. Check the box associated to the Transport ID in the far-left column, then click
    Process
    near the top of the screen. All
    FIFO Processing
    records associated with the Transport ID will be updated with the data from the
    FromZone
    shipment transaction.
  2. To reconcile all Transport IDs on a page, click
    Select All > Process
    . Once processing has been completed for all selected Transport IDs, they will be removed from the grid.

Non-Matches

The
Non-Matches
tab includes all
Transport IDs with
a discrepancy between the zone to zone transaction quantity and
FIFO Processing
transaction quantity (for a specific product on the Transport ID). All Transport IDs displayed should be reconciled before proceeding with regular processing.

Reconciling Non-Matches

All Transport IDs that are not ready to be reconciled should be moved back to staging.
To return a Transport ID to staging:
  1. Find the
    Transport ID
    in the grid and check the associated box in the far-left column.
  2. Next, click
    Pushback
    . This will move all products on the Transport ID back to the staging table, not just the product with the transaction quantity discrepancy. Only Transport IDs that are not expired can be moved back to the staging table.
  3. A pop-up appears, requesting confirmation that the items are to be returned to staging.
  4. Click
    OK
    to proceed.

Detail

  1. Click the
    Detail
    link to the left of the
    Transport ID
    to open the
    Zone to Zone/FIFO Processing transaction quantity
    modification pop-up.
  2. This pop-up displays the
    Zone to Zone Transaction
    quantity and
    FIFO Processing
    transaction quantity for a product number on the Transport ID. The
    Zone to Zone
    transaction quantity or
    FIFO Processing
    transaction quantity can be modified to reconcile the discrepancy.
  3. After determining which quantity will be modified, check the box associated with the quantity. There are two ways in which the quantity can be updated:

Modify Transaction Quantity

To modify transaction quantity:
  1. Click
    Modify Transaction Quantity
    to open the
    Modification Transaction Quantity
    pop-up.
  2. In the
    Updated Transaction Quantity
    field, enter the new quantity. The Zone to Zone transaction quantity can only be decreased. The FIFO Processing quantity can be increased or decreased.
  3. Click
    Submit
    to execute the changes or
    Cancel
    to drop all changes.
Modify Transaction Quantity Table
Modify options
Description
Modify Transaction Quantity
Changes the overall quantity for the specified transaction quantity type (
Zone to Zone
or
FIFO Processing
).
Move to TransportID
Moves a specific amount of the current quantity to a new
Transport ID
. The quantity to be moved and new
Transport ID
are specified by the user.

Move to Transport ID

To move to transport ID:
  1. Click
    Move to TransportID
    to open the
    Move to TransportID
    pop-up.
  2. In the
    Quantity to Move
    field, enter the new quantity.
  3. In the
    Transfer TransportID
    , enter the new Transport ID for where the quantity is being transferred.
  4. Click
    Submit
    to execute the changes or
    Cancel
    to drop all changes.
  5. Once a non-matching Transport ID has been reconciled, the Transport ID will move from the
    Non-Matching
    tab to the
    Exact-Matches
    tab.
  6. After no further records exist beneath
    Non-Matches
    , follow the process described in
    Exact-Matches
    to complete processing.

Processing Non-Matches Using Auto-Reconciliation

The auto-reconciliation functionality reconciles all product numbers on the Transport ID that have a quantity discrepancy. This feature can be enabled for clients who process a high volume of Transport IDs daily.
If this feature is enabled, the
Process
button will appear in the right top corner of the
Zone to Zone Reconciliation
screen.
To auto-reconcile a Transport ID:
  1. Check the box to the left of the associated Transport ID, then click
    Process
    .
  2. Click
    Process
    to open the
    Auto-Reconcile Confirmation
    pop-up.
  3. To proceed, click
    OK
    .
  4. The auto-reconciliation process will then initiate for the Transport ID. Once the process has been completed, the Transport ID moves from the
    Non-Matches
    tab to the
    Exact-Matches
    tab.
  5. To complete processing, follow the process described in
    Exact-Matches
    .