We sell to many countries and each country has items it allows and not allows. I'd like to have the option to call out to a sp when a Entry is saved that checks a table to see if the item is allowed to be sold to Canada for instance. All Sage has to do is call a defined stored procedure and if it returns failure then not allow saving (or maybe give them a save anyway message). If the sp doesn't exist then skip. If it errors out then skip. The return parameters should also include a message.
This should probably occur after saving to the db to allow for easy checking. If it fails then run the regular delete process if they don't want to save anyway.
This would add some great flexibility to the product.
by: John H. | over a year ago | 6 - General Enhancements
Comments
This is also needed with regard to US States. We sell chemicals that must be registered per state, and we need to prevent shipments to states in which the product is not registered. Our reseller created a customization that provides this functionality.