eFactoryPro Wiki

1.16 What do I need to do to run a Physical Inventory?

Updated on

Steps in the screenshots correspond to the numbers in the headings.

Unlike Cycle Counts, Physical Inventories are conducted only once a year and count ALL of the stock at one time.  Physical Inventories are usually done only on ATS owned inventory.

It is possible that your specific Site's Contract could ask for a Physical inventory to be conducted more than once a year, and/or that we count Customer-owned merchandise.  Please contact your Supply Chain Support Team if you have questions.

Your Supply Chain Support Specialist will be working with you to coordinate the details around your physical inventory.

It is critical that these steps are followed so that all merchandise is counted, and the numbers are accurate.

1. All previous Cycle Counts must be completed and posted, or deleted.

Everything is going to be re-counted in the physical so it is perfectly fine in this case to delete the open cycle count.

1.1. Go to Inventory>Logistics>Stock Counts.

1.2. Expand the Red Chevron in the Search Field. Click on the Place Tab and enter your Place ID and hit the Green Magnifying glass to bring up all Stock Counts that are open for your site.

In this case, there are two Stock Count Runs open:  Number 241 and 243.  

1.3. Contact your SCS Program Manager and ask them to delete these runs.  They will bring up the Runs you want to delete.

1.4. Then they will click the Delete Run Button. This button is not available to those without site SCS privileges.

1.5. They will be asked to confirm.  Click Yes.

1.6. The message says the process has begun.  Press OK.

1.7. Check the Run Log. File > Run Log.

  1. Expand the Red Chevron in the Search Field.
  2. Under the General Field, Select Stock Count Delete from the Run Type drop-down.
  3. Under the ID tab, enter your run ID in the Foreign Key Num1 Field.

1.8. Confirm that the Delete processed properly.

  1. Check the number of records is as expected.
  2. Check the Run Status says "Complete".  If this is a large Stock Count, it may take some time to complete and the status may originally say "In Progress".  Please hit F5 to refresh the screen until you see the Complete Status.
  3. Check the Run Status Description.  IT SHOULD BE BLANK.  If you see any errors, go back and delete the run again.

1.9. Have them repeat Steps 3-8 until there are no open runs for your site.

To confirm that everything is completed or deleted, repeat step 2,  There should be no results returned.

2. Run the Inventory Status Report.   Save a copy in your Cycle Count folder.

3. Create the Physical Inventory Count.  

3.1. From the Main Menu, go to Inventory > Logistics > Stock Count.

3.2. Click NEW.

3.3. Choose PHYSICAL as the Count Type.

3.4. Enter your ST number in the Place Id field.

3.5. Enter ATS in the Location field.

3.6. Leave the "Ours Only*" checkbox shaded.

3.7. Choose BIN as the Sort Order.

3.8. Enter a checkmark in the box for Suppress Lines of Zero Quantities.

3.9. Click Save.

3.10. A message will appear telling you to check the run log.  Click OK.

3.11. From the Main Menu, go to File > Run Log. Expand the Red Chevron in the Search Field and enter STOCK COUNT RUN in the Run Type.

3.12. Click on the ID Tab and enter the Run ID under Foreign Key Num1.  Click the Green Magnifying Glass to load.

3.13. Ensure the Run Status says COMPLETE.

3.14. Note the number of records processed.  This will be the number you count, the number you must post, etc.

3.15. The Run Status Description should be blank.  There should be no errors or exceptions.

This Physical Inventory was run on the Training Environment which is why there are so few items to count.

4. Run the Stock Count Sheet Report.  Download a copy of the report and save it to your Cycle Count folder.

5. Enter the Stock Count into the system.

6. Run the Stock Count Variance Detail Report.  Download a copy of the report and save it to your Cycle Count folder.

7. Recount any variances. Correct any errors in the system.

8. Re-run the Stock Count Variance Detail Report.  Download a copy of this second variance report and save it to your Cycle Count folder.

9. Once you are satisfied, run the Stock Count Variance Summary Report to see the total financial impact of the Physical. Download a copy of the report and save it to your Cycle Count folder.

10. With your Manager's approval, click POST RUN to post the count.

11. Check the Run Log again (Type = Stock Count Post) to make sure that all records have processed correctly and there have been no stock count errors.

12. Re-Run the Inventory Status Report.  Save it in your Cycle Count file.

If you have any questions on this process, please contact a member of your Supply Chain Support Team.

0 Comments

Add your comment

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

Previous Article 1.15 What do I do if I find a part in the bin that wasn't on the Cycle Count Sheet?
Next Article 1.17 I found an additional part not listed on my Physical Inventory Count Sheet. How do I add it?