Original F1
FUNCTIONALITY OVERVIEW
DATASCOPE WMS has a Cycle Counting tool which is a combination of PC-based and scanner-based modules.
This counting tool allows us to select a range bin locations to count. A scanner is then taken into the warehouse to these locations and stock items in the bin locations are counted. No "locking" of bins is required in DATASCOPE WMS. The software manages all movements before and after the count has taken place. An operator can therefore cycle count a bin location at any time without having to place the bin is a locked down mode.&edsp;
Once all counting is completed the user can then review the Variances on the PC Cycle Count Approval screen. This screen shows what was counted, versus what WMS says should be there, versus what SYSPRO says is in that bin location.&edsp;
On accepting each line the relevant transaction will be carried in SYSPRO and/or the WMS to balance the report.
Each bin that has been counted is shown. 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 there is red, a variance is present.
E.g. If the count balances with WMS but not SYSPRO, the figure in the WMS column would be green and the SYSPRO column would show in red.
Most often when a variance occurs both columns will be shown in red.
STANDARD PROCESS
The user will need to evaluate each line and accept variances where applicable. Once a variance has been marked as accepted (the check box is ticked) the “Post to SYSPRO” button is clicked.&edsp;
A SYSPRO stock adjustment is only recorded if there is a need to adjust the SYSPRO stock (i.e. in some cases only the WMS stock will be adjusted). When a SYSPRO inventory adjustment is processed there us a specific reference. By default this is set to&edsp;&edsp;CC_ADJ (indicating cycle count adjustment). There is a setting which allows for this reference to be customized.
The track id history report (tblPalletAction) and quantities in WMS and SYSPRO are updated only when the user posts on this screen. No change to the pallet takes place when the count occurs on the scanner.&edsp;
SPECIAL FEATURES
You can drill into more information pertaining to a line on the cycle count screen. This shows if this was cycle counted more than once and for each time this was counted the details of that count, including the reason selected on the scanner drop-down is displayed.
Counts can be deleted off of the screen, the line will be removed and this count will not be available to accept. This is useful, for example, where the wrong location was counted
A system setting allows an upper and lower limit on variance value per line. Lines with a variance exceeding this value are shown n grey to the users that do not have permission to accept them.&edsp;
Only 1 user is permitted into the cycle count screen at once, to prevent duplicate postings.
As the screen is opened, the pallet bin locations are verified. If a pallet that has been counted in one bin has moved to another bin since the count, the line for the count against the original bin will need to be deleted and the bin/pallet should be recounted. A pop up to indicate this is displayed.
The number of rows to show on the screen as it is opened can be set (system setting). Clicking fetch more data will bring more rows to the screen.
SYSPRO Requirements & Business objects used
Inventory Primary posting
DATASCOPE Table updates
tblPalletItem
tblPallet
tblPalletAction
tblCycleCount
tblCycleCountLock
tblCycleCountHistory
Code Block | ||
---|---|---|
| ||
<span style="font-family:Arial; font-size:9pt;"><span style="font-weight:bold;text-decoration: underline;"><br/>FUNCTIONALITY OVERVIEW</span><br/><br/>DATASCOPE WMS has a Cycle Counting tool which is a combination of PC-based and scanner-based modules.<br/><br/>This counting tool allows us to select a range bin locations to count. A scanner is then taken into the warehouse to these locations and stock items in the bin locations are counted. No "locking" of bins is required in DATASCOPE WMS. The software manages all movements before and after the count has taken place. An operator can therefore cycle count a bin location at any time without having to place the bin is a locked down mode.&edsp;<br/><br/>Once all counting is completed the user can then review the Variances on the PC Cycle Count Approval screen. This screen shows what was counted, versus what WMS says should be there, versus what SYSPRO says is in that bin location.&edsp;<br/><br/>On accepting each line the relevant transaction will be carried in SYSPRO and/or the WMS to balance the report.<br/><br/>Each bin that has been counted is shown. Color is used to indicate the status of each line:<br/><br/>• If the text is green , the counted total matches what is recorded in SYSPRO and WMS<br/>• If there is red, a variance is present.<br/><br/>E.g. If the count balances with WMS but not SYSPRO, the figure in the WMS column would be green and the SYSPRO column would show in red.<br/> <br/>Most often when a variance occurs both columns will be shown in red.<br/><br/><span style="font-weight:bold;">STANDARD PROCESS</span><br/>• The user will need to evaluate each line and accept variances where applicable. Once a variance has been marked as accepted (the check box is ticked) the “Post to SYSPRO” button is clicked.&edsp;<br/>• A SYSPRO stock adjustment is only recorded if there is a need to adjust the SYSPRO stock (i.e. in some cases only the WMS stock will be adjusted). When a SYSPRO inventory adjustment is processed there us a specific reference. By default this is set to&edsp;&edsp;CC_ADJ (indicating cycle count adjustment). There is a setting which allows for this reference to be customized.<br/>• The track id history report (tblPalletAction) and quantities in WMS and SYSPRO are updated only when the user posts on this screen. No change to the pallet takes place when the count occurs on the scanner.&edsp;<br/><br/><span style="font-weight:bold;">SPECIAL FEATURES</span><br/>• You can drill into more information pertaining to a line on the cycle count screen. This shows if this was cycle counted more than once and for each time this was counted the details of that count, including the reason selected on the scanner drop-down is displayed.<br/>• Counts can be deleted off of the screen, the line will be removed and this count will not be available to accept. This is useful, for example, where the wrong location was counted<br/>• A system setting allows an upper and lower limit on variance value per line. Lines with a variance exceeding this value are shown n grey to the users that do not have permission to accept them.&edsp;<br/>• Only 1 user is permitted into the cycle count screen at once, to prevent duplicate postings.<br/>• As the screen is opened, the pallet bin locations are verified. If a pallet that has been counted in one bin has moved to another bin since the count, the line for the count against the original bin will need to be deleted and the bin/pallet should be recounted. A pop up to indicate this is displayed.<br/>• The number of rows to show on the screen as it is opened can be set (system setting). Clicking fetch more data will bring more rows to the screen.<br/><br/><span style="font-weight:bold;">SYSPRO Requirements & Business objects used</span><br/>• Inventory Primary posting<br/><br/><span style="font-weight:bold;">DATASCOPE Table updates</span><br/>• tblPalletItem<br/>• tblPallet<br/>• tblPalletAction<br/>• tblCycleCount<br/>• tblCycleCountLock<br/>• tblCycleCountHistory</span><br/>
|
New F1
Code Block |
---|