Meditech Scripting Routines

GL Money Batch

Allows you to effortlessly input data into Meditech Batch routines. You can use external data sources or data you've downloaded from Meditech and revised.
Many adjusting journal entries are modifications of existing data. They may also be external data that you need to get into your Meditech system. This product will make the manual keypunching of this new data unnecessary.

There are three easy steps to using our GL Money Batch routine:

  1. 1. Import the data into an Excel spreadsheet. You can use external data sources or data you've downloaded from Meditech.

  2. 2. Prepare the data by placing GL accounts in column A and GL amounts in column B.

  3. 3. Then with just a click of a button your journal entry is entered for you in a Meditech GL Money Batch.

GL Batch

You modify your Compensation and Supplies budgets on an ongoing basis. Our utilities allow you to automate this process saving you time and money.
You may need to modify your compensation and supplies budgets as the year progresses. Many of these edits and updates are of a repetitive nature. For example, transferring budgets from one cost center to another. This product will make that chore much easier.

Payroll Budget

Major edits and modifications can be time consuming. We can streamline and enhance this process. This tool can assist you in coordinating your Payroll Budget with your GL Budget. You may need to modify your compensation and supplies budgets as the year progresses. Many of these edits and updates are of a repetitive nature. For example, transferring budgets from one cost center to another. This product will make that chore much easier.

There are three easy steps for using our utility to edit your Payroll budgets:

1. Download the applicable budgets that require modification.

2. Make changes to the budgets using our Excel approach.

3. Once you are satisfied with the changes, a click of a button uploads the revised Meditech Payroll Budget.

ESS/B&F External Data Fields

You can import external data into your Executive Support System (ESS) and your Budgeting & Forecasting Module (B&F). This dramatically improves the response time (loading views and worksheets) for both applications. Need to bring external data into your ESS and B&F Modules? Would you like to speed up these modules by supplying just the data you need. Our combination of techniques and Magic code make this task quick and easy. There are three easy steps to using our External Data Fields product:

1. Prepare the data you want to import. You can use external data sources or data you've downloaded and revised from your Meditech System.

2. Run the provided NPR routine to upload the data and have it transferred to ESS.

3. Once you retrieve the data in ESS, you are free to use it in your views and worksheets.

Excel Utilities

Map Utility

Reorganizes and groups data, based on a map you create, or download from your Meditech system. Does this situation sound familiar? You have detail data that you need to summarize by a certain GL component such as director or supervisor, but don't know how to do it. This product is designed to apply a map you provide so that you can subtotal the data by the desired roll-up.

1. There are three easy steps for using our Map utility:

2. Prepare the Excel worksheet that will contain your detail data.

3. Download the desired map from your MIS dictionary.

Run our Map utility to get the data from the map and place it into the spreadsheet that contains the detail data. Now you can subtotal the data by your desired roll-up value.

Merge Utility

Compares two spreadsheet files, and merges the data from one to the other, based on your merge criteria.

Self-Paced Training (S.P.T.)

Excel Training with a Meditech Slant (107 minutes) 

Unleashes the power of Excel and allows you to manipulate your Meditech data to suit your needs. We cover downloading Meditech data and some of the more powerful Excel data manipulation features that put you in control of your data. This training is catered to the Meditech environment. It will teach you everything you need to know to do anything you want to do with your financial data.

Meditech Scripting using Excel - Introductory Level (68 minutes)

Teaches you how to write your own scripting programs using just Excel and the Meditech Remote Workstation.

Scripting Update for the Meditech NUI (MRW4x) (64 minutes)

In combination with our "Meditech Scripting using Excel - Introductory Level" training course, this training course update will enable you to write scripting programs for the Meditech NUI (MRW4x) remote workstation, using just Microsoft Excel.