- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Calculated fields
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-05-2012 12:22 PM
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.
Re: Calculated fields
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-05-2012 02:21 PM
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.
Re: Calculated fields
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-05-2012 02:25 PM
version 4.40.0.3
Where can I find info on how to set up the udf & scripting?
Re: Calculated fields
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-05-2012 02:53 PM
There are links to two videos in this post:
Sr. Software Engineer
Sage 100 ERP


