IBM Support

Configuring virtual location (accounting bin) to avoid mis-representation of inventory during variance acceptance.

Troubleshooting


Problem

Configuring virtual location (accounting bin) to avoid mis-representation of inventory during variance acceptance.

Symptom

Problem Statement:
When variance is accepted, it is noticed that the inventory gets mis-represented with out-of-the-box (default) settings.
A typical setup and execution for accepting variance is as follows:

Here the Location L1 and the bin location are configured to be at two different zones.

Assume that L1 belongs zone Z1.
1. Location L1 had inventory for Item I1 say Qty 10
2. Create Count request for the Item I1 in the location L1
3. Completed the count task with count quantity as 12
4. System created count results with New variance as 2
5. Now accept the variance by running the agent with the reason code associated with the virtual location (bin location)

Result of this is as follows:

1. The quantity of Item I1 in the virtual location is '-2'
2. Go to Location Inventory Console under Inventory
3. Search for the location L1 with item I1
4. Here we see the quantity of item I1 getting set to 12
5. Select this location and click on 'Node Level Inventory'
6. Under the screen (YWMD046I02) the supply quantity is still set to '10'


Since the supply quantity shown on 'Node Level Inventory' screen (10) is different than the Location Inventory picture (12), it ends up being a source of confusion for customers.

Cause

Resolving The Problem

Resolution:
This issue crops up because of the fact that Yantra does not perform global inventory supply updates when the bin zone and source zone have the same supply types.
Hence, the customer should not have used the reason code for bin location while accepting variance.
The other way to avoid this issue is by having a status transition for the bin zone set to a supply type that is different than the source.



NOTE:From the Documentation for Account Bin:
"Choose the accounting bin location for the inventory, if required. Locations in the node with location type as
'VIRTUAL' are displayed. The accounting bin represents a virtual location in the warehouse, which is used as a reconciliation
mechanism for the inventory being adjusted. For example, in a 3PL warehouse, a client's representative is responsible for the inventory picture. This means that all adjustments or discrepancies found during count require an additional step for approval. The accounting bin also provides a location that tracks the discrepancies as they happen and also reconcile them when inventory is found elsewhere in the warehouse (usually a neighboring location)."

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI49629

Product Synonym

[<p><b>]Fact[</b><p>];

Document Information

Modified date:
16 June 2018

UID

swg21523549