How To: Hide Discounts on Sales Invoice Report

This functionality changes the way that discount percentages and discount values are displayed on Basic Report's Sales Invoice series reports.

In order to use this functionality, it will first need to be enabled in the "Basic Reports Setup" dialog and then configured using the Report Builder Designer tool, which can be quite technical. Please contact KCSL if you require assistance setting this up.


  1. Follow the menu route [ System Operations | Basic Reports Setup ] to open the "Basic Reports Setup" dialog.
  2. From the dialog's [ Reports List ] tab, double-click on "Invoice Report".
  3. Press the Basic Reports Design button button to edit the Sales Invoice's report template using Report Builder Designer.
  4. Click on the srDetails: DBDetails tab at the bottom of the screen.
  5. Select the field used to display the Disc% column (by default this Discount field should be displaying DBDetails:Discount).
  6. Right click and select "Display Format" from the context menu.
    Change the display format for this field [1]to:
    #,0.00#;-#0.00#;"NET"
  7. Select the field used to display the Disc Unit column in the srDetails sub-report (by default this eDiscount field should be displaying DBDetails:calc_net_discount_unit).
  8. Right click and select "Display Format" from the context menu.
    Change the display format for this field [1] to:
    currency;currency;"NET".
  9. Save a close the Design screen.
  10. To enable this functionality tick the "Discount Unit Zero When No Discount" checkbox:

    Basic Reports Setup dialog

  11. Press the dialog's "OK" button to save the checkbox setting.i

Notes

  1. ? 1.0 1.1 In steps 4 and 5, you can put anything where it says NET, this is the value that will appear instead of zero on the invoice report. To leave the column blank, use "" (e.g. #,0.00#;-#0.00#;"")

See Also


Did you find this article helpful?