Welcome, Guest. Please Login.
05/14/24 at 20:14:19
News:
Home Help Search Login


Pages: 1
Send Topic Print
Arithmatic Operation in RTM (Read 1069 times)
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Arithmatic Operation in RTM
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?
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Arithmatic Operation in RTM
Reply #1 - 03/18/11 at 10:31:01
 
Unfortunately, no.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: Arithmatic Operation in RTM
Reply #2 - 03/18/11 at 14:24:09
 
Bummer, boss wants me to apply the discount to the unit price on invoices and such. Sad
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Arithmatic Operation in RTM
Reply #3 - 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
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Vman
Senior Member
****


If it ain't broke,
don't fix it

Posts: 460
Gender: male
Re: Arithmatic Operation in RTM
Reply #4 - 03/21/11 at 06:18:02
 
Thanks,  changing the field to N seems to do what we want.
Back to top
 
 

EVO-ERP 2022.2
Build 4/22/22
Actican Zen V14 SP2 Workgroup
Win7 64-bit and Win10 Pro
WWW   IP Logged
Pages: 1
Send Topic Print