You are browsing the archive for INV.

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

10.0 Open 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 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 FUTURE status period
  • Click ‘Change Status’
  • Click ‘OK’ when prompted ‘Open this period?’

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

Open Inventory Accounting Period

Open Inventory Accounting Period