Export Errors
| Error | Error Message | Reason | Case |
|---|---|---|---|
| 001 | Some items could not be exported 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 | Some items could not be exported 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] | 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 |
| 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] | 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 |
| 005 | Client Invoice xxxxxx: Exception occurred: org.apache.axis2.AxisFault: Object reference not set to an instance of an object. | 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. | 57019 | |
| 010 | Client Invoice xxxxxx: String or binary data would be truncated. The statement has been terminated | 57018 |