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.
| Info |
|---|
This approval screen is also used for Scheduled Cycle Counts. |
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.
| Info |
|---|
If you don’t like reading, you can watch the video. |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
fasttrack_CYCLE_COUNTING_Training_General_Transactions_QG - v0.4.pdf 001_Premium_CYCLE_COUNT_SCHEDULER_ADVANCED_product_UG - v0.1.pdf |
Try it!
From the Main Menu browse to Stock Take and Cycle Counting / Cycle Counting / Cycle Count Approval
| View file | ||
|---|---|---|
|
The Cycle Count Approval screen will open
| Info |
|---|
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. |
The filter options also allow the user to decide how to post the variances to SYSPRO. The following two options are available:
o Post by Batch – this option allows the user to post all lines selected on the screen.
o Post by Line - allows the user to post each adjustment separately.
Select the Refresh icon
| Info |
|---|
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. |
| Info |
|---|
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
| Info |
|---|
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
| Info |
|---|
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.
| Info |
|---|
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
| Info |
|---|
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
A pop-up will appear depending on the selected post method (Post by Line vs Post by Batch).
If Post by Line has been selected.
If the Post by Line filter option was selected, a Post Error column will be updated if the line failed to post. These error messages will be displayed in red text.
If the Post By Batch has been selected.
| Info |
|---|
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 |