Need additional DataRapt knowledge? We can help!
Part 1: My DataRapt
You have DataRapt installed and ready to go, but where can you find more information about the product?
The answer is easy. In the product!
There are a host of tools that can be used right from your DataRapt screens. Before we go any further, remember that there is a full, context sensitive help function available from every screen in all modules.
The reconciliations
Let us start with the DataRapt Reconciliations at a Glance. Here, you can see all ten of the reconciliation modules in summary form, providing Sub-ledger, General Ledger and Variance details. But, that’s not all…
You can see whether any variances are caused by unposted GL journals, when and how the reconciliation was last refreshed, and a breakdown by control account. You can be re-directed to the full reconciliation simply by selecting a hyperlink. Perhaps best of all, you can refresh the reconciliation right here.
From within the detailed reconciliations, you can check individual transactional variances and look at our What Next? ideas. These are an accumulation of our product knowledge base, and while not exhaustive, provide an idea of how the variance may have occurred, along with guidelines of how to fix it. You can even add your own reasons according to your individual knowledge base.
You are able to add notes to variances, launch SYSPRO programs to make corrections and move variances around the reconciliation. There is a write-up in the News section of our website, Streamlining DataRapt Reconciliations. To name but a few of these ideas, you are able to:
- Sort variances by their unsigned values. A column has been added to each of the details panes which displays the variance value without the minus sign, allowing you to sort on the unsigned value making it easier to find contra entries.
- Use the Work List tab. This tab allows you to do as you will with variances from other details tabs. Move variances for a single customer, or follow the catch-up depreciation of a fixed asset purchased with an earlier purchase date. Here are a few more ideas:
- Create one consolidated reconciliation including all lines from all tabs. This can be exported to Excel to manipulate as you see fit.
- Sort variances lines from multiple tabs to find possible contra variances.
- Separate variances that require further attention. Or no further attention!
- Use the extended toolbar. There is an extended toolbar in each of the details tabs that allows you to easily move data to and from contra groups and the ‘Work List’ tab. You can also view the ‘What Next?’ text, print, search and filter the data and apply various standard formatting functions.
A feature that I really enjoy is the multiple row select capability. As in any Windows applications, simply use the Shift or Control keys to select adjacent or separate rows, or select the whole lot with Ctrl-A. These can be added to a contra group, allowing you to move on to another tab that holds variances to be included in the group.
Likewise, multiple rows can be added and removed from the Work List tab.
And, perhaps the most important ‘Need to Know’ of them all…
DataRapt’s reconciliation products do not update SYSPRO tables. We extract data from SYSPRO into our own tables and populate reconciliation screens, groups and statuses from this data.
In the case of Prepayments, the links between prepayments and purchase orders or registered invoices are also stored in the DataRapt tables.
This means that, at any time, you can query the data, especially if you have historical data that can no longer be viewed in the reconciliations.
What of Supplier Prepayments?
The Supplier Prepayments module is a good workhorse, and the online help tells its story. It is worth mentioning that the Prepayments Query provides an overview of the whole system, and acts as a sub-ledger for the control account balances.
There is a Reference Guide for each version of SYSPRO. These are available to download from our Support Site.
We have a blog, Why You Should Consider Paying Suppliers In Advance, which we think provides useful information about the benefits of supplier prepayments.
Last, but not least – The General Ledger Reconciliation
The General Ledger Reconciliation is a completely user driven product. Here, you are able to reconcile single or predefined sets of General Ledger accounts in one place. Many actions are available. To list but a few, you can:
-
- Analyse the ledger transactions processed against the account or a set of accounts across a range of financial periods.
- Assign a user-defined status to a ledger transaction – perhaps to verify it or flag it for further investigation.
- You can apply SYSPRO’s ‘listview styles’ to user-defined statuses so that each status has its own distinct text colour, background colour and font for easy identification when you view the full reconciliation.
- Categorize data by accumulating GL transactions into user-defined groups. Including contra groups.
- Use eSignatures to ensure that unauthorised amendments cannot be made to your reconciliation.

