Tracking Consigned Inventory During Inventory Counts
During cycle count and physical inventory count processes, you must determine procedures for managing consigned inventory. Typically, you include supplier consigned inventory during a count because it is physically present at your site.
Various cycle count and physical inventory programs let you manage supplier consigned inventory according to your needs. You can count:
• Only consigned inventory
• Only non-consigned inventory
• Both consigned and non-consigned inventory
For example, you can use consignment fields in Cycle Count Worksheet Print (3.13.1) to select inventory to count.
Tracking Consigned Inventory Using Cycle Count Worksheet Print (3.13.1)
Similarly, when you use Item Tag Create (3.16.1), you can choose to update tags for only consigned, only non-consigned, or both types of inventory.
Tracking Consigned Inventory Using Item Tag Create (3.16.1)
When you exclude consigned inventory, any inventory adjustments affect non-consigned inventory only. If you choose to include consigned inventory or do a count of consigned inventory only, the system uses special transactions when adjusting inventory downward.
These transactions occur in Cycle Count Results Entry (3.13.2) and Inventory Balance Update (3.16.21).
The system checks the value of Use Consigned First in Supplier Consignment Control to determine how to manage adjustments. Downward adjustments to supplier consigned inventory create the standard CYC-CNT or TAG-CNT transaction, followed by RCT-PO and CN-ISS transactions to track the inventory changes and transfer ownership of material.
Balancing Consigned Inventory After Cycle or Physical Counts
Option Entered | Results | Action | Transactions |
Only consigned
| Shortage | Shortage is reduction of consigned inventory. | CYC-CNT or TAG-CNT RCT-PO, CN-ISS |
Surplus | Surplus is non-consigned. | CYC-CNT or TAG-CNT |
Include consigned and non-consigned
| Shortage | Depends on value of Use Consigned First in Supplier Consignment Control | If Yes: CYC-CNT or TAG-CNT RCT-PO, CN-ISS If No: CYC-CNT or TAG-CNT |
Surplus | Surplus is non-consigned. | CYC-CNT or TAG-CNT |
Exclude consigned
| Shortage | Shortage is reduction of non-consigned. | CYC-CNT or TAG-CNT |
Surplus | Surplus is non-consigned. | CYC-CNT or TAG-CNT |
Use Consignment Inventory Adjustment (5.18.25.21) to associate the surplus (non-consigned) inventory to a consignment order, if needed.