Sales Order Analysis Code Field Type

SUGGESTED

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

  • 0
    SUGGESTED

    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.