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:
- 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.
- 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.
- 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.
- 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:
- 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).
- 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).
- Verify and review the asset scan results (Steps 5 - 8 below).
- Use Interface Transactions and Load into AM to upload scanned asset information and physical data changes into Asset Management (AM) (Steps 9 - 10 below).
- Generate and review PI reports and data checks (Step 11 below).
Enables end users to specify the criteria that determines which assets will be scanned.
Navigation: Asset Management > Physical Inventory > Define Inventory Occurrence
- To begin a new inventory, select the Add a New Value tab located in the top right of the screen.
- Enter the Physical Inventory ID.
- Select the Add button and the Define Inventory Occurrence page displays.
- Select the Definition tab and enter the:
- PI Name: Make it the same value as the PI ID (recommended).
- Business Unit.
- Start Date: Recommend 01/01/1901, given locations may have that date.
- End Date: When you plan to finalize the PI scan.
- Book Name: Always enter “WACTC”.
- You must select the “Enable Mobile Inventory” checkbox.
- Within the Scan Scope section, select:
- Capital assets for inventory items $10,000 or greater.
- Non-Capital Assets for small and attractive assets.
- Within the Comments section, end users can enter any information useful to them/the college.
- Select the Enter Criteria tab and the Enter Criteria tab displays.
- Within the Select Criteria section:
- Enter the Business Unit.
- Enter other criteria, as needed, to include the assets the college wants to scan.
- The criteria can be a single value or a range of values.
- Within the Select Criteria section:
- Select the Transaction Defaults tab and the Transaction Defaults tab displays.
- Within the Auto Approval section, select the Approve checkbox.
- Within the Transactions Enabled section, de-select the Retirements checkbox.
- De-select Retirements to ensure assets will not automatically retire, and to centrally control when assets are disposed.
- Within the Transaction Defaults section, enter the:
- Transaction Date. Enter a date that is in the current accounting month.
- Accounting Date. Enter a date that is in the current accounting month.
- Transfer convention: AM
- Within the Retirement Defaults section, update the Retirement Convention to AM.
- Select the Save button.
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
- Select the Add a New Value tab.
- Enter the Schedule ID.
- Select the Add button and the Create Inventory Schedules page displays.
- Within the Schedule Details section, enter the:
- Start Date: the date when the inventory may/will begin.
- End Date: The final date when the inventory is anticipated to end.
- PI ID: Same as PI ID set up in Define Inventory Occurrence.
- PI Leader: User’s last name, comma, and first initial.
- Select the Save button.
- Add a new window from the Create Inventory Schedules page:
- Process Load/Match/Reconcile PI in the new window.
Allows end users to create and execute each step of the PI process.
Navigation: Asset Management > Physical Inventory > Load/Match/Reconcile PI Info
- The Load/Match/Reconcile PI Info Physical Inventory Run Control search page displays.
- 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).
- 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.
- Select the box above "Generate Scan Scope".
- Select the Run button.
- On the Process Scheduler Request page, select the OK button.
- Please refer to the Process Schedule Request steps for further instructions.
- 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.
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.
- 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).
- On the Asset Tracking Home page, select the Physical Inventory tile.
- On the Physical Inventory page, enter or search for the PI ID.
- Select the Done button.
- There are three ways to scan assets:
- Print QR and/or Bar codes from ctcLink.
- Can be printed onto label paper to place them on the asset.
- Select the box with an "X" in it on the right of the Scan Value box.
- Scan the assets using a tablet, phone, or scanner.
- Use a scanner, a tablet, or phone to scan a bar code from a third-party vendor.
- Scan assets without a tablet, phone, or scanner:
- Select a “Scan By” method (Tag Number or Serial ID).
- Enter the Tag Number or Serial ID of the asset being scanned into the “Scan Value” box.
- Select the Fetch button.
- Print QR and/or Bar codes from ctcLink.
- 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.
- 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.
- When the Edit button is selected, Edit Scan Record will pop up.
- Missing physical data can be added, and/or existing physical data can be changed or removed.
- Select the Done button to save any changes made.
- Select the three vertical dots in the top right the Physical Inventory page to add assets to the scan.
- Find Asset: add an asset to the scan that is already in Asset Management.
- 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.
- Select “Confirm Manual Scan” on far right to scan the asset and include it in the existing PI scan.
- After it is scanned, select the Edit button to edit the asset’s physical data in Edit Scan Record.
- Find Asset: add an asset to the scan that is already in Asset Management.
- 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.
- After all the asset information is entered, select the Done button in the upper right to save it.
- The asset is now entered to the list of assets scanned.
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
- On the Scan Data Find an Existing Value page, enter the Physical Inventory ID and select the Search button.
- Within the Search Results section, review the data.
- When there is “Y” listed under the Manual Review Required column:
- Select the asset.
- View the data to make any needed corrections/verify the data is correct
- When it is correct, remove the Manual Review Required checkbox to show it is ready to be uploaded into AM.
- Select the Save button.
Generates the PI scan results.
- Select the Load/Match/Reconcile PI Info page within your browser window or navigate to Asset Management > Physical Inventory > Load/Match/Reconcile PI Info.
- Select the Next button to navigate to the Generate Results step.
- Select the Run button.
- On the Process Scheduler Request page, select the OK button.
- Please refer to the Process Schedule Request steps for further instructions.
Navigation: Asset Management > Physical Inventory > Review Matching Results
- On the Inventory Results Find an Existing Value page, enter the Physical Inventory ID and select the Search button.
- Within the Search Results section, review the results for Assets with "Y" listed in the Result in Error column. Select the asset.
- The error description explains the reason for the error on the Results tab (e.g., asset is disposed).
- Assets listed with a “Y” in the Multiple Department Error column:
- This error removes the asset from the PI Scan.
- 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.
- Enter the custodial department for the asset in the Plant field on the Manufacture/License/Custodian page.
- Select an asset to view its Results and Details tabs.
- Results tab: Shows alerts/warnings and Error messages.
- Details tab: Shows current and original values for asset data, to verify changes made.
- Within the Search Results section, review the results for Assets with "Y" listed in the Result in Error column. Select the asset.
Creates an inventory history of assets scanned, and the transactions needed to upload data changes made during the scan into AM.
- Navigate back to the Load/Match/Reconcile PI Info page within your browser window.
- Select the Next button to navigate to the Generate Transactions step.
- Select the Run button.
- On the Process Scheduler Request page, select the OK button.
- Please refer to the Process Schedule Request steps for further instructions.
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
- 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!
Navigation: Asset Management > Send/Receive Information > Interface Transactions > Load into AM
- The Load into AM Run Control search page displays.
- 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).
- Go to the Find Trans Load ID (optional) section:
- Enter the college’s Business Unit in the AM Business Unit field.
- Select the Physical Records radio button.
- Select the Search button. The results will provide the Interface ID for Physical Inventory.
- In the Run Control Parameters section:
- Process Frequency: Always.
- Enter the PI Interface ID into the Interface ID and To Interface ID fields.
- Enter the AM Business Unit.
- Select the Run button.
- On the Process Scheduler Request page, select the OK button.
- Please refer to the Process Schedule Request steps for further instructions.
- QFS_AM_PI_ASSET_HIST: Query to view each asset’s scan history and the physical data changes resulting from the Physical Inventory scan.
- Run the Physical Inventory Report:
Navigation: Asset Management > Physical Inventory > Run Physical Inventory Reports
- Select Run Control ID.
- Select Physical Inventory ID.
- Select the Run button.
- Select Reports and select the OK button.
- Unders: Assets that are selected to be scanned, but are not scanned.
- Overs: Assets added during the scan using “Find Asset” and/or “New Asset”.
- PI Results by Location: For each location, lists assets scanned, old and new departments and locations, etc. See example below:
- Select the View .PDF files/reports link.

















0 Comments
Add your comment