If I apply a discount to a single item, the rate shown is the discounted rate. Ideally, it would be great to be able to show the regular rate in one column, the discount amount/percent in another column, and then the total for that line item. Is there a way to do this now? If so, I sure haven't figured out how! Right now, I'm just making separate line items for discounts, which works but is a workaround nonetheless.

+1

Angie, did you ever figure this out? I'm lost on the same thing. i would like my clients to see the break they are getting

Karly

I would like to do this also. I've been fooling around with a new invoice, and I've managed to create a column that shows the discount percentage, and the dollar amount of the discount, but, try as I might, I can't seem to get a field for the cost before the discount to work.

Okay, I got mine to work, sort of. I added a column to my invoice table that contains both dynamic text items Slip Total and Discount Total seperated by a plus sign.

Then check the box on the lower right that says "evaluate text as a mathmatical expresssion." You'll also probably want to set the Formatter menu to "Currency."

What you get is the total price before thge discount. The downside is that the text is not formatted to match the rest of the text in the invoice -- so it's a little ugly. And I can't figure out how to format it.

This is an issue that has come up on a another thread in the forum. Link.

Anyone else make any headway?

Thanks to Oscar and Roger Wilco, we have a workaround for this issue. And I have a script that you can use.

See this thread.