Physical Inventory

Purpose: Use this document as a reference to perform a physical inventory of assets in Asset Management. Select the Physical Inventory tile on the Asset Tracking homepage to scan assets, edit asset data, and add missing assets to the Physical Inventory (PI) scan.

Audience: Finance or Asset Management staff/supervisors.

You must have at least one of these local college managed security roles:

  • ZZ AM Physical Inventory
  • To perform PI in Fluid, users must have access to the Asset Tracking homepage, and the Physical Inventory tile in it.

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Before beginning the Physical Inventory process:

  1. Decide which criteria to employ to select the assets the college wants to inventory/scan. Also, decide if a single criteria value or a range of criteria values should be used.
    1. Example: I use the QFS_AM_ASSET_COST query, which I sort by Location, to identify the rooms that have equipment in them. This information helps me determine the location criteria I should employ.
  2. If assets do not have a QR or Bar code, navigate to Asset Management > Physical Inventory > Print QR/Bar Code > to print out QR and/or Bar codes that can be scanned easily.
    1. The Tag# or Serial ID will be below the QR or Bar code for easy reference, and the size of the QR or BAR code can be modified.

Physical Inventory Process Overview:

  1. Begin in Classic Physical Inventory to set up specific PI parameters and the criteria that determine which assets will be scanned (Steps 1 - 3 below).
  2. Navigate to the Asset Tracking homepage and select the Physical Inventory tile to scan assets and update/correct their physical data in Fluid (Step 4 below).
  3. Verify and review the asset scan results (Steps 5 - 8 below).
  4. Use Interface Transactions and Load into AM to upload scanned asset information and physical data changes into Asset Management (AM) (Steps 9 - 10 below).
  5. Generate and review PI reports and data checks (Step 11 below).
Expand or collapse content 1. Define the Scan Scope and Physical Inventory Parameters

Enables end users to specify the criteria that determines which assets will be scanned.

Navigation: Asset Management > Physical Inventory > Define Inventory Occurrence

  1. To begin a new inventory, select the Add a New Value tab located in the top right of the screen.
    1. Enter the Physical Inventory ID.
    2. Select the Add button and the Define Inventory Occurrence page displays.
  2. Select the Definition tab and enter the:
    1. PI Name: Make it the same value as the PI ID (recommended).
    2. Business Unit.
    3. Start Date: Recommend 01/01/1901, given locations may have that date.
    4. End Date: When you plan to finalize the PI scan.
    5. Book Name: Always enter “WACTC”.
    6. You must select the “Enable Mobile Inventory” checkbox.
    7. Within the Scan Scope section, select:
      1. Capital assets for inventory items $10,000 or greater.
      2. Non-Capital Assets for small and attractive assets.
    8. Within the Comments section, end users can enter any information useful to them/the college.
Define inventory occurence page on the definition tab. The Business unit, PI name, start and end dates, and Book Name fields are highlighted. The Enable mobile inventory and Capital Assets checkboxes are highlighted.
  1. Select the Enter Criteria tab and the Enter Criteria tab displays.
    1. Within the Select Criteria section:
      1. Enter the Business Unit.
      2. Enter other criteria, as needed, to include the assets the college wants to scan.
        1. The criteria can be a single value or a range of values.
Enter criteria tab with no data populated.
  1. Select the Transaction Defaults tab and the Transaction Defaults tab displays.
    1. Within the Auto Approval section, select the Approve checkbox.
    2. Within the Transactions Enabled section, de-select the Retirements checkbox.
      1. De-select Retirements to ensure assets will not automatically retire, and to centrally control when assets are disposed.
    3. Within the Transaction Defaults section, enter the:
      1. Transaction Date. Enter a date that is in the current accounting month.
      2. Accounting Date. Enter a date that is in the current accounting month.
      3. Transfer convention: AM
    4. Within the Retirement Defaults section, update the Retirement Convention to AM.
    5. Select the Save button.
Transactions Defaults tab displays. The Approve checkbox is selected and highlighted. The Retirements checkbox is de-selected. The Transaction Date, Accounting Date, and Transfer convention fields are highlighted. The Retirement Convention field is also highlighted.
Expand or collapse content 2. Create Inventory Schedules

Allows end users to set up one or multiple PI schedules, depending upon the number of physical inventories conducted at the same time.

Navigation: Asset Management > Physical Inventory > Create Inventory Schedules

  1. Select the Add a New Value tab.
    1. Enter the Schedule ID.
    2. Select the Add button and the Create Inventory Schedules page displays.
  2. Within the Schedule Details section, enter the:
    1. Start Date: the date when the inventory may/will begin.
    2. End Date: The final date when the inventory is anticipated to end.
    3. PI ID: Same as PI ID set up in Define Inventory Occurrence.
    4. PI Leader: User’s last name, comma, and first initial.
  3. Select the Save button.
  4. Add a new window from the Create Inventory Schedules page:
    1. Process Load/Match/Reconcile PI in the new window.
