Here is a Camtasia demo on a consistent look and feel solution for Mincom Ellipse Connectors that i put together last year for a client. The demo should good you a good idea of what the some of my previous suggestions could look like to a user.

Mincom Ellipse Connector Listing

I have been asked what sort of Connectors are contained in the above example. I'm not sure about posting and supporting the .XLA itself here but below is a list of a typical set of connectors for operations.

Finance

• 905 Journal Verify, Upload and upload multiple Journals. Use the 905 scripts to upload single journals, plus verify the contents of a journal. These verify tests include checking Mandatory fields for Work Orders and making sure the Work Order cost center matches the account used. This is extremely handy for large uploads.
• 905 Exchange Rate Download.
• 904 Transaction Modify Upload. This is useful for bulk changes to transactions. Such as Project or Work Order number.
• 950 Account Relationship Upload. Create and modify MSO950 relationships. Very useful especially if you manage your Balance Sheet and Op Statements by Relationships.
• 971 Budget Upload. Create and Modify budgets (automatically rounds to 0 d.p as well)
• 660 Bulk Project Upload and Close. Create, Modify and Close a list of Projects with the same template.

Maintenance

• 620 Bulk Work Order Upload, Print and Close. Create, Modify, Print and Close a lot of work orders in one go with the same template.

Stores

• 140 Requisition Upload. Create issue reqs. (easily modifyable to handle preqs if required)
• 220 Purchase Order Download, Upload and Cancel / Complete. Create, Retrieve, and cancel and complete POs in bulk. Very handy for PO clean ups to remove inappropriate liabilities in Invoice Pending etc.

HR

• 76T Exit Upload (ie: Terminations). Bulk Employee Terminations.
• 810 Employee Download and Upload. Create, modify and retrieve employees
• 832 Payroll Transaction Upload. Create payroll transactions. Extreemly handy for mass maintenance such as bonus payments.
• 830 Salary Increase Download and Upload. Retrieve the most recent salary rates, and upload new ones.
• 870 Position Upload. Modify positions.
• 891 Timesheet Upload. Create employee timesheet transactions.

System

• 020 Profile Upload and Delete. MSO020 security profile create, modify and delete. Can insert whole profile strings (250 characters) or easily modify one security position value across multiple profiles (global, program or signon)
• 020 Class Upload and Delete. Manage Class Method and Attribute settings across multiple profiles. This is very useful for say removing Employee.HomePhone, HomeAddress and Birthday access for all but HR profiles. Or specifying Requisition.Fetch to be "Own Reqs" for all profiles bar Supply.