How to format calculated fields in Generic Inquiries.
From your Generic Inquiry, select Customizations.
This will open up your Generic Inquiry “coding”.
Under the Tab, “Results Grid”, go to the column that say Schema Field.
You can pick any data element that is formatted in the fashion you want for your calculated field.
Then Save this work and view your Generic Inquiry again. You will now see the results of the requested formatting.
In a similar fashion, you can take a numeric field and assign an alpha column in the Schema Field column, you will see that the numeric values take on a more text looking view with many decimal places appearing.
Client Service Center
This website is owned by CS3 Technology. CS3 Technology is independent from Sage and is not authorized to make any statement, representation, or warranties or grant any license or permission on behalf of Sage regarding any product, service, or website content. Certain materials made available on or through this website are owned by Sage and cannot be used without the prior written permission of Sage.