Providing insight to your business
Product News
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.
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.
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.
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-'.
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-'.
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.
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.
Archive
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
 |
Assets Reconciliation |
|
Executive View |
|
Custom ‘What Next’ Notes |
|
Silent Mode |
|
Notes per Transaction |
|
Contra Entries |
|
Work in Progress |
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
