Hello SamW41,
We use Flexibility to do such things as:
1. Get a part number from an ACCESS database, enter it into the ItemMaster table, then construct the BOM for this item from information in an ACCESS table. We do this by using Sendkeys
to simulate a "phantom" user sending data to MACOLA using MACOLA's data entry screens. This way we do not circumvent any of the logic built into MACOLA by directly working with the tables.
2. Read data from an ACCESS database to select features and options for an order. This application also uses Sendkeys and a "phantom" user.
3. Check if an order requires an export license by reading data from an ACCESS database.
4. Trigger pop up windows to warn the user of special conditions that apply to that order.
As Don says, you can do almost anything if the screen has the proper events to trigger your code. Not all the events are exposed on every screen. We have used the applications on Progression and converted to ES with a little trouble, but none of our applications use the accounting modules.
Jerzy