Skip to main content

Need to understand the working of inventory management (findInventory and RTAM Sync) when an item is created arbitrarily but doesn't exist in reality


Technote (FAQ)


Question

1. Can we create inventory (yfs_item_inventory) without having a item in yfs_item?
2. if yes, can we sync such inventories via RTAM?

Cause

Need to understand the inventory management in detail.

Need to know the behavior of findInventory and RTAM Sync when we do not have an item in real but just an entry.


Answer

Steps to create an item which doesn't exist in real but is just an entry :

1. Log into Application console and navigate to Inventory tab.
2. Click the adjust Inventory option provided in the drop down.
3. Now type an item name which does not exist in the system and associate an UOM to it.
4. You shall be navigated to the inventory adjustment page, here mention the node and supply type along with the quantity.
5. Once you save this activity, a corresponding record would be attached to the YFS_INVENTORY_ITEM table.

One can view the inventory supply and demand for such non existent items through the inventory console.

FindInventory API call :

Input xml :
<Promise AggregateSupplyOfNonRequestedTag="Y" CheckInventory="Y"
ConsiderSupplementalCapacity="Y" DeliveryDateBased="Y"
EnterpriseCode="DEFAULT" IgnoreMinNotificationTime="Y"
IgnorePromised="Y" IgnoreUnpromised="Y"
IsPartialSubstitutionAllowed="Y" OrganizationCode="DEFAULT"
UseUnplannedInventory="N">
<PromiseLines>
<PromiseLine FulfillmentType="" ItemID="RTAMtest" LineId=""
ProductClass="" RequiredQty="5" UnitOfMeasure="EACH">
</PromiseLine>
</PromiseLines>
</Promise>

Output xml :
<?xml version="1.0" encoding="UTF-8" ?>
- <Promise CheckInventory="Y" ConsiderSupplementalCapacity="Y"
DeliveryDateBased="Y" EnterpriseCode="DEFAULT"
IgnoreMinNotificationTime="Y" IgnorePromised="Y" IgnoreUnpromised="Y"
IsPartialSubstitutionAllowed="Y" OptimizationType="01"
OrganizationCode="DEFAULT" UseUnplannedInventory="N">
- <SuggestedOption>
- <Option AvailableFromUnplannedInventory="N"
FirstDate="2012-10-15T15:06:04-04:00" HasAnyUnavailableQty="N"
LastDate="2012-10-15T15:06:04-04:00" LeastPriority="0.00"
MaxPriority="0.00" OptionNo="1" TotalShipments="1">
- <PromiseLines TotalNumberOfRecords="1">
- <PromiseLine AutoReplacedByPreferredSubstitute="N" FulfillmentType=""
IsBundleParent="N" ItemID="RTAMtest" LineId="" NewItemID=""
ProductClass="" RequiredQty="5" UnitOfMeasure="EACH">
- <Assignments TotalNumberOfRecords="1">
- <Assignment AvailableFromUnplannedInventory="N"
DeliveryDate="2012-10-15T15:06:04-04:00" Distance="0.00"
ExternalNode="N" InteractionNo="1" IsIdleAsset="N" MergeNode=""
NodePriority="0.00" ProcuredQty="0.00" ProductAvailDate="2012-10-15"
Quantity="5.00" ReservedQty="0.00" SCAC="" SegmentChangeQty="0.00"
ShipDate="2012-10-15T15:06:04-04:00" ShipNode="N1"
SubstitutedQty="0.00">
<SubstituteItems />
<Procurements />
</Assignment>
</Assignments>
</PromiseLine>
</PromiseLines>
<PromiseServiceLines TotalNumberOfRecords="0" />
- <Interactions TotalNumberOfRecords="1">
- <Interaction Carrier="" CarrierServiceCode=""
DeliveryDate="2012-10-15T15:06:04-04:00" DeliveryMethod=""
EarliestDate="2012-10-15T00:00:00-04:00" InteractionNo="1"
IsDelivery="N" ItemGroupCode="PROD"
LastDate="2012-11-14T23:59:59-05:00" Node="N1" OrganizationCode=""
ShipDate="2012-10-15T15:06:04-04:00" TotalHandlingUnits="0.00">
<PersonInfoShipTo AddressLine1="" AddressLine2="" AddressLine3=""
AddressLine4="" AddressLine5="" AddressLine6="" AlternateEmailID=""
Beeper="" City="" Company="" Country="" DayFaxNo="" DayPhone=""
Department="" EMailID="" ErrorTxt="" EveningFaxNo="" EveningPhone=""
FirstName="" HttpUrl="" JobTitle="" LastName="" MiddleName=""
MobilePhone="" OtherPhone="" PersonID="" PreferredShipAddress=""
State="" Suffix="" Title="" UseCount="0" VerificationStatus=""
ZipCode="" isHistory="N" />
</Interaction>
</Interactions>
</Option>
</SuggestedOption>
<Options TotalNumberOfRecords="0" />
</Promise>

Hence from the above test it is evident that we can adjust inventory without having a item in yfs_item.


Further, RTAM sync would not consider such inventory changes as we would not have set up any monitoring rules for such a non existent item.

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

Sterling Order Management


Software version:
All


Operating system(s):
All


Reference #:
1616274


Modified date:
2013-01-13

Translate my page

Content navigation