trisun123 wrote:

apmuthu wrote:

Copy over the report twice and edit the sql statements with the appropriate filter in each and rename them with some report number that is unique and put it into the company/#/reporting folder.

thank you for your reply dear apmuthu

i will try to do that

and by the way, where exactly we could differentiate between Taxed and non-Taxed?
is it on :
1. item, or
2. customer

sorry if i ask again

thank you in advance

It's in stock master table, there is a column named tax_type_id.

thank you dear barbarian

i'll try it

apmuthu wrote:

Copy over the report twice and edit the sql statements with the appropriate filter in each and rename them with some report number that is unique and put it into the company/#/reporting folder.

thank you for your reply dear apmuthu

i will try to do that

and by the way, where exactly we could differentiate between Taxed and non-Taxed?
is it on :
1. item, or
2. customer

sorry if i ask again

thank you in advance

It's in stock master table, there is a column named tax_type_id.

If you see the SQL statement possibly wrapped in a function, you will find the tables involved. In one of the tables you can identify the invoice number and from there you can look at the tax relation and then trace the field that has an incidence of tax and those that do not - it will be a flag field or a tax type definition. Use that in the where clause and you're done. The field will generally have to be linked to a item tax table that matches the customer and hence the item-customer-tax-taxtype combine.

thank you very much apmuthu
i will try it

Copy over the report twice and edit the sql statements with the appropriate filter in each and rename them with some report number that is unique and put it into the company/#/reporting folder.

thank you for your reply dear apmuthu

i will try to do that

and by the way, where exactly we could differentiate between Taxed and non-Taxed?
is it on :
1. item, or
2. customer

sorry if i ask again

thank you in advance

first of all, i am sorry if this topic already asked before.
Because i'm  not sure the appropriate keyword on how to search for this topic
also sorry for bad English, since it's not my native language

What i am trying to do is to "split" the Customer Balances Report into two kind :
1. The transactions with Tax, and
2. The transactions without Tax (non-Tax)

what should i modify on PHP or SQL to perform this?

Thank you in advance