processing physical inventory - core-ct · 1/3/2017  · processing physical inventory asset...

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

1

Processing Physical Inventory

In Core-CT 9.2, Asset Management will adopt PeopleSoft’s Fluid UI. Fluid UI will support real-

time asset scanning with Bluetooth enabled mobile devices. As such, there will be changes to

setting up and processing physical inventory. Asset Processors will perform every physical

inventory step except for asset scanning.

Perform Mobile Physical Inventory

Step Name Role

1 Define Inventory Occurrence

Physical Inventory Processor

2 Generate Scan Scope

Physical Inventory Processor

3 Scan Asset Inventory Scanners

4 Generate and Review Results Physical Inventory

Processor

5 Generate and Load Transactions

Generate - Physical Inventory Processor

Load – Asset

Processor

6 Delete Data

Physical Inventory Processor

Note: This job aid is intended for the Asset Processor role.

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

2

Define Inventory Occurrence Navigation:

Asset Management > Physical Inventory > Define Inventory Occurrence

1. Click the Add a New Value tab

2. Enter the PI ID

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

3

3. Click the Add button

4. Enter PI Name and Physical Inventory Parameters

Note: The start and end dates must match to acquisition dates for the asset to be

included.

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

4

5. Select the Enable Mobile Inventory checkbox 6. Ensure Capital Assets and Non-capital Assets are selected

7. Click Enter Criteria tab

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

5

8. Enter the Selection Criteria

9. Click the Transaction Defaults tab

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

6

10. Ensure the Auto Approval box is checked and the Non-Fin Adds, Physical Asset

Changes, and Asset Updates are selected

11. Enter the Transaction Defaults

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

7

12. Click Save

Use the Load/Match/Reconcile PI Info page to execute each step of the Physical Inventory

process. It is required that you add a new run control ID for each physical inventory. Also use

this run control ID for subsequent steps within the same PI ID.

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

8

Generate Scan Scope This process automatically defines a set of assets that should be scanned and provides that list

to the Physical Inventory page, which is accessible from your mobile scanning device.

Navigation:

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

1. Click the Add a New Value tab

2. Enter a new Run Control ID

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

9

3. Click the Add button

4. Enter PI ID or Inventory Occurrence to be processed

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

10

Note: The process will change from six steps to four steps, this is correct for mobile

inventorying.

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

11

5. Click Run

6. The Run Physical Inventory (AMPl1000) process is checked 7. Select PSUNX Server Name

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

12

8. Click OK 9. Click Process Monitor link

10. Click Refresh periodically until the AMPl1000 completes with a Run Status of Success

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

13

11. Click the Go back to Physical Inventory link

12. Notice the Last PI Step Executed is Generate Scan Scope Executed

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

14

Perform Physical Inventory Generate Results Step 2 performs matching between a physical inventory scan scope and scanned data, and

creates physical inventory results for review

Navigation:

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

1. Enter Run Control ID

2. Click Search

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

15

3. Click Run

4. The Run Physical Inventory AMPl1000 process is checked 5. Select PSUNX Server Name 6. Click OK

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

16

7. Select Process Monitor

8. Click Refresh periodically until AMPl1000 completes with a Run Status of Success and

Distribution Status of Posted

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

17

9. Click the Go Back to Physical Inventory link

10. Notice the Last PI Step Executed is PI Results Generated

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

18

Review Results Navigation:

Asset Management > Physical Inventory > Review Matching Results

1. Enter Physical Inventory ID

2. Click Search

3. Review Results

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

19

4. Click the Details tab to view the values produced from the scanner versus the original values from the system

5. Click Previous in List and Next in List to view additional Matching Results OR Click Return to Search and choose an entry to view from the search listing

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

20

Generate Transactions Navigation:

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

1. Enter Run Control ID

2. Click Search

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

21

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

22

3. Click Run

4. The Run Physical Inventory AMPl1000 process is checked 5. Select PSUNX Server Name 6. Click OK

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

23

7. Select Process Monitor

8. Click Refresh periodically until AMPl1000 completes with a Run Status of Success and

Distribution Status of Posted

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

24

9. Click the Go Back to Physical Inventory link

10. Notice the Last PI Step Executed is Transactions Generated

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

25

Load Transactions Asset Management > Send / Receive Information > Load Transactions > Load Transactions into

AM

1. Enter Run Control ID

2. Click Search

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

26

3. In the Find Trans Load ID (optional) section: a. Set the System Source field to AM Batch b. Set the Load Type to Inventory History Insert c. Set the Load Status to Pending d. Select the Physical Records button

4. Click the Search button

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

27

5. The Interface Information section displays a list of pending interfaces, copy the Interface ID

and paste it into the Interface ID and To Interface ID in the Run Control Parameters section.

6. Click Run

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

28

7. The Asset Transaction Loader (AMlF1000) process is checked 8. Select PSUNX Server Name 9. Click OK

10. Select Process Monitor

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

29

11. Click Refresh periodically until AMlF1000 completes with a Run Status of Success and

Distribution Status of Posted

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

30

Delete Data When you no longer need your physical inventory data, select one of the following options and

click the Run button.

Navigation:

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

1. Enter Run Control ID

2. Click the Search button

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

31

3. Select the appropriate form of Delete Data Delete All - Select to delete all physical inventory data generated for the specified Physical Inventory ID: (Scan Data, Result Data, and Transaction Data). Delete Extract Data – Select to delete the physical inventory extract data. Delete Scan Data – Select to delete the physical inventory scan data. Delete Result Data – Select to delete the physical inventory results data. Delete Transaction Data – Select to delete the physical inventory transaction data.

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

32

4. Click the Run button

5. The Asset Transaction Loader (AMlF1000) process is checked 6. Select PSUNX Server Name 7. Click OK

Processing Physical Inventory Asset Management

Updated As Of: January 3, 2017 Core-CT Financials 9.2

33

8. Click the Process Monitor link

9. Click Refresh periodically until AMlF1000 completes with a Run Status of Success and

Distribution Status of Posted