The Cycle Count History report reports on Cycle Counts that have occurred over time. The primary use of this report is to ensure that regular Cycle Counts are being completed and that the accuracy of the counts is within an acceptable measurement.
In companies with very high stock accuracy levels, the report can convince the company tax auditors to accept the inventory data at year-end without doing a year-end stock take.
codeSelect Enter the required date range in the From Date and To Date for which the report must run.
Various filters can be selected to review the data.
Show Counted Bins will display all the Bins that have been counted.
Show Non--Counted Bins will display all the Bins that haven’t been counted.
Accept will display all the Bins that have been counted and the count was Accepted in the Cycle Count Approval module.
Reject will display all the Bins that have been counted and the count was Rejected in the Cycle Count Approval module.
Balance will display all the Bins counted and the count Balance.
If changes were made to the filters, select the Refresh icon to reload the data grid.
| Page Tree Search | ||
|---|---|---|
|
SPECIAL FEATURES
None
TECHNICAL
None
SYSPRO REQUIREMENTS & Business Objects used
None
REFERENCE
STK051
REPORT DESCRIPTION&edsp;
The Cycle Count History report is used to report on cycle counts that have taken place over time. The primary use for this report is to ensure that regular cycle counts are being completed and that the accuracy of the counts is within an acceptable measurement.&edsp;
In companies with very high levels of stock accuracy the report can be used to convince the company tax auditors to accept the inventory data at year end without having to do a year end stock take.
STANDARD PROCESS
Select a date range and any other applicable filters
Click the refresh buttons to run
SPECIAL FEATURES
‘Accept’ will show all bins that have been counted and the count accepted
‘Reject’ will show all bins that have been counted and the count rejected
‘Balanced’ will show all bins that have been counted and the count balanced
| Code Block | ||
|---|---|---|
| ||
<span style="font-family:Arial; font-size:9pt;"><span style="font-weight:bold;text-decoration: underline;"><br/>REPORT DESCRIPTION&edsp;</span><br/><br/>The Cycle Count History report is used to report on cycle counts that have taken place over time. The primary use for this report is to ensure that regular cycle counts are being completed and that the accuracy of the counts is within an acceptable measurement.&edsp;<br/><br/>In companies with very high levels of stock accuracy the report can be used to convince the company tax auditors to accept the inventory data at year end without having to do a year end stock take.<br/><br/><span style="font-weight:bold;"><br/>STANDARD PROCESS</span><br/>• Select a date range and any other applicable filters<br/>• Click the refresh buttons to run<br/><br/><span style="font-weight:bold;">SPECIAL FEATURES</span><br/>• ‘Accept’ will show all bins that have been counted and the count accepted<br/>• ‘Reject’ will show all bins that have been counted and the count rejected<br/>• ‘Balanced’ will show all bins that have been counted and the count balanced<br/></span><br/>
|
New F1
fields.
Other filter options like Warehouse, Bin, Stock Code, and TrackID are available.
To display only the counted bin, select the Show Counted Bin check box. This check box will be checked by default.
To display only uncounted bins, select the Show Non-Counted Bins check box.
To display only accepted counts (this is where variance was agreed and the stock QTYs changed), select the Accept check box.
To display only balanced counts (this is where there was no discrepancy between the physical count, the SYSPRO bin QTY, and the DATASCOPE PREMIUM WMS pallet QTY), select the Balance check box.
To display only the rejected counts (where there were variances but weren’t correct), select the Reject check box.
The last Cycle Count date and time can be seen in the Counted Date and Counted Time columns.
A reason code is visible in the Cycle Count Reason column.
The SYSPRO Cost Variance and SYSPRO Actual Variance is also visible.
The report can be exported to Excel by selecting the Export to Excel button.
Businesses use this report to demonstrate to their legal auditing firms that if they cycle count their entire warehouse within 5 to 6 months, they do not need to perform a full wall-to-wall stock take at the end of the year.
| Info |
|---|
Note: A Balanced count is when the captured quantity matches the DATASCOPE WMS theoretical quantity and matches the SYSPRO quantity for the stock code and/or Lot. |
You can rectify your Balance Report and align the two systems (SYSPRO and DATASCOPE WMS) to what is physically in the warehouse by using this Cycle Count module.
| Page Tree Search | ||
|---|---|---|
|
SPECIAL FEATURES
None
TECHNICAL
None
SYSPRO REQUIREMENTS & Business Objects used
None
REFERENCE
STK051