Cycle Count Analysis [STK052]

Owned by DATASCOPE WMS
Last updated: Aug 08, 2024
2 min read

The Cycle Count Analysis report analyzes Cycle Count History. By using the various filters, dragging up data to sort and sum the data into various forms can assist the user in identifying trends from past Cycle Counts.

For example, drag up Year and Month and ABC Classification. The report will then show all count summaries for each year broken up by month and ABC Classification.

  • Enter the From Date and To Date. It’s a good idea to run this report for an entire year.

  • The From Stock Code and To Stock Code filters can also be used.

  • The report can also be run for a specific warehouse. Select the warehouse from the Warehouse drop-down menu.

  • Other useful filters are:

o   Show All Stock Codes – this check box is selected by default and will show all stock codes.

o   Only Show Counted – this option will only display bins already counted.

o   Include No ABC Class – this option will display bins with no SYSPRO ABC category defined.

Note: The ABC category in SYSPRO categorizes stock codes into four classes using PA-REEE-TOE analysis, which is the 80/20 principle. Concentrating on your A-class items can achieve greater results with less effort. When companies need to establish the percentage of each product contributing to the overall costs, they can use the ABC Classification facility in SYSPRO to monitor this over some time. In SYSPRO, each stock code is typically registered as an A, B, C, or D item. This is done under Inventory / Reports / ABC Analysis. This is the classification that the Cycle Count Analysis report displays.

  • The report displays a progress bar under the filter options, which displays a percentage of how many stock codes have been counted versus the total number of stock codes linked to the selected warehouse in SYSPRO.

  • To start analyzing the data, you can drag the column heading to the Drag a column heading here to group by that column section.

  • Expanding the columns in the data grid will give you a good idea of how many items per ABC category, per month, and per year have been cycle counted.

This report can be used in conjunction with the Cycle Count History report to prove that certain stock codes are being counted timeously. This reduces the requirement for a full wall-to-wall stock count at yearend, which consumes manpower and reduces available production hours.

SPECIAL FEATURES

  • None

TECHNICAL

  • None

SYSPRO REQUIREMENTS & Business Objects used

  • In SYSPRO, the ABC Classification function relates to Pareto Analysis, a commonly known term in Inventory Control. When a company needs to establish the percentage each product contributes to the overall costs, they can use the ABC Classification facility in SYSPRO to monitor this over a period of time.

REFERENCE

STK052

Â