The integration between DATASCOPE WMS and SYSPRO plays a vital role in your warehouse management process therefore it is critical to ensure that there are no variances between SYSPRO and DATASCOPE WMS.
The Balance Report within DATASCOPE WMS is used for exactly that purpose, therefore this is one of your most critical reports that must be reviewed daily. It shows you the exact SYSPRO quantities compared with the DATASCOPE WMS quantities for each stock code. The Balance Report can be run for either a single warehouse or all your warehouses or for a single stock code or all stock codes.
| Note |
|---|
The ideal is to have all quantities identical in both systems. It is important to note that updating TrackID statuses heavily impact the Balance Report. Any TrackID that is INACTIVE will not appear as available stock on the DATASCOPE WMS side of the Balance Report, and ONHOLD TrackIDs can be excluded with filters. Care should always be taken when updating a TrackID status, and it is strongly advisable that this task only be performed by a DATASCOPE Premium Administrator. |
The Balance Report will show you all imbalances between SYSPRO and DATASCOPE WMS. Some transactions in DATASCOPE WMS, like inactivation of TrackIDs, can cause imbalances between the systems, and the Balance Report will point those variances out.
Let us run a Balance Report.
Select a Warehouse from the Select a Warehouse drop-down
| Info |
|---|
Note: You can run this report for a single warehouse or multiple warehouses or for a single stock code or multiple stock codes. |
Select the Refresh icon
The data grid will populate with all imbalances between SYSPRO and DATASCOPE WMS for the specific warehouse you have selected
You will notice the variance between the two systems in the Variance column
Notice that the SYSPRO information is visible on the left-hand side of the screen as indicated by the column headings and the DATASCOPE WMS information on the right-hand side. The variance between the two systems is indicated in the Variance column
Let us go through the screen to see how we can interpret the data further:
Select the View Detail check box next to the Select a Warehouse drop-down
Select Refresh again to refresh the data grid
Small plus signs will appear on the left-hand side of the screen. You can click on it to open more detail. It shows further DATASCOPE WMS detail to investigate
The best way to fix imbalances shown in the Balance Report is to do a Cycle Count. For more information on Cycle Counting refer to Cycle Counting
You can view and adjust the quantities, once you have captured it using the HTML 5 scanner, under Stock Take and Cycle Counting / Cycle Counting / Cycle Count Approval
| Info |
|---|
Note: The Cycle Count transaction updates both the SYSPRO and DATASCOPE WMS quantities according to the new counted quantities. |
Once the adjustments have been made you will no longer see the record and variance in the Balance Report
If there is a zero variance within the Variance column it means, there are no imbalances for that stock code
You have the option to export the report to either Excel or PDF by selecting the Export buttons
| Info |
|---|
Note: You can also choose to show exceptions only, which is the default, or you can show all balances. All balances will include records with a zero variance. |
You have the option to run the report on a Lot level
To run the Report on a Lot level you must first uncheck the View Details check box
Check the Show Report To Lot Level
Select Refresh to refresh your data grid
| Info |
|---|
Note: An additional layer of information will be added to the Balance Report |
You will now only see Lot traceable items in the report
The option also exist to include ship quantities
These are the ship quantities on the Sales Order in SYSPRO. All Sales Orders with an ‘in Ship’ status within SYSPRO will then display.
Tick the SYSPRO Ship Qty check box
Select the Refresh button to reload the data grid
Notice that an additional column is added to the data grid
Ship quantities are all dependent on how the Shipping Point has been configured within DATASCOPE WMS
| Page Tree Search | ||
|---|---|---|
|
SPECIAL FEATURES
NoneIt is important to note that updating TrackID statuses heavily impact the Balance Report.
The Balance Report can be run for either a single warehouse or all your warehouses or for a single stock code or all stock codes.
You have the option to run the report on a Lot level
The option also exist to include ship quantities
TECHNICAL
None
SYSPRO REQUIREMENTS & Business objects used
None
REFERENCE
RPT003