disabled_Luna.media

How to sum only certain fields in a portal

Discussion created by disabled_Luna.media on May 14, 2013
Latest reply on May 15, 2013 by disabled_Luna.media

Hi there,

 

I am quite new to FM 12 and modify the (german) "Invoice" demo that comes with FM 12. Hwat I like to do is to sum up some but not all of the invoice items (shown in aportal of an invoice) to give a discount an these. What I have are products than can be added to an invoice. One field in the product table indicates if that item is discountable or not. In the invoice I want to sum these discountable proucts and give the discount on these products - and then sum all products and add VAT on the (partly discounted) total.

 

I am quite sure that there might be different ways to solve this problem - so please feel fre to indicate any.

 

Thank you in advance, Luna

Outcomes