Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Regular Contributor
mattatrdp
Posts: 69
Registered: 08-08-2011
0

Calculated fields

I was curious if in MAS we can insert fields that return a calculation based upon entries in other fields.  For example; we have a field (CBM), which is length x width x height * .0283.  Currently we run a report to calculate this field and then we import it.  If we had fields that could auto calculate it would remove a lot of repetitive work.

Sage Employee
jepritch
Posts: 233
Registered: 08-25-2009
0

Re: Calculated fields

Hi Matt,

 

Depending on what version you are on, you should be able to do this using custom office with a combination of UDF's (user-defined fields) and Scripting.

 

 

Regular Contributor
mattatrdp
Posts: 69
Registered: 08-08-2011
0

Re: Calculated fields

version 4.40.0.3

 

Where can I find info on how to set up the udf & scripting?

 

 

Moderator
Natasha
Posts: 180
Registered: 07-15-2009
0

Re: Calculated fields

There are links to two videos in this post:

 

http://community.sagemas.com/t5/Personalization-Customization/Video-of-Customizer-4-4-Training-by-S-...

Natasha Chang
Sr. Software Engineer
Sage 100 ERP