Calculated Rate

This feature allows you to alter the rate that is used in the calculation of the amount in a detail line of an order.

QuickBooks calculates the extended amount in the detail line as rate X quantity = amount. You cannot change this in QuickBooks itself.

If you select Multiply in the wizard then CCRQInvoice can change the formula to be custom field X rate X quantity = amount, where custom field is a “custom field” that you have added to the order form.

With this feature you can alter the rate by multiplying the original rate by the value in a custom field. The original rate is the rate that you originally entered when you added the item.

To make this work we have to replace the rate field in the calculation with the product of the original rate and the custom field. The program will save the rate that you started with in a field that we will call the original rate.

The program needs two custom fields in your item list.

•      Multiply By: This is the custom field that you will use in the calculation.

•      Original Rate: The program will store the rate that you entered originally for the item in this field.