Difference

There are times when you want QuickBooks to calculate the quantity as the difference between two fields. The typical example is when you are working with weights and want to charge the difference between the starting and final weights. The gross weight would be the total weight of the material and the vessel holding it. The tare weight would be the weight of the empty vessel. You want to charge the customer for (gross – tare) X rate = amount. QuickBooks can’t perform this calculation for you.

To support this with CCRQInvoice we need to add two custom fields, one for the starting (gross weight) value and one for the ending (tare weight) value. In the setup wizard you will select the Difference option under “Calculated Quantity” and set up the two fields

You need to modify your invoice form to show the following columns:

•      Add the quantity column (screen and print).

•      Add the custom gross field (screen and print).

•      Add the custom tare field (screen and print).

•      Add the rate field (screen and print).

•      Have the item field be shown before the custom fields, because when you select an item the values in the custom fields will be cleared.

Create your invoice – enter a value of 1 in the quantity field (it doesn’t matter what you enter here, it will be overridden).

When you process the invoice in CCRQInvoice the application will:

•      Calculate the difference between the start (gross) and end (tare) fields and place that value in the quantity field.

On the screen you will see the following: