Cycle_Count__c

Label: Cycle Count

This object supports the generation of the cycle-count-batch number which controls what Item/Location combinations are to be counted within the batch. Also provides the user with status of the batch in terms of being counted or confirmed and tracks the completion of each item count within the batch. For any one specific cycle count, there may be one or multiple items and/or one or multiple locations to be counted. There are business intelligences dependent on this object.

Field Name	Field Label	Created in Version	Description	Type
Actual_Batch_Count__c	Actual Batch Count	Pre-Spring 2018	This is the sum of all item counts in a specific Cycle Count Batch that were actually confirmed.	Summary
Actual_Valuation__c	Actual Valuation	Pre-Spring 2018	This is the fiscal valuation sum of all items in a specific Cycle Count Batch that were actually confirmed.	Summary
Batch_Discrepancy__c	Batch Discrepancy	Pre-Spring 2018	The count discrepancy for the cycle count batch.	Summary
Batch_Financial_Discrepancy__c	Batch Financial Discrepancy	Pre-Spring 2018	Formula: Expected_Valuation__c - Actual_Valuation__c	Currency(18,2)
Count_Accuracy__c	Count Accuracy	Pre-Spring 2018	This is a calculation between the Expected Batch Count and the Actual Batch Count to provide the accuracy level achieved in performing a cycle count batch from a count perspective. Formula: if ( Actual_Batch_Count__c < Expected_Batch_Count__c , Actual_Batch_Count__c / Expected_Batch_Count__c, 1-( (Expected_Batch_Count__c - Actual_Batch_Count__c )/ Expected_Batch_Count__c ))	Percent(18,4)
Count_Status__c	Count Status	Pre-Spring 2018	Formula: IF( Item_Locations_Counted__c = 0, $Label.StatusNew, IF( Item_Locations_Counted__c = Item_Locations_To_Count__c, $Label.StatusCounted, $Label.StatusInProcess) )	Text
Expected_Batch_Count__c	Expected Batch Count	Pre-Spring 2018	This is the sum of all item counts in a specific Cycle Count Batch that were expected to be confirmed.	Summary
Expected_Valuation__c	Expected Valuation	Pre-Spring 2018	This is the fiscal valuation sum of all items in a specific Cycle Count Batch that were expected to be confirmed.	Summary
Financial_Accuracy__c	Financial Accuracy	Pre-Spring 2018	This is a calculation between the Expected Valuation and the Actual Valuation to provide the accuracy level achieved in performing a cycle count batch from a financial perspective. Formula: Actual_Valuation__c / Expected_Valuation__c	Percent(18,4)
ICP__c	ICP	Pre-Spring 2018	Formula: Warehouse__r.ICP__r.Name	Text
Item_Locations_Counted__c	Item Locations Counted	Pre-Spring 2018	This is the number of item locations within the batch that have been counted.	Summary
Item_Locations_To_Count__c	Item Locations To Count	Pre-Spring 2018	This is the number of item locations to count in the batch.	Summary
Status__c	Status	Pre-Spring 2018		Picklist: Approved Cancelled Confirmed Counted New Rejected Submitted for Approval
Type__c	Type	Pre-Spring 2018	The type of cycle count requested. A manual item request or an automated requested causes the date of the last cycle count to be updated.	Picklist: Automated Request Manual Item Request Manual Location Request
Warehouse__c	Warehouse	Pre-Spring 2018	Specific warehouse or stockroom within an ICP Looks up to: Warehouse__c	Lookup