Inventory Adjustments

Reason Codes

Whenever an inventory adjustment is made in Merchandising that impacts total stock on hand - either through integration or using online screens, a reason code must be included for the increase or decrease. Any new reason codes added can be done following the details found in Oracle Retail Merchandising Inventory User Guide section on Inventory Adjustments. Take care to synch any reason codes set up in Merchandising with those used in your warehouse management system and store inventory management system to ensure there are no errors when adjustments are interfaced to Merchandising. Additionally, there are some functions within Merchandising that will generate an inventory adjustment as part of processing. The details on how to configure reason codes to be used for these transactions is also found in the Oracle Retail Merchandising Inventory User Guide section on Inventory Adjustments. The transactions that reason codes can be configured for include:

• Wastage Adjustment

• Stock Count Unit Variance

• Item Transformation at Finisher

• Transfer Overage Sending Location

• Transfer Overage Receiving Location

• Transfer Short Sending Location

• Transfer Short Receiving Location

• Transfer Short/Close Sending Location

• Transfer Short/Close Receiving Location

• Late Posting: Sale

• Late Posting: Return

• Late Posting: Transfer Out Sending Location

• Late Posting: Transfer Receipt

• Late Posting: PO Receipt

• Late Posting: RTV

• Late Posting: Inventory Adjustment

• Customer Order Return Without Inventory

• Wholesale Franchise Destroy On Site Return

Status Types and Codes

Inventory status types and codes are used when performing inventory adjustments in Merchandising, or when inventory adjustments or other inventory updates are done in stores or warehouses and uploaded to Merchandising. As part of the initial install, some values are seeded into these tables, as follows

Inventory Status Type	Description
1	Trouble Merchandise
2	Customer Order

Inventory Status Code	Description	Inventory Status
ATS	Available to Sell	NULL
UTS	Unavailable to Sell	NULL
WIP	Work in Progress	NULL
DIST	Distributed	NULL
TRBL	Trouble	1
RIP	Receipt in Progress	NULL
COR	Customer Order	2

Warehouses and stores send inventory status codes with their transactions and, based on how it is mapped to a status type, may be moved to an unavailable status in Merchandising when the transaction is processed. For example, if a warehouse sent a receipt with a status code of TRBL, it would be moved to the Merchandising unavailable bucket called Trouble Merchandise. But, if the WIP status was sent, the inventory would remain in available status. As part of your implementation, you should determine which inventory statuses you want to use as part of your implementation and also make sure to synch the status codes with what is used in your warehouse and store inventory management solutions and update Merchandising as needed. For details on how to add or update the status codes and types, see "Inventory Adjustments" in the Oracle Retail Merchandising Inventory User Guide section on Inventory Adjustments.