Balance Report [RPT003]

Owned by DATASCOPE WMS, created
Last updated: Aug 29, 2023
3 min read

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.

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

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

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

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

  • 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

SPECIAL FEATURES

  • It 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