Various discount reports show discounts for inactive products

Various discount reports show discounts for inactive products

Symptoms

When the discount reports are run, discounts for products that are marked as inactive appear on the report.

Cause

There are two causes. The first is that the SQL in the reports are setup to not filter by the products' active status.

The second is that on some of the reports, for example the Discounts by Customer - Active, the SQL of the report what fixed but the Data Source properties in the reports' configuration file (.xml) was not, and this is what's used by SWCS. The actual SQL is only used by the Solatech Report Writer.

Workaround

There is no known workaround at this time.

Resolution

The reports needs to be made consistent, in both the report SQL and the configuration file.

Status

The discount reports were fixed with version 4.2.0.253 which was released with update SU080711.

Applies To:

  • Solatech Window Covering Software 4.0
  • Solatech Window Covering Software 4.1
  • Solatech Window Covering Software 4.2

    • Related Articles

    • Discounts for deactivated products show up on discount reports

      Symptoms This article explains an issue found that when printing discount reports, discounts for deactivated products appear on the reports. Cause The discounts reports run off the discount data, not the products. If a discount has been setup for a ...

    • Managing Vendor Discounts

      Summary  This article explains how Vendor Discounts are managed in SalesPRO. More Information We will be working with functions found on the Maintenance tab. General  Vendor discounts are the factors provided by the vendor/manufacturer to you, the ...

    • How to identify products with missing vendor discounts or margins

      Summary Solatech gives Account Administrators the ability to easily identify products that are missing either vendor discounts (used to determine cost) or margins (used to calculate selling price).  This knowledge base article will describe how to ...

    • How to add discount amount and subtotal to process reports

      Summary This article describes how to add additional discount amounts and subtotals to process reports. More Information Beginning with Solatech Software version 4.2.0.417, users can add a Subtotal field to process reports (such as Quotes, Invoices ...

    • Setting up Process Reports and Email Templates

      Summary Account Administrators can setup multiple versions of Process Reports that can be printed, previewed or emailed to customers or other users. This knowledge base article will describe how to setup and use process report templates Accessing and ...