Allow us to add code somewhere that would check data entered by the user. If it didn't pass our custom validation script we could stop the Save action. For example, I don't want to allow a user to choose the Create Invoice checkbox if a certain Item is chosen. The validation could use information from any field on the screen, or even look into other views or tables. Using the COMAPI scripting would be a nice way to go. If the validation failed a custom message would be programmed to display to the user.
Also, allow a script to run after a Post or Save as well. For instance, after the OE Order is posted you may want to update a customer's Optional Field value, or write to an external system via sql.
Sage CRM does this very nicely using Validation Scripts and Table Level Scripts.
by: Stacy D. | over a year ago | General Enhancements
Comments
Sage X3 does this as well.
For Accpac it would be a massive change in the background - dont hold your breath...
Don't believe this is too difficult; since all calls presently go through a standard API....it would just be a case of moving the callout's from the AccpacDatasource to somewhere either in the COM layer before the the views are invoked or at the entry points to the views.
I really feel this is something major that is missing in Accpac. 99% of our installs have some sort of integration to external systems. With the increasing need to integrate to other platforms, this piece always presents the biggest challenge. If you want Accpac to have true bidirectionally integration, these features are needed.
11 November 2021