This is an overview document of Stock Count Variances. There are other articles that will tell you how to actually run the Stock Count Variance and reconcile it.
Steps in the screenshots correspond to the numbers in the headings.
Before running the variance, all counted quantities must be entered in the USABLE field of the Stock Count Screen for your Run ID.
1. When you press the Variance button in the header, the calculation begins.
2. The system calculates the quantity you entered for each part vs. the quantity the system shows on hand. Go to File > Run Log. Under the General Tab, select Stock Count Variance for the Run Type.
3. Click on the IDs tab and enter the Foreign Key Char1: (Run ID number).
4. Checking the Run Log will confirm that there are no errors in processing the variance.
A blank Run Status Description = No Errors.
5. The first report you want to look at is Stock Count Variance Detail.
6. From your Internet Browser, go to the ATS Reporting Server.
7. You may need to open the ATS_FMS_Reports folder first if you have not made this report one of your favorites.
8. Click on the Stock Count Variance Detail Report.
9. Enter your four digit site number.
10. Enter the Stock Count Run ID NUMBER.
11. The default is "All Variances". This is what you want.
12. Click the VIEW REPORT button to start processing the report.
13. A message tells you that the report is processing.
14. You will know that the report is loading properly when the bar below the report criteria appears. If you do not see the bar after 2-3 minutes, hit Cancel, and VIEW REPORT again. If it is a very large report or your site has very slow internet connectivity, you may want to wait as long as 5 minutes.
15. Remember to export the report to PDF and keep for your records.
This report shows the variance (positive or negative) for every part on the Stock Count.
- All parts with a variance should be re-counted - both positive and negative.
- If changes are found, update the revised count in the system on the Stock Count screen.
- Press the Variance button once again.
You will want to Export and save EVERY TIME YOU RUN THE VARIANCE FOR YOUR RECORDS. NO COPIES ARE SAVED IN THE SYSTEM.
16. Once you're satisfied that the numbers are accurate, run the Stock Count Variance Summary Report.
This is the total financial impact to your inventory when you Post the Cycle Count.
Export and save the report as a .pdf as it is not saved in the system.
17. Post the Stock Count to complete the process. eFACTORYPRO updates the count quantity adjustments for the user when the Stock Count is posted. There is no need to also go into Logistics Manager and manually enter Miscellaneous Adjustments to correct Stock Count Variance quantities.
0 Comments
Add your comment