Providing insight to your business
Product News
DataRapt Announces Release of GL Reconciliation
FREE to customers licensed for the Reconciliation Utilities bundle
The GL Reconciliation enables you to view and analyze transactions against a single GL account or a group of GL accounts, across a range of periods.
In addition to individual GL accounts, the program allows you to select predefined groups of GL accounts. This is achieved by creating GL Reconciliation Sets, i.e. a group of GL accounts. Once created, a set is treated as a single item in the reconciliation, allowing you to group, contra and classify transactions across the GL accounts included in the set.
You can assign status codes to transaction details and, using standard SYSPRO listview styles, specify the font, background color and text color to be applied to each status code. Transactions can be linked to supporting documentation and approval authorities either electronically or by reference to manual records. Reconciliation functions can be controlled with Electronic Signatures.
The Reconciliation Groups function enables you to classify and categorize data by accumulating detail transactions into user-defined groups. In addition, you can define a reconciliation group as a contra group, select to exclude a group’s transactions from the reconciliation, and define a default status code against the group.
FREE to customers licensed for the Reconciliation Utilities bundle
The GL Reconciliation enables you to view and analyze transactions against a single GL account or a group of GL accounts, across a range of periods.
In addition to individual GL accounts, the program allows you to select predefined groups of GL accounts. This is achieved by creating GL Reconciliation Sets, i.e. a group of GL accounts. Once created, a set is treated as a single item in the reconciliation, allowing you to group, contra and classify transactions across the GL accounts included in the set.
You can assign status codes to transaction details and, using standard SYSPRO listview styles, specify the font, background color and text color to be applied to each status code. Transactions can be linked to supporting documentation and approval authorities either electronically or by reference to manual records. Reconciliation functions can be controlled with Electronic Signatures.
The Reconciliation Groups function enables you to classify and categorize data by accumulating detail transactions into user-defined groups. In addition, you can define a reconciliation group as a contra group, select to exclude a group’s transactions from the reconciliation, and define a default status code against the group.
AP Prepayments
New product enables suppliers to be prepaid before goods or services are received
DataRapt is pleased to announce the release of the AP Prepayments system.
AP Prepayments enables you to record prepayments to suppliers for goods or services before they are received and regardless of whether the supplier has provided an invoice. The AP Prepayments system can benefit any company that pays for goods and services upfront.
New product enables suppliers to be prepaid before goods or services are received
DataRapt is pleased to announce the release of the AP Prepayments system.
AP Prepayments enables you to record prepayments to suppliers for goods or services before they are received and regardless of whether the supplier has provided an invoice. The AP Prepayments system can benefit any company that pays for goods and services upfront.
Reconciliations for SYSPRO 6.1
Full suite of reconciliations released for SYSPRO 6.1.
We are pleased to announce that the full suite of reconciliations is now available for SYSPRO 6.1. New activation keys are not required when upgrading.
Full suite of reconciliations released for SYSPRO 6.1.
We are pleased to announce that the full suite of reconciliations is now available for SYSPRO 6.1. New activation keys are not required when upgrading.
New Reconciliations
DataRapt is pleased to announce that three new reconciliations are now on general release and available for download from the Support Site. These reconciliations are included in the standard DataRapt bundle.
Goods in Transit Reconciliation
A reconciliation utility for Goods in Transit is now available, which identifies and details differences for a selected period between the Goods in Transit sub-module and the General Ledger control accounts.
Dispatch Notes Reconciliation
A reconciliation utility for Dispatch Notes is now available, which identifies and details differences for a selected period between the Dispatch Notes sub-module and the General Ledger control accounts.
Work in Progress Inspection Reconciliation
A reconciliation utility for Work in Progress Inspection is now available, which identifies and details differences for a selected period between the WIP Inspection sub-module and the General Ledger control accounts.
DataRapt is pleased to announce that three new reconciliations are now on general release and available for download from the Support Site. These reconciliations are included in the standard DataRapt bundle.
Goods in Transit Reconciliation
A reconciliation utility for Goods in Transit is now available, which identifies and details differences for a selected period between the Goods in Transit sub-module and the General Ledger control accounts.
Dispatch Notes Reconciliation
A reconciliation utility for Dispatch Notes is now available, which identifies and details differences for a selected period between the Dispatch Notes sub-module and the General Ledger control accounts.
Work in Progress Inspection Reconciliation
A reconciliation utility for Work in Progress Inspection is now available, which identifies and details differences for a selected period between the WIP Inspection sub-module and the General Ledger control accounts.
Exclude Control Accounts
Exclude Control Accounts from Reconciliation Details.
Sometimes the responsibility for reconciling individual control accounts lies with different operators or control accounts are no longer being used, yet all control accounts for a module are automatically included in each of the reconciliations.
To allow individual control accounts to be excluded from the reconciliations, the Exclude G/L Codes function has been added to each of the reconciliations. When selecting this pushbutton, all the control accounts currently being included are displayed and any number of them can be excluded.
These exclusions are stored per operator and, once exclusions have been applied, can be viewed for the current operator on the Summary pane.
Exclude Control Accounts from Reconciliation Details.
Sometimes the responsibility for reconciling individual control accounts lies with different operators or control accounts are no longer being used, yet all control accounts for a module are automatically included in each of the reconciliations.
To allow individual control accounts to be excluded from the reconciliations, the Exclude G/L Codes function has been added to each of the reconciliations. When selecting this pushbutton, all the control accounts currently being included are displayed and any number of them can be excluded.
These exclusions are stored per operator and, once exclusions have been applied, can be viewed for the current operator on the Summary pane.
Exclude Unposted Entries
Exclude Details of Journals, Distribution Reports and G/L Group Entries that are not yet posted.
If journal reports or distribution reports have not been printed or general ledger group entries have not been posted to the General Ledger, these are shown on the individual tabs as being unprinted or unposted.
However, in most cases, this information will find its way to the General Ledger and therefore, does not require further investigation. To allow for the assumption that this information will end up in the General Ledger in due course, the preference Exclude details of journal, distribution and G/L group entries not yet posted has been added to each of the reconciliations. If this preference is selected, the value of all unprinted/unposted transactions is shown on the Variance Details pane in a total shown as Not posted to control accounts. The detail is then excluded from the individual tabs.
In addition, we have provided an additional customized pane (PANE_DATARAPT_GLPROJ.txt ) for use with SYSPRO’s Executive View. This shows the general ledger balances projected to include the value of any unprinted journal or distribution reports or general ledger group entries that have not been posted to the General Ledger thus allowing for the assumption that this information will ultimately be posted to the General Ledger.
Exclude Details of Journals, Distribution Reports and G/L Group Entries that are not yet posted.
If journal reports or distribution reports have not been printed or general ledger group entries have not been posted to the General Ledger, these are shown on the individual tabs as being unprinted or unposted.
However, in most cases, this information will find its way to the General Ledger and therefore, does not require further investigation. To allow for the assumption that this information will end up in the General Ledger in due course, the preference Exclude details of journal, distribution and G/L group entries not yet posted has been added to each of the reconciliations. If this preference is selected, the value of all unprinted/unposted transactions is shown on the Variance Details pane in a total shown as Not posted to control accounts. The detail is then excluded from the individual tabs.
In addition, we have provided an additional customized pane (PANE_DATARAPT_GLPROJ.txt ) for use with SYSPRO’s Executive View. This shows the general ledger balances projected to include the value of any unprinted journal or distribution reports or general ledger group entries that have not been posted to the General Ledger thus allowing for the assumption that this information will ultimately be posted to the General Ledger.
Archive
Accumulate Variances
Accumulate variances to a single line when less than a defined value.
Sometimes a large number of very low value variances (e.g. rounding issues) that are unlikely to be investigated further are shown on the reconciliation tabs.
In order to de-clutter the tabs, the preference Accumulate variances to a single line when less than has been added to all the reconciliations. When a value is entered against this preference, variances with a value less than that specified are accumulated into a single line on each of the applicable tabs and are identified by the heading '-ACCUM VARS-'.
This facility could also be used to prioritize the investigation of variances. In other words, you could set this preference to different values enabling you to sort out the largest variances first and then work down to the smaller ones.
Top of page
FIFO Variances
Show FIFO Costing Variances Separately in Inventory Reconciliation.
The Inventory Reconciliation has been enhanced to show FIFO costing variances separately from other variances on the 'Movement Summary' tab. These variances, which reflect the difference between stock values based on warehouse costs and stock values based on FIFO buckets, are accumulated by warehouse and shown against a stock code of '-FIFO VARS-'.
Top of page
Contra across Accounts
Contra Entries across Multiple Control Accounts.
Previously when adding individual variance transactions to a contra group, each of the transactions had to be associated with the same control account. This functionality has now been extended to allow contra entries to be identified across multiple control accounts.
If you then go on to only show the details of a single control account (by expanding the treeview in the Summary pane and selecting Show details against a single control account), any variance transaction that is part of a contra group where the other side of the entry is not associated with the control account now being viewed is shown in italics.
Top of page
Assets Reconciliation
A reconciliation utility for Assets is now available.
DataRapt is pleased to announce that the Assets Control Account Reconciliation program is now on general release (build 34) and available for download from the Support Site.
This utility allows you to identify any variances between the Assets Register Module and Assets G/L Control Accounts and, as with our other reconciliations, provides insight into what may have caused the variances and how to resolve them.
It also includes a Movement Schedule that, when viewed for a previous period, lists each asset in the correct Branch / Cost Center / Group (depending on your level of G/L integration) as at the period being viewed.
Top of page
Executive View
See at a glance whether any variances have been identified across any of the sub-ledger reconciliations.
For the current period, it is possible to see at a glance if any of your sub-ledgers are out of balance to your General Ledger from SYSPRO’s Executive View. This feature is particularly useful if you have run the sub-ledger reconciliations in silent mode and just want to see if any variances were identified. To have the Executive View functionality you must be running SYSPRO Version 6.0 SP2.
Top of page
Custom ‘What Next’ Notes
Capture your own ‘What Next’ notes.
While the ‘What Next’ functionality that helps you to identify the cause of a variance has been compiled to cover most scenarios, it is possible that you may encounter scenarios that are unique to your own business. Therefore, you can now compile and maintain your own custom notes against individual ‘What Next’ text.
Top of page
Silent Mode
Schedule your sub-ledger reconciliations to run after hours.
The sub-ledger reconciliation utilities can be scheduled to refresh the current period’s variance data outside of working hours when the data files are not being used by valid SYSPRO processes. The reconciliation files are updated with current data, allowing accounting staff to view any variances up to and including the previous day's transactions. This facility takes advantage of SYSPRO’s ‘silent’ command line switch that suppresses the user interface of programs designed to be run in this manner.
Top of page
Notes per Transaction
You can now add notes at transaction variance level.
In addition to the existing function to add notes at period level, you can now add notes at transaction level. This is particularly useful where the variance has been resolved in a different period.
Top of page
Contra Entries
If you have ever tried to mentally keep track of variances that you know are contra entries then we have the solution for you.
You can now add individual variance transactions to a contra group. Once you have created a contra group, each transaction that has been added to a contra group is clearly identified by a strikethrough line in the listviews. Alternatively, if you would rather not see the contra entries at all, there is a preference that allows you to exclude the transactions that you have flagged as contras from the listviews.
Top of page
Work in Progress
A reconciliation utility for Work in Progress is now available.
The Work in Progress Control Account Reconciliation utility allows you to identify differences between the Work in Progress module and the default Work in Progress control accounts as well as the control accounts held on the job master.
Top of page
 |
