The way that the optional fields are currently organized (in seperate tables ending with an "O") makes them almost useless for reporting purposes. The only way to report on multiple optional fields is through subreports, which means that the average end user can't use them at all. Other ERP softwares (Great Plains is one) add the user-defined fields directly to the tables for whatever record type it is - Accpac needs to do the same. I've never understood why it wasn't done this way in the first place?
by: Dane H. | over a year ago | General Enhancements
Comments
Easily overcome by creating SQL views that flatten the Optional field table (i.e. joins them to their respective parent table). Keeping the custom fields in separate tables is actually a very clean way to handle it, and ensures upgrades are easier to manage.
I do not recommend any database level changes (e.g. adding views, indexes, triggers) to the Accpac database by the users. Even if it has to be done, average users will not be able to do so. They need to have SQL development capabilities or need to seek help of their solution provider.
Optional Fields
I add these to show there are more votes for enhanced Optional Fields than recorded here:
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/2637
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/1877
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/236
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/392
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/2266
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/1614
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/1739
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/1237
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/1828
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/1445
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/2609
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/606
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/2413
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/606
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/627
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/1156
https://www11.v1ideas.com/Sage300ERP/Accpac/Idea/Detail/2029