| Page Tree Search | ||
|---|---|---|
|
SPECIAL FEATURES
TECHNICAL
SYSPRO REQUIREMENTS & Business Objects used
REFERENCE
STK052
REPORT DESCRIPTION
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.
STANDARD PROCESS
Select a date range and other desired filters
Run the report by clicking the refresh button
SPECIAL FEATURES
All stock codes in the company can be displayed, to get an overall picture, as opposed to just seeing stock codes that were countedEnter 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.
| Info |
|---|
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.
| Page Tree Search | ||
|---|---|---|
|
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