I have an outstanding invoice, it contains all the necessary information about the invoice, such as the customer name, billing info and so on. Each of the invoice holds the total balance after calculating the taxes and if there are certain discounts to be calculated.
By the end of the invoice I want to calculate the total balance of all the balances of the previous invoices, say I click report for Outstanding Invoice and there are a total of say 5 Outstanding invoice.
Here are the total balances of the five invoices:
Inv 1 21
Inv 2 31
Inv 3 12
Inv 4 321
Inv 5 341
I want the end of page of the report, at the bottom of the page of Inv 5 to give me total of 726, that is the total of Inv 1,2,3,4 and 5. Of course this is all displayed in the report, please can you tell me how to do this? Here are the scenarios as provided, the table that holds the information for the invoice, in the field of the table holds only Total, quantity, discount, the rest, the taxes, sub total and balance due are all extra fields in the report, with formulas designed to calculate what it needs to calculate from the total, quantity, and discount in the table itself. Any suggestions on solving this would be greatly appreciate it. If possible when you help me solve it, to make it as understandable as possible, because I am slow and I need detailed information for this to cross my mind. Thanks in advance and appreciate your assistance.
By the end of the invoice I want to calculate the total balance of all the balances of the previous invoices, say I click report for Outstanding Invoice and there are a total of say 5 Outstanding invoice.
Here are the total balances of the five invoices:
Inv 1 21
Inv 2 31
Inv 3 12
Inv 4 321
Inv 5 341
I want the end of page of the report, at the bottom of the page of Inv 5 to give me total of 726, that is the total of Inv 1,2,3,4 and 5. Of course this is all displayed in the report, please can you tell me how to do this? Here are the scenarios as provided, the table that holds the information for the invoice, in the field of the table holds only Total, quantity, discount, the rest, the taxes, sub total and balance due are all extra fields in the report, with formulas designed to calculate what it needs to calculate from the total, quantity, and discount in the table itself. Any suggestions on solving this would be greatly appreciate it. If possible when you help me solve it, to make it as understandable as possible, because I am slow and I need detailed information for this to cross my mind. Thanks in advance and appreciate your assistance.