Accumulate Variances |
|
FIFO Variances |
|
Contra across Accounts |
|
Assets Reconciliation |
|
Executive View |
|
Custom ‘What Next’ Notes |
|
Silent Mode |
|
Notes per Transaction |
|
Contra Entries |
|
Work in Progress |
Accumulate Variances
Accumulate variances to a single line when less than a defined value.
Sometimes a large number of very low value variances (e.g. rounding issues) that are unlikely to be investigated further are shown on the reconciliation tabs.
In order to de-clutter the tabs, the preference Accumulate variances to a single line when less than has been added to all the reconciliations. When a value is entered against this preference, variances with a value less than that specified are accumulated into a single line on each of the applicable tabs and are identified by the heading '-ACCUM VARS-'.
This facility could also be used to prioritize the investigation of variances. In other words, you could set this preference to different values enabling you to sort out the largest variances first and then work down to the smaller ones.
Top of page
FIFO Variances
Show FIFO Costing Variances Separately in Inventory Reconciliation.
The Inventory Reconciliation has been enhanced to show FIFO costing variances separately from other variances on the 'Movement Summary' tab. These variances, which reflect the difference between stock values based on warehouse costs and stock values based on FIFO buckets, are accumulated by warehouse and shown against a stock code of '-FIFO VARS-'.
Top of page
Contra across Accounts
Contra Entries across Multiple Control Accounts.
Previously when adding individual variance transactions to a contra group, each of the transactions had to be associated with the same control account. This functionality has now been extended to allow contra entries to be identified across multiple control accounts.
If you then go on to only show the details of a single control account (by expanding the treeview in the Summary pane and selecting Show details against a single control account), any variance transaction that is part of a contra group where the other side of the entry is not associated with the control account now being viewed is shown in italics.
Top of page
Assets Reconciliation
A reconciliation utility for Assets is now available.
DataRapt is pleased to announce that the Assets Control Account Reconciliation program is now on general release (build 34) and available for download from the Support Site.
This utility allows you to identify any variances between the Assets Register Module and Assets G/L Control Accounts and, as with our other reconciliations, provides insight into what may have caused the variances and how to resolve them.
It also includes a Movement Schedule that, when viewed for a previous period, lists each asset in the correct Branch / Cost Center / Group (depending on your level of G/L integration) as at the period being viewed.
Top of page
Executive View
See at a glance whether any variances have been identified across any of the sub-ledger reconciliations.
For the current period, it is possible to see at a glance if any of your sub-ledgers are out of balance to your General Ledger from SYSPRO’s Executive View. This feature is particularly useful if you have run the sub-ledger reconciliations in silent mode and just want to see if any variances were identified. To have the Executive View functionality you must be running SYSPRO Version 6.0 SP2.
Top of pageCustom ‘What Next’ Notes
Capture your own ‘What Next’ notes.
While the ‘What Next’ functionality that helps you to identify the cause of a variance has been compiled to cover most scenarios, it is possible that you may encounter scenarios that are unique to your own business. Therefore, you can now compile and maintain your own custom notes against individual ‘What Next’ text.
Top of page
Silent Mode
Schedule your sub-ledger reconciliations to run after hours.
The sub-ledger reconciliation utilities can be scheduled to refresh the current period’s variance data outside of working hours when the data files are not being used by valid SYSPRO processes. The reconciliation files are updated with current data, allowing accounting staff to view any variances up to and including the previous day's transactions. This facility takes advantage of SYSPRO’s ‘silent’ command line switch that suppresses the user interface of programs designed to be run in this manner.
Top of page
Notes per Transaction
You can now add notes at transaction variance level.
In addition to the existing function to add notes at period level, you can now add notes at transaction level. This is particularly useful where the variance has been resolved in a different period.
Top of page
Contra Entries
If you have ever tried to mentally keep track of variances that you know are contra entries then we have the solution for you.
You can now add individual variance transactions to a contra group. Once you have created a contra group, each transaction that has been added to a contra group is clearly identified by a strikethrough line in the listviews. Alternatively, if you would rather not see the contra entries at all, there is a preference that allows you to exclude the transactions that you have flagged as contras from the listviews.
Top of page
Work in Progress
A reconciliation utility for Work in Progress is now available.
The Work in Progress Control Account Reconciliation utility allows you to identify differences between the Work in Progress module and the default Work in Progress control accounts as well as the control accounts held on the job master.
Top of page
