Hi DebWen,

Since it looks like you are using Sage 50 CA, I am going to move your post to that Support Group so that other users of this software will see it and can offer their thoughts and insight.

Thanks,

Derek

The ability to sum and group like items is not part of the Sage 50 invoice forms.

If you use Recurring Transactions, and save the transaction as the same recurring transaction name, the details from the previous invoice will show in the invoice body.  This could save some time in typing out the verbiage about starting and ending quantities each time.

If you were to enter:

-10000 in the quantity field on one line, and

+12000 in the quantity field on the next line.

The net dollar and quantity amount will be correct, but there is no way to show a subtotal quantity and dollar amount.  If you used a recurring transaction it might save time to copy the ending amount up a row and change to a minus value.

This sort of thing used to be possible with the Crystal Reports type invoices from versions of Sage 50 Canadian before 2014.3, since the invoice form could have some programming built into it.

The current Sage 50 type forms can print some invoice data on the page, and that's about it.

------------------------------------------------------------------------------------------------------

If you use the above method, your sales reports will show something like:

-10000   $-5,000.00

12000    $6,000.00

-12000   $-6,000.00

14000    $7,000.00

And you'll be pointing out to your customer how much the copier has been costing since the beginning of time, which may also be not what you want, and the invoice will look messy.