Steps to Define and Complete a Cycle Count

1. Steps to Define and Complete a Cycle Count

2. Main Steps • 1. Define New Cycle Count (Slides 4-7) • 2. Count Frequency Setup • 3.Cycle Count Listing • 4.Cycle Count Entry • 5.Count Adjustment Information • 6.Manual schedule • 7.Adjustment proof • 8.Approval

3. Define New Cycle Count path=COUNTING-CYCLE COUNTING-CYCLE COUNTS • Setup and define new cycle count. Make sure that:  • * The correct ABC group is associated with this cycle count (ABC Initialization Zone) • * The correct ABC classes are associated with this cycle count (Click "Classes" button and quick pick the classes) • * The column "Counts Per Year" have been entered for each "Class" on this form also • * "All" Subinventories or a "Specific" Subinventory have been specified • * (This is also done for the ABC compile but if the ABC compile was for all ORG the Cycle Count could be done for only one subinventory within the org if needed) • * If "AutoSchedule" is desired check, the appropriate box and make sure the "Next Date" is filled in. • * Check "Automatic Recounts" box if a recount of items that are out of tolerance is desired.

4. . DEFINE CYCLE COUNTS FORM: A. Approval Options - User specifies how to handle adjustments to inventoryquantities when discrepancies occur:  1. Not Required - Any adjustments are made automatically  2. Required if Outside Tolerance - If count is outside adjust only approve - inside it is done automatically  3. Required for All - No automatic adjustments B. Tolerances - User specifies what variances of counting they will use:  1. Quantity % - Counted quanty percentage  2. Adjust Value - (clunt-onhand) X item cost  3. HIT/MISS - Uses this to generate Hit Miss Analysis Report - No value and any variances is a miss C. Auto Recount - Anything outside of tolerances will get resubmitted for counting X number of times. The approval takes over.

5. Technical Info • (Form Name: INVADCYC Base Tables: MTL_CC_SUBINVENTORIES, MTL_CYCLE_COUNT_CLASSES, MTL_CYCLE_COUNT_HEADERS) • path=COUNTING-CYCLE COUNTING-CYCLE COUNTS

6. Define New Cycle Count-1

7. Define New Cycle Count-2

8. Define New Cycle Count-3

9. Define New Cycle Count-4 • Once Cycle Count defined move to "ABC Initialization" Zone and click toggle bar to select "(Re)Initialize". This launches the concurrent program INCACI.  (INCACI inserts into MTL_CYCLE-COUNT_CLASSES & MTL_CYCLE_COUNT_ITEMS) (For each initialization it will delete prior records for each item)

10. Count Frequency Setup Class wise

12. Launch Cycle Count • Click on tools to "Perform Full Cycle Count".  • This spawns 3 different requests:  • 1. Automatic Scheduler--> If auto schedule is check for this Cycle Count (INCACS - Inserts into MTL_CC_SCHEDULE_REQUESTS)  • 2. Generate Cycle Count Requests (INCACG = Inserts into MTL_CC_SCHED_COUNT_XREFS & MTL_CYCLE_COUNT_ENTRIES) *If an item is to be counted it will exist in the MTL_CYCLE_COUNT_ENTRIES table * If an item is not in this table it will not show on the "Cycle Count Entries" form - INVATCEN  • 3. Cycle Count Listing Report (INVARCLI) Prints all items to be counted given the date range, org, cycle count, subinventory and recount parameters  (From the "Special" menu on this form all of the Cycle Count reports can be run)

13. Cycle Count Listing

15. Enter Counts

16. Enter Cycle Counts Form • Enter Cycle Counts Form • (Form Name: INVATCEN Base Tables: MTL_CYCLE_COUNT_ENTRIES) • path= COUNTING-CYCLE COUNTING-CYCLE COUNT ENTRIES  * This form update MTL_CYCLE_COUNT_ENTRIES with the count and adjustment quantities.  * The cycle count is quickpicked and then the "Find" button is clicked to bring up all items that need counts entered.  * If adjustments do not need approval then the form will call the following concurrent programs below  * This depends on how you set the "Approval" options when the cycle count was defined. * The three choices are: ALWAYS, NEVER & OUT OF TOLERANCE.  * When approval is skipped the following programs are called:  INUTPU - Performs material transaction update  INUUOM - Performs UOM conversions  INUACT – Performs cycle count adjustment transactions  * This program inserts into MTL_MATERIAL_TRANSACTIONS_TEMP  INCTCW - Transaction worker for Inventory

17. Count Adjustment Information

18. Adjustment Proof

20. Manual Schedule

21. Auto Approval

22. Count Adjustment Approvals Summary • "Count Adjustment Approvals Summary" form - Approve the counts made or recount items  • (Form Name: INVAMCAP Base Tables:MTL_CYCLE_COUNT_ENTRIES) • path= COUNTING-CYCLE COUNTING-APPROVAL COUNTS  * This form shows "System Quantity" and "Count Quantity" for the cycle count items.  * Records can either be "Approved", "Rejected", "Recounted“ or "Cleared" on this form.  If "Recount" is chosen then the record is available on the "Enter Cycle Counts" form to have another quantity entered.  * If "Approved" is chosen and the screen is saved then this form will kick off all the same concurrent programs as the "Enter Cycle Counts" form. 

23. Count History