You are browsing the archive for Oracle Inventory.

11.1 Cycle Count Manual Schedule Request

 

  • Form Application: Inventory
  • Form Name: INVADCSC
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVADCSC.fmx

Cycle count process is periodic schedule inventory counting and verification process. Once cycle count is setup it can be scheduled to run automatically based on ABC class and count frequency or manual schedules can be entered to do cycle count for specific items on periodic basis. In this tutorial you will learn how to do manual schedule request for cycle count.

Navigation: Inventory responsibility -> Counting -> Cycle Counting -> Manual Requests

  • Select the ‘Cycle Count’ name from the drop down
  • Click ‘Find’, it will show all open cycle count manual requests
  • Under Schedule Requests, select the ‘Item’ to be scheduled
  • Select the ‘Subinventory’ in which the item to be counted
  • Enter the ‘Schedule Date’

Save the changes. Now the manual schedule request entered is scheduled on the specified date. Whenever you print the count requests this item will be printed on scheduled date.

Manual Cycle Count Schedule Request

Manual Cycle Count Schedule Request

 

11.0 Cycle Count Setup

 

  • Form Application: Inventory
  • Form Name: INVADCYC
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVADCYC.fmx

Cycle Count is a periodic onhand inventory verification process. Instead of Physical Inventory where entire warehouse onhand inventory is verified, in Cycle Count it is scheduled throughout the period. ABC classification of items are used in Cycle counting, this helps in scheduling high-value (A-class) items more frequently and B & C classes less frequently.

First step in cycle count is setting up the scope and details.

Navigation: Inventory responsibility -> Counting -> Cycle Counting -> Cycle Counts

  • To Open an existing Cycle Count, Click ‘FIND’ button and ‘OPEN’
  • To setup new cycle count, click ‘NEW’
  • Enter the ‘Name’ of cycle count
  • Enter the ‘Description’ of cycle count
  • Select the ‘Calendar’ used for scheduling cycle count. This will be useful to schedule on working/desired days.
  • Enter the ‘Adjustment account’ to use for adjusting any inventory variances during cycle counting

Scope & Control

  • Enter the ‘Inactive Date’ to end date the cycle count
  • Enter the ‘Late Days’ after the scheduled count it expires.
  • Enter ‘Starting Seq’ for count
  • Check ‘Unscheduled Entries’ to manually add any new entries.
  • Check ‘Display System Quantity’ to show the actual system quantity. Some business wouldn’t like to show system quantity as actual quantity may be biased.
  • Select the scope cycle count by selecting ‘Specific’ subinventory or ‘All’ subinventories.
  • Click on the ‘Classes’ to select the ABC class to be used for this cycle count.
  • Select the ‘Class’ Name and counts/year. High value items counted more frequent than low value items.
  • Enter the ‘Approval Variance’ by quantity or value. Any variance beyond this limit requires approval. With limit variances doesn’t need approval.

Serial & Schedule

  • Select the ‘Serial Control’ option to count by serial number
  • Set the ‘Auto schedule’ frequency

Adjustments & ABC

  • Set the ‘Approval Required’ option
  • Approval tolerances. This is used if ABC specific variance tolerances are not setup
  • Select the applicable ‘ABC Group’

Save the changes. Now cycle count is setup to start scheduling the counts.

Cycle Count Setup

Cycle Count Setup

10.1 Close Inventory Accounting Period

 

  • Form Application: Inventory
  • Form Name: INVTTGPM
  • Form Path: /oracle/apps/r12/visr12/apps/apps_st/appl/inv/12.0.0/forms/US/INVTTGPM.fmx

Inventory Periods control flow of transactions into specific GL period. It is financial practice to split a financial year into multiple accounting period and based on date transactions flow into any of these accounting period. For accurate financial reporting each period is OPENED and CLOSED by authorized people.

Navigation: Inventory responsibility -> Accounting Close Cycles -> Inventory Accounting Period

  • Select the Inventory ‘Period’
  • Find only OPEN status period
  • Click ‘Pending’ to view pending transactions
  • Ensure no pending transactions that require resolution are open.
  • Click on ‘Change Status’
  • Select new status as ‘CLOSED’
  • Click ‘OK’
  • Click ‘CLOSE’ when pending transactions summary screen prompted

Concurrent program is submitted, once it is completed NORMAL, navigate again to check the Inventory accounting period status changed from OPEN to CLOSED.

Close Inventory Accounting Period

Close Inventory Accounting Period