ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> RTM Reports & Editing >> Arithmatic Operation in RTM
http://www.istechforum.com/YaBB.pl?num=1300453329

Message started by Vman on 03/18/11 at 06:02:09

Title: Arithmatic Operation in RTM
Post by Vman on 03/18/11 at 06:02:09

Is there any way to apply an arithmatic operation (i.e. mulitiplication) to a numeric data field in an RTM?

Title: Re: Arithmatic Operation in RTM
Post by Lynn_Pantic on 03/18/11 at 10:31:01

Unfortunately, no.

Title: Re: Arithmatic Operation in RTM
Post by Vman on 03/18/11 at 14:24:09

Bummer, boss wants me to apply the discount to the unit price on invoices and such. :(

Title: Re: Arithmatic Operation in RTM
Post by Lynn_Pantic on 03/19/11 at 07:57:02

Actually, that one you can do by manipulating fields that are already there. There is a default in SD-M for "Display Discounts on Forms". If it is N then the unit price field that prints on the form is a calculated field with the discount applied. If that is all you want then just change the default. If you want to show the original unit price, Discount and Discounted unit price and extension then set the default to N so the discounted price gets calculated and add the fields to the forrm for the unit price from the BKARINVL table (undiscounted) and move the field for the discount itself out of the region box that is controlled by the default (delete the box and put the discount field back in the RTM

Title: Re: Arithmatic Operation in RTM
Post by Vman on 03/21/11 at 06:18:02

Thanks, changing the field to N seems to do what we want.