Summary
This article explains how to add the additional line item discount to process reports; to display along
with the description, unit price, total price, etc.
More Information
The additional line item discount is not shown on the standard process reports by default. In order to
add this field you will need to create a modified process report and add the additional line item
discount field to the line item section.
Adding the additional line item discount is broken in to 4 stages:
- Creating a modified process report
- Setting up the modified process to be used
- Adding the additional line item discount
- Testing the report
Note: This steps in this example use a quote however the process is the same for any modified
process report.
Creating a modified process report
In order to make any changes to a process report you first need to make a copy of the standard
report (you can't make changes to the built-in reports).
Note: If you already have a modified report you want to use you can skip this section and
proceed with the section Adding the additional line item discount.
Making a copy of a standard report
- Run the Solatech Window Covering Software.
- From the Tasks menu click Manage Process Reports.
- Select the category Quotes.
- From the list of reports select Solatech Quote.
- Click the Modify button. When prompted to make a copy click Yes.
- Enter My Quote for the new name and click OK.
- When the Modify Report screen is displayed, click OK.
- You will now see the My Quote report listed.
Setting up the modified process to be used
Now that your modified report has been modified you need to configure the process reports setup so
that the new report is used instead of the existing report.
To setup your new report to be used
- If the Report Center is not already open, open it by clicking Manage Process Reports from the Tasks menu.
- Select the category Quotes.
- From the toolbar click Setup Reports.
- The list of quotes that are currently setup to be used are listed at the bottom of the Process Report and Label Setup screen.
- Remove the listed reports by clicking each one and click the X button.
- Click the Add button.
- From the list of available quote reports select My Quote.
- Click OK.
- On the Edit Process Report Setup screen click OK.
- Click Close.
Adding the additional line item discount
Now that the report is setup we can add the additional line item discount column.
To add the additional line item discount column
- If the Report Center is not already open, open it by clicking Manage Process Reports from the Tasks menu.
- Select the category Quotes.
- From the list of reports select My Quote.
- From the toolbar click Modify Report.
- Click the Line Items button.
- From the list of fields select the Description field.
- On the right side of the window, in the Data section, change the width from 4.7 to 3.7.
- Click the Add Field button on the toolbar. A new field called Balance for Terms will be added and selected.
- On the right side of the window, in the Heading section, change the heading to "Addl. Dis."
- In the Data section change the field to "ItemDiscountAmount" (without the quotes).
- Click the $% button and select the format category of Custom. Then type "Currency" as the actual format and click OK.
- Change the width to .9
- Click OK.
- Click the Line Items button again.
- In the list of fields, select the field ItemDiscountAmount and then click the up arrow button until the field is after the Description field.
- Click OK.
- Click OK again.
The above steps will add the additional discount for a single unit. If you want to add the total
additional discount for the line, based on the quantity, then follow these steps instead of the
above steps.
- If the Report Center is not already open, open it by clicking Manage Process Reports from the Tasks menu.
- Select the category Quotes.
- From the list of reports select My Quote.
- From the toolbar click Modify Report.
- Click the Line Items button.
- From the list of fields select the Description field.
- On the right side of the window, in the Data section, change the width from 4.7 to 3.7.
- Click the Add Field button on the toolbar. A new field called Balance for Terms will be added and selected.
- On the right side of the window, in the Heading section, change the heading to "Addl. Dis."
- In the Data section change the field to "= CDbl(ItemDiscountAmount) * CDbl(Quantity)" (without the quotes). Note - no spaces in ItemDiscountAmount.
- Click the $% button and select the format category of Custom. Then type "Currency" as the actual format and click OK.
- Change the width to .9
- Click OK.
- Click the Line Items button again.
- In the list of fields, select the field "= CDbl(ItemDiscountAmount) * CDbl(Quantity)" and then click the up arrow button until the field is after the Description field.
- Click OK.
- Click OK again.
Testing the report
To test the new report
- Create a new quote.
- Select a customer.
- Select any product, style and enter any required options. Do this until you get an item price.
- Click the Edit button next to the item price.
- In the additional discount field enter 10 and click OK.
- Add the line item to the quote.
- Save the quote.
- On the toolbar click Print.
- Place a check next to Quote.
- Click Preview.
- Verify the report now shows the information you entered along with the $10 for the additional discount.
REFERENCES
For more information, refer to the following knowledge base articles:
- How to display Retail Price & Discount on Output
APPLIES TO
- Solatech Window Covering Software 4.2