Export to Access Dimensions
- Mark Holland (Unlicensed)
- Alex Smith
- Keith D'Lemos
- Kelly Collins
Export Errors
| Error | Error Message | Reason | Case |
|---|---|---|---|
| 001 | Client Invoice 0460: You cannot add detail lines to transactions that are no longer batched Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. | Try re-exporting. It is possible that the Invoice does export but is not marked as exported in RSM InTime. This can be done manually if it has successfully exported to Dimensions. Error seems to be that there is an invoice that already in Access Dimensions with the same invoice number. | 49401 49403 |
| 002 | Self Bill Invoice SB1568: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. The statement has been terminated. Case 56115 | 56115 | |
| 002 | Client Invoice xxxxxx: Could not create Client record:Invalid object name 'AA_AGED_DEBT_SUMMARY_WS_VW'. | Database view exists on the RSM InTime DB but not the Access Dimensions DB. Report to support@in-time.co.uk. | 49342 |
| 003 | Client Invoice aaaaa : Exception occurred: java.lang.Exception: Missing field 'consultantDepartment' on Client Invoice for Company X [aaaaa Net: 114.00 Sales Tax: 22.80 Gross: 136.80] |
Invoice aaaaa contains a timesheet for placement X; the consultants in the split for this placement are as follows: Consultant 1 - Department: CTY Consultant 2 - Department - blank To allow these invoices to be exported the profiles for the consultants listed above with a blank department will need to updated with the correct department value. | 51740, 61389 |
| 004 | Client Credit Note CNxxxx: Exception occurred: java.lang.Exception: Missing field 'consultantDepartment' on Client Credit Note for Company A [CNxxxx Net: -78.64 Sales Tax: -15.73 Gross: -94.37] |
| 51740, 61389 |
| 005 | Client Invoice xxxxxx: Exception occurred: org.apache.axis2.AxisFault: Object reference not set to an instance of an object. | This is a fairly generic error. However check the following
| 54616 55825 |
| 006 | Client Invoice xxxxxx: Could not create Client record:The VAT Export Status cannot be changed because there are transactions for this account | ||
| 007 | Client Invoice xxxxxx: Could not create Client record:The currency code cannot be changed because there are batched transactions for this account | ||
| 008 | Client Invoice xxxxxx: Could not create Client record:VAT Code G is an EU VAT Rate and therefore cannot be used for a Home Customer/Supplier | ||
| 009 | Client Invoice xxxxxx: Analysis ACCOUNTS1-TEC-BENM does not exist. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. Analysis ACCOUNTS1-TEC-JUNIOR does not exist. | Dimensions is rejecting the invoice as it cannot find a sales analysis code of ACCOUNTS1-TEC-BENM. If this analysis code is correct then it needs to be added to Dimensions. If it is not correct either the client nominal code or the department or reference for consultant needs to be updated to the correct value. | 55621, 57019 |
| 010 | Client Invoice xxxxxx: String or binary data would be truncated. The statement has been terminated | 57018 | |
| 011 | Client Invoice xxxxxx: You cannot add detail lines to transactions that are no longer batched Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. | Log a case with RSM InTime Support (support@in-time.co.uk) Potentially the transaction has already been exported. Check Dimensions to see if the transaction is in Dimensions. (Note that if you are not able to do this then we can handle via our Guildford office). If the transaction is in Dimensions then RSM InTime should be updated with the audit number from Dimensions and mark it as exported. | 56826 |
| 012 | Supplier Invoice xxxxxx Exception occurred: java.lang.Exception: Missing field 'nomonal code' on SupplierInvoice: ID:283807 | 57166 | |
| 013 | Client Credit Note xxxxxx: Analysis 4000-DEL-0104 does not exist. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0. Analysis ACCOUNTS1-TEC-JUNIOR does not exist. | See also Item 9 above Dimensions is rejecting the credit note as it cannot find a sales analysis code of 4000-DEL-0104. If this analysis code is correct then it needs to be added to Dimensions. If it is not correct either the client nominal code or the department or reference for consultant needs to be updated to the correct value. | 59328 |
| 014 | Client Invoice 174429: No invoice detail to export - is AccessDimensions.adjust.for.split.commission set to Yes? | Check the Configuration list setting
| 61389 |
| 015 | Supplier Invoice 1: Supplier account code ADB001C does not exist Access Dimensions was not able to save the Supplier Invoice Failed to export Client Invoice X to Access Dimensions: Cannot invoke method getTime() on null object Failed to export Supplier Invoice X to Access Dimensions: Cannot invoke method getTime() on null object | This situation occurred when there was a group expense on the invoice. The export script was changed. | 61545 |
| 016 | Client Credit Note X: Without a VAT registration number the Tax code must be of EU type T or U, or Tax code 8 for an EU Customer. Access Dimensions was not able to save the client Credit Note. | 61597 | |
| 017 | Client Invoice X: Exception occurred: java.lang.exception: Could not connect to Dimensions database | If you have created a new Access Dimensions database the following configuration details will need to be entered into RSM InTime. Advise the support team who can action this Database name Sales Sector Code ISO currency code Once this has been completed retry the export. Potentially you may also need to provide access to the SQL Server user on the new database | 62085 |
| 018 | Self Bill Invoice 0000000001: Unable to find a valid 2nd base currency rate to use on this transaction Access Dimensions was not able to save the Self Bill Invoice. | This error is returned from the Dimensions system. Clients should contact Access support to determine the cause of the error. | |
Default Mapping
| InTIME | Dimensions | Notes |
|---|---|---|
| Client | Customer | |
| Name | Name | |
| Accounts reference | Customer Code | |
| Invoice Contact | Contact name | |
| Invoice Contact email | ||
| Invoice Address | Address | |
| Company registration number | Company registration number | |
| Company Tax Number | Company Tax Number | |
| Default Currency | Currency Code | |
| VAT Code | default Tax code | |
| Provider | Supplier | |
| Name | Name | |
| Accounts reference | Customer Code | |
| Invoice Contact | Contact name | |
| Invoice Contact email | ||
| Invoice Address | Address | |
| Company registration number | Company registration number | |
| Company Tax Number | Company Tax Number | |
| Bank details | Bank details | |
| Worker | Supplier | |
| Name | Name | |
| Accounts reference | Customer Code | |
| Invoice Contact | Contact name | |
| Invoice Contact email | ||
| Invoice Address | Address | |
| Company registration number | Company registration number | |
| Company Tax Number | Company Tax Number | |
| Bank details | Bank details | |
| Invoice header | Invoice header | |
| Client/Provider/Worker Accounts Reference | Customer/Supplier Code | |
| Invoice Type | Description | Client Invoice, Client Credit Note, Self Bill Invoice, Self Bill Credit Note, Supplier Invoice, Supplier Credit Note |
| Invoice Number | Reference | |
| True | Post Live | |
| Invoice Date | Posting Date | |
| Exchange rate to base currency | Exchange Rate | |
| Due Date (if applicable) | Due Date | |
| Purchase Order Number | User Key 1 | |
| Invoice line | Invoice Detail | |
| <shortCode>:<sheet id> <periodEndDate> (<worker lastname, firstname>) | Details | TS:1243 23/09/2025 (Bloggs, Joe) EX:54331 04/12/2026 (Smith, Jane) |
| False | Archive | |
| (configurable) | Analysis Code | |
| Tax amount | Currency Tax Value | If non base currency invoice |
| Gross amount | Currency Gross Value | If non base currency invoice |
| Tax amount | Currency Tax Value | If base currency invoice |
| Net Amount | Home Net Value | If base currency invoice |
| Tax Code | Tax Code | |