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 in Solatech Focus, Site Admin

      Summary Site Administrators have the ability to change or add vendor discounts for any of their accounts when needed. This document explains the process of updating vendor discounts. More Information During the initial setup of your Focus site, a ...

    • Managing Vendor Discounts in Solatech Focus, for Account Admins

      Summary Account Administrators have the ability to change or add vendor discounts for their account when needed. This document explains the process of updating vendor discounts. More Information During the initial setup of your Focus site, a discount ...

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

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