Create Inventory Schedules page with the Schedule ID field and all of the Schedule Details fields highlighted. The Save button is also highlighted.
Expand or collapse content 3. Load/Match/Reconcile PI Info

Allows end users to create and execute each step of the PI process.

Navigation: Asset Management > Physical Inventory > Load/Match/Reconcile PI Info

  1. The Load/Match/Reconcile PI Info Physical Inventory Run Control search page displays.
  2. If you have run this process or report in the past, enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value button to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_AM_LOAD_MATCH_RECONCILE (Submodule, Process).
  3. Within the Physical Inventory ID section, enter or search for the Physical Inventory ID and press Tab or Enter on your keyboard. Extract Assets should have four steps now.
  4. Select the box above "Generate Scan Scope".
  5. Select the Run button.
  6. On the Process Scheduler Request page, select the OK button.
  7. Please refer to the Process Schedule Request steps for further instructions.
  8. Select the Save button. Leave this window open. Users must come back to it to process additional PI steps after the asset scan is performed.
Generate Scan Scope steps are displayed. The Phycial Inventory ID, Run button, and Save button are highlighted.
Expand or collapse content 4. Scan Assets

This step is done by selecting the Physical Inventory tile on the Asset Tracking Homepage

Important! If a tablet or phone is used to scan assets, users must login, navigate to, and do all physical inventory scanning and data changes and additions on the tablet or phone they use to scan assets. Do not navigate to physical inventory on your computer at the same time you are scanning with a tablet or phone.

  1. Select the Asset Tracking Home Page (you can navigate to the Home Page by selecting the Home icon in the top right side of the page).
Employee Self Service page Asset Tracking highlighted in the drop-down.
  1. On the Asset Tracking Home page, select the Physical Inventory tile.
Asset Tracking home page with the Physical Inventory tile highlighted.
  1. On the Physical Inventory page, enter or search for the PI ID.
  2. Select the Done button.
Physical Inventory search page with the PI ID field and Done button highlighted.
  1. There are three ways to scan assets:
    1. Print QR and/or Bar codes from ctcLink.
      1. Can be printed onto label paper to place them on the asset.
      2. Select the box with an "X" in it on the right of the Scan Value box.
      3. Scan the assets using a tablet, phone, or scanner.
    2. Use a scanner, a tablet, or phone to scan a bar code from a third-party vendor.
    3. Scan assets without a tablet, phone, or scanner:
      1. Select a “Scan By” method (Tag Number or Serial ID).
      2. Enter the Tag Number or Serial ID of the asset being scanned into the “Scan Value” box.
      3. Select the Fetch button.
  2. After an asset is scanned, a check-mark in a green circle and the date and time of the scan appears at the bottom of the asset’s data.
Physical Inventory page with an example selected from the options on the left side of the screen. Example data is populated and the Scan By and Scan Next fields are highlighted. The Fetch and Edit buttons are also highlighted.
  1. After an asset is scanned, an Edit button will appear on the far right. Select the Edit button to add to or correct the asset’s physical data.
    1. When the Edit button is selected, Edit Scan Record will pop up.
    2. Missing physical data can be added, and/or existing physical data can be changed or removed.
    3. Select the Done button to save any changes made.
Edit Scan Record page displays. Example data is populated and the Done button is highlighted.
  1. Select the three vertical dots in the top right the Physical Inventory page to add assets to the scan.
    1. Find Asset: add an asset to the scan that is already in Asset Management.
      1. Use Search Criteria to determine if the asset is already in Asset Management and/or to find the asset to add it to the scan.
      2. Select “Confirm Manual Scan” on far right to scan the asset and include it in the existing PI scan.
      3. After it is scanned, select the Edit button to edit the asset’s physical data in Edit Scan Record.
Three vertical dots menu which is expanded.
Physical Inventory page with example data shown. The Confirm Manual Scan button is highlighted.
  1. New Asset: Adds an asset found while inventorying that is not in AM.
    • Warning! This feature adds the physical data elements of the asset only. After the PI scan data is uploaded into AM, you must use Basic Add to add additional asset data required, such as profile ID, chartstring, and cost.
Edit Scan Record page with no data populated. The Done button is highlighted.
  1. After all the asset information is entered, select the Done button in the upper right to save it.
  2. The asset is now entered to the list of assets scanned.
Expand or collapse content 5. Verify Scanned Data

Review scanned asset data to ensure the data reflects which assets were scanned, the changes made, and/or if a manual review is required.

Navigation: Asset Management > Physical Inventory > Verify Scanned Data

  1. On the Scan Data Find an Existing Value page, enter the Physical Inventory ID and select the Search button.
    1. Within the Search Results section, review the data.
Scanned Data Find an Existing Value search page with the Physical Inventory ID field highlighted. The search button is highlighted and the display shows search results.
  1. When there is “Y” listed under the Manual Review Required column:
    1. Select the asset.
    2. View the data to make any needed corrections/verify the data is correct
    3. When it is correct, remove the Manual Review Required checkbox to show it is ready to be uploaded into AM.
    4. Select the Save button.
