1.3 How can I determine which parts are due for a Cycle Count?

Updated on Jun 09, 2020

1. Open the ATS Reporting Server.

https://ssrs.advancedtech.com/Reports

2. Run the Simple Inventory Status Report.

Remember, if your site has Customer owned inventory, you will select Customer for the location, if you carry only ATS owned parts, you will choose ATS for the location.

If you have both ATS and Customer owned merchandise at your site, you will run your Cycle Counts separately, but you can always run the Inventory Status report with both locations, as it separates the results by location.

3. Click on the floppy disc icon to export the report to EXCEL.

4. Open the file and sort the "Last Counted Date" column in ascending order so the oldest date is on top.

5. Determine approximately how many parts you want to count and select the corresponding date.

0 Comments

Add your comment

Previous Article 1.2 How do I create a Cycle Count?

Next Article 1.4 What mandatory fields should I enter if I am creating a Cycle Count?

Supply Chain Specialist Documentation

1. Cycle Counts & Physicals 19

2. Requisitions / Purchase Orders 24

3. Receiving: Parts & GNS 27

4. Understanding Inventory Management in eFP3 44

5. Inventory Transactions 19

6. SCS Reports 25

7. Step by Step Instructions for Supply Chain Specialists 11

8. SAP to EFP Purchasing Conversion Cheat Sheets 6

Other Resources