Export to Access Dimensions

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 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 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]	Check that all the split consultants are on the system The issue is that there is no value set as the Department for one or more of the consultants in the Consultant Split for the placement the invoice refers to. 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]	Check that all the split consultants are on the system As with error 3 above, check the Consultants on the Placements associated with this Credit Note. If the Consultant has a blank Department field update this to the correct value and retry the export.	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 Is there already an invoice with the same number in the Clients Dimensions system. If there is, can this be renamed and the export retried.	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 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 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 AccessDimensions.adjust.for.split.commission Check the split commissions on the Placement. Add these in and it should export.	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 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.