Hi,
In Sage 50 Accounts Professional, is there any way I can change the field type of an Analysis Code on Sales Orders from free text to numeric/integer. Alternatively - can I make a predefined list of allowed values?
Thanks
Hi,
In Sage 50 Accounts Professional, is there any way I can change the field type of an Analysis Code on Sales Orders from free text to numeric/integer. Alternatively - can I make a predefined list of allowed values?
Thanks
Hi Sharon,
I'm afraid you cannot set pre-defined text for these analysis fields. They are free text alphanumeric fields and cannot be changed.
However, you can set a report to pick up this analysis field and treat it like a number by using the StringToInteger.
Please click here to view our help guide on various functions you can use, including StringToInteger.
Please note however, that you would need to ensure that a number is entered into this field for all records you run the reports for, otherwise you will receive an error message when trying to run the report.
I hope this helps.
*Community Hub is the new name for Sage City