Skip to Main Content
Sage 200 UKI Ideas Portal

Allow different field types for analysis fields

There's often a requirement to store numbers or dates as analysis fields, but currently we can only store values as text, which leads to the risk of invalid data for the field's purpose being entered. It would be useful if each analysis field could be set to use date, date/time, integer, decimal or text so that the fields can actually be relied upon for calculations etc.

Idea Benefit Being able to actually use analysis fields to store meaningful information, which is often date or number formatted
How do you solve for this problem today? Accept that field contents have to be extracted and converted for reporting purposes and that there's a risk that users will key in non relevant data
Product Variant Sage 200 Professional
3 MERGED

Dates on Analysis Codes

Logged on behalf of Texo - Adding the ability to enter dates, possible via a dropdown with Analysis Codes
Monique Daly over 3 years ago in Analysis Codes 0 Idea Accepted - Gauging Support
9 MERGED

Format analysis fields as a date

When adding analysis fields it would be very useful to have them formatted as dates so that when exporting to Excel, Excel recognises them as a date rather than "General"
Dani Partridge 7 months ago in Analysis Codes 2 Idea Accepted - Gauging Support