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.
Top of pageHow far back can the reconciliations be run?
With the exception of Assets which can only be run for the current financial year, the reconciliations can be run for the preceding 12 periods where the relevant historical data is being retained. Data stored in the DataRapt tables for periods prior to this may be accessed using the SYSPRO report writer.
Top of pageWhich 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.
Assets:
The default Assets Control and Accumulated Depreciation accounts held on the company control and used in the asset ledger interface program.
Inventory:
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.
GRN:
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?
Only in the Assets module. In the other modules, the Notes against a line item can be used to indicate that a contra variance exists in another financial period.
Top of pageDoes DataRapt handle foreign currency transactions?
Yes. All foreign currency transactions are converted to local currency in line with SYSPRO methodology.
Top of pageCan 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.
Top of pageDoes DataRapt automatically process correcting entries?
No. DataRapt does not write any data to SYSPRO files.
Top of pageWhy 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.
Top of page
