wzzly

Thanks for your reply. Still can't figure out how to display the tax. I got this: On the invoice I got a field: <<Bestellingnummer naar BesteldJoin::FACT_BTW_HUUR> In the database I got a field in the "orders" table called "FACT_BTW_HUUR" with: Case( Items::IT_KoopHuur = "HUUR" and Items::IT_BTWType ="A"; FACT_Bruto_BTWA) It's dutch..."HUUR" is dutch for "RENTAL" FACT_Bruto_BTWA has this function: Sum(Besteld BestNr naar Orders::IT_metBTW_A) + FACT_Bezorgkosten + FACT_BreukTotaalInclBTW Anyone able to help? thanks

Hi all, I have a problem I can't seem to solve on my own. I have products in my database that each have 1 of 3 different taxtypes (TAX_A (high tax), TAX_B(low tax), TAX_C(no tax)) and 1 of 3 different producttypes (RENTAL, BUY, PACKAGING) Now on my invoice I want the following TAXES to be displayed. RENTAL (=products that are TAX_A and RENTAL) BUY HIGH (=products that are TAX_A and BUY but not Items::IT_Type= "Drinks 19%" or Items::IT_Type= "Drinks 6%")) BUY LOW (=products that are TAX_B and BUY but not Items::IT_Type= "Drinks 19%" or Items::IT_Type= "Drinks 6%") DRINKS HIGH (=products that are TAX_A and Items::IT_Type= "Drinks 19%") DRINKS LOW (=products that are TAX_B and Items::IT_Type= "Drinks 6%")) PACKAGING (=products that are TAX_C and PACKAGING) So I have to make a some sums but only from the prices of the products that have those 2 conditions... I hope you guys know what I mean...