5 Replies Latest reply on Jun 14, 2014 8:37 AM by beverly

# Invoice total summary report questions

So I have a different business situation then most. I have a precious metal company and we routinely buy product and sell product to the same person. The product we buy is listed as a negative quanity which offsets the products we purchase leaving either an amount we pay or an amount we invoice. All this is done on the same invoice which presents part of my problem.

Example:

We sell a product for \$600 (which has a cost of \$300 and a \$300 profit). We buy a product for \$200 (which has a sell price of \$450.00 and a profit of \$250) and the balance shows we invoice \$400.00.

How do I prepare summary reports to show the profit and another report that shows the total purchased and total sold based on the records shown?

Currently all my reports end of showing only the \$400 invoiced which does not reflect the true activity with each customer.

Your help would be hugely appreciated,

Michael

• ###### 1. Re: Invoice total summary report questions

Do you have a separate field not shown on the invoice that identifies the profit?  Or is it a calculation?  You would then just use this Profit field to make a summary.  If you want to do summaries of only positive amounts, create a field that equals Amount only if it is positive such as:  If ( Amount > 0 ; Amount ).  That way you can search or do calculations only on positives.  Same could be done for negatives if you had a need to summarize what you purchase.

• ###### 2. Re: Invoice total summary report questions

Thank you. Yes I have a separate cost field. I think the amount field will work. Would you recommend two? One for positive and one for negative. I assume it would be in the invoice line item table and then I can run a summary from each.

Can you describe more in detail the best way to setup this calculation as I am drawing a large blank. I understand it but I can't grasp the calc at the moment.

• ###### 3. Re: Invoice total summary report questions

Create a calculation field called something like "Amount Credit" and the formula for it would be "If ( Amount > 0 ; Amount)".  Then create a calculation field called "Amount Debit" with the formula of "If ( Amount < 0 ; Amount )".  Then you can create a summary field for both of these fields so that you can summarize the values in them at the end of a report.

• ###### 4. Re: Invoice total summary report questions

Much appreciated

Thank you

• ###### 5. Re: Invoice total summary report questions

If you enter positive amounts in the column then totals are easy. Calc +/- line total based on credit/debit (a field) for final total. You can then summarize each of these to get subsummary by sort (try getsummary() function).

-- sent from my iPhone4 --

Beverly Voth

--