Click or tap on a question to read the answer:
Do I have to post all entries into the ledger before I can run the reconciliation?
No. DataRapt identifies any unprinted/unposted audit trails and ledger entries.
How far back can the reconciliations be run?
With the exceptions below, the reconciliations can be run for the both the current and previous financial years. Whilst the reconciliations may be refreshed for any period within this range, the SYSPRO data retention options affect the accuracy of the data in the reconciliation.
The reconciliations for the Assets module can only be run for the current financial year.
The reconciliations for the Inventory module can only be run for the current and preceding 11 periods.
Data stored in the DataRapt tables for periods prior to this may be accessed using the SYSPRO report writer.
Which control accounts are used in the reconciliations?
The following control accounts are included in the DataRapt reconciliations:
- Accounts Payable:
All accounts used in the A/P Control Ledger Code field on the A/P Branch master.
- Accounts Receivable:
All accounts used in the A/R Control field on the A/R Branch master.
- Cash Book:
All accounts used in the Cash Account field on the Bank master.
The default Assets Control and Accumulated Depreciation accounts held on the company control and used in the asset ledger interface program.
All accounts used in the Warehouse Control field on the Warehouse master.
- Goods in Transit:
All control accounts stored in the Goods in Transit master file/table.
The default GRN Suspense account held on the company control as well as all accounts used in the GRN Suspense field on the Warehouse master.
- Dispatch Notes:
All control accounts strored in the Dispatch Notes Trial Balance file/table.
- Work in Progress:
The default Work in Progress account held on the company control as well as all accounts used in the WIP Ledger Code field on the Job master.
- WIP Inspection:
All accounts used in the WIP Inspection field on the Warehouse master.
Can you contra variance entries in different financial periods?
Yes. Note that transactions in a contra group that spans more periods or control accounts than are being viewed will be displayed in italics.
Does DataRapt handle foreign currency transactions?
Yes. All foreign currency transactions are converted to local currency in line with SYSPRO methodology.
Can I exclude rounding differences from the Inventory reconciliation?
No. However, you can set a preference which allows you to accumulate rounding differences to a single line when less than the entered amount.
Does DataRapt automatically process correcting entries?
No. DataRapt does not write any data to SYSPRO files.
Why does SYSPRO allow distribution entries to be posted to control accounts?
There are times when a correcting entry is needed in the sub-module, but not in the control account. The only way to achieve this is to post the “other side of the entry” to the control account.