Verify Scanned Data page with example data populated. The Manual Review Required checkbox is de-selected and highlighted. The Save button is also highlighted.
Expand or collapse content 6. Generate Results

Generates the PI scan results.

  1. Select the Load/Match/Reconcile PI Info page within your browser window or navigate to Asset Management > Physical Inventory > Load/Match/Reconcile PI Info.
  2. Select the Next button to navigate to the Generate Results step.
  3. Select the Run button.
  4. On the Process Scheduler Request page, select the OK button.
  5. Please refer to the Process Schedule Request steps for further instructions.
Generate Results step with the Next and Run buttons highlighted.
Expand or collapse content 7. Review Matching Results

Navigation: Asset Management > Physical Inventory > Review Matching Results

  1. On the Inventory Results Find an Existing Value page, enter the Physical Inventory ID and select the Search button.
    1. Within the Search Results section, review the results for Assets with "Y" listed in the Result in Error column. Select the asset.
      1. The error description explains the reason for the error on the Results tab (e.g., asset is disposed).
      2. Assets listed with a “Y” in the Multiple Department Error column:
        1. This error removes the asset from the PI Scan.
        2. Go to Basic Add. Department number in the Chartfields section of the Manufacture/License/Custodian page must be the same as the department in the “Acquisition Detail Chartfields” link on the Asset Acquisition Detail page.
        3. Enter the custodial department for the asset in the Plant field on the Manufacture/License/Custodian page.
    2. Select an asset to view its Results and Details tabs.
      1. Results tab: Shows alerts/warnings and Error messages.
      2. Details tab: Shows current and original values for asset data, to verify changes made.
Inventory Results Find an Existing Value search page with the Physical Inventory ID field and Search button highlighted. The Result in Error and Multiple Department Error columns within the search results section are highlighted.
Expand or collapse content 8. Generate Transactions

Creates an inventory history of assets scanned, and the transactions needed to upload data changes made during the scan into AM.

  1. Navigate back to the Load/Match/Reconcile PI Info page within your browser window.
  2. Select the Next button to navigate to the Generate Transactions step.
  3. Select the Run button.
  4. On the Process Scheduler Request page, select the OK button.
  5. Please refer to the Process Schedule Request steps for further instructions.
Generate Transactions step with the Next and Run buttons highlighted.
Expand or collapse content 9. Review Interface Transactions

Enables users to view and edit the pending interface transactions generated by the PI scan.

Navigation: Asset Management > Send/Receive Information > Interface Transactions > Review Interface Transactions

  1. On the Review Transactions Find an Existing Value page, enter the Business Unit and Interface ID (optional). Select the Search button.

Transaction Information:

  • P12 Asset Location Changes: Changes the asset’s Location in Basic Add.
  • P15 Physical Asset Adds: Adds an asset to AM.
  • P17 Inventory History Insert: Records the date, time, and person who scanned/inventoried the asset.

Remember to add the financial information for all assets added as part of the PI process!

Search results section displayed.
Expand or collapse content 10. Load into AM

Navigation: Asset Management > Send/Receive Information > Interface Transactions > Load into AM

  1. The Load into AM Run Control search page displays.
  2. If you have run this process or report in the past, enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value button to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_AM_LOAD (Submodule, Process).
  3. Go to the Find Trans Load ID (optional) section:
    1. Enter the college’s Business Unit in the AM Business Unit field.
    2. Select the Physical Records radio button.
    3. Select the Search button. The results will provide the Interface ID for Physical Inventory.
  4. In the Run Control Parameters section:
    1. Process Frequency: Always.
    2. Enter the PI Interface ID into the Interface ID and To Interface ID fields.
    3. Enter the AM Business Unit.
  5. Select the Run button.
  6. On the Process Scheduler Request page, select the OK button.
  7. Please refer to the Process Schedule Request steps for further instructions.
Load into AM page with the AM business unit (twice), Process Frequency, and Physical Records radio button fields highlighted. The Run and Search buttons are also highlighted.
Expand or collapse content 11. PI Reports
  1. QFS_AM_PI_ASSET_HIST: Query to view each asset’s scan history and the physical data changes resulting from the Physical Inventory scan.
Example data populated from the QFS_AM_PI_ASSET_HIST query.
  1. Run the Physical Inventory Report:

Navigation: Asset Management > Physical Inventory > Run Physical Inventory Reports

  1. Select Run Control ID.
  2. Select Physical Inventory ID.
  3. Select the Run button.
  4. Select Reports and select the OK button.
    1. Unders: Assets that are selected to be scanned, but are not scanned.
    2. Overs: Assets added during the scan using “Find Asset” and/or “New Asset”.
    3. PI Results by Location: For each location, lists assets scanned, old and new departments and locations, etc. See example below:
  5. Select the View .PDF files/reports link.
Example PI Results by Location - Inventory example.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.