Stock Take and Cycle Counting / Cycle Counting / Cycle Count Approval [STK011]
After users have physically counted the range of bins that require a Cycle Count, the Supervisor must review the variances on the pc-based Cycle Count Approval screen.
This screen displays a comparison between the actual count, as recorded by WMS, and the inventory quantity reported by SYSPRO for the specific bin locations.
On accepting each line the relevant transaction will be carried in SYSPRO and/or the WMS to balance the report.
If you don’t like reading, you can watch the video.
Try it!
From the Main Menu browse to Stock Take and Cycle Counting / Cycle Counting / Cycle Count Approval
The Cycle Count Approval screen will open
Note: Ensure you are in the same warehouse as where the physical count happened. Use the filters at the top of the screen to adjust the warehouse.
Select the Refresh icon
Note: The default FASTTRACK WMS installation has a zero-value upper and lower variance limit in the settings. Due to these settings, you will get a pop-up indicating this. You can select Yes to override this.
These upper and lower values can be changed in the System Settings. From the Ribbon bar, select Settings / System Settings and locate CYCLECOUNTING in the System Name drop-down. Update the VARIANCE_LOWER_VALUE and VARIANCE_UPPER_VALUE figures. The software will validate your new figures and show a pop-up or not depending on these values.
The data grid will refresh with all the counted, but not yet processed, transactions
You will see all the details of your captured information in the data grid, which includes the WMS Qty and SYSPRO Qty, which is the theoretical stock on hand, with the variances for both WMS and SYSPRO of the quantity that has been scanned
Color is used to indicate the status of each line.
If the text is green, the counted total matches what is recorded in SYSPRO and WMS
If it is red, a variance is present.
Example: if the count balances with WMS, but not SYSPRO, the figure in the WMS column would be green and the SYSPRO column would be red.
The supervisor will compare these values to decide whether to post each adjustment or not
Note: The Bin or TrackID can always be re-counted at any time
Selecting the plus sign next to the Bin column will open a second row, revealing the TrackID detail of the count
If you want to do a re-count of the entire Bin, you must right-click on the Bin line and select Delete Count Item
If you want to do a re-count of only a TrackID within a Bin, you can right-click on the TrackID line under the Bin (you must expand the Bin first) and select Delete Count Detail Item.
A pop-up will appear, stating that the TrackID will be removed from the Cycle Count and must, therefore, be re-counted.
If a TrackID is deleted to be re-counted, it will be removed from all Bins.
Users on the physical floor must then do a re-count of the Bin and TrackIDs with the HTML 5 scanner Cycle Count module.
Right-clicking on a row and selecting Count Details will display which user did the count, a TimeStamp when the count was done and any adjustments that have been made before accepting the count. A Cycle Count Reason is also visible. To create these Reason Codes - Cycle Count Reason Codes
You also have the option to move a TrackID from one Bin to another Bin. Right-click on the TrackID lien and select Move TrackID to Bin.
The TrackID number will be visible in the TrackID field. Add the new Bin number in the To Bin field and select Post.
If you scroll to the right-hand side of the data grid you will notice a SYSPRO Notation column. This is a free format field where you can type a text reference for the post to SYSPRO
Once you reviewed all the details and are ready to continue you can scroll to the far right of the data grid and select the Accept Variance check box
Note: If there is a long list of adjustments you also have the option to Accept All. Select the Accept All button at the top of the data grid.
You also have the option to Reject the variance, similar to accepting the variance. This will not post the adjustment but will only log it in the system that it was counted. These records will then be recorded in the Cycle Count History Report
After you have marked all the lines in the data grid as either Accepted or Rejected you can select the Post to SYSPRO button. This will transact all the accepted lines in both SYSPRO and DATASCOPE WMS. The Rejected lines will be recorded as counted, but nothing will be adjusted
Note: All accepted lines that are successfully posted will adjust both the TrackID quantities in DATASCOPE WMS and the Bin locations in SYSPRO to the captured quantities. The financial value will be posted to your Inventory Adjustment GL code in SYSPRO