Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> Error<\/strong> Solution<\/strong> <\/p>","protected":false},"excerpt":{"rendered":" No Tracking Options are defined Tracking Options are defined Overpayment was not created Record of Bill Line was not created Bill was not synchronized Do not use Cost Centre number in Line Item(s) for the Sales Invoice Contact was not synchronized Email Contact is NOT sent to Xero State Value…<\/p>","protected":false},"author":21,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[70],"ht-kb-tag":[94],"class_list":["post-6190","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-xero","ht_kb_tag-xero"],"_links":{"self":[{"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/ht-kb\/6190"}],"collection":[{"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/comments?post=6190"}],"version-history":[{"count":7,"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/ht-kb\/6190\/revisions"}],"predecessor-version":[{"id":9218,"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/ht-kb\/6190\/revisions\/9218"}],"wp:attachment":[{"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/media?parent=6190"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/ht-kb-category?post=6190"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.gjgardner.com\/au\/wp-json\/wp\/v2\/ht-kb-tag?post=6190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Xero Journal – NO Tracking Options are defined for the transaction recorded against the Account Code X-XXXX defined in the System Variables as Job Expense Accounts. Tracking Options must be defined, please check.<\/p>\n\n\n\n
Click on the paperclip icon to the right of the error message which will open the transaction in Xero. Edit the transaction and enter the job number & Cost Centre, process. If the Bill is still in draft awaiting these details ignore the error message.<\/p>\n\n\n\nTracking Options are defined<\/h2>\n\n\n\n
Xero Journal – Tracking Options are defined for the transaction recorded against the Account Code X-XXXX defined in the System Variables as Overhead Accounts. Tracking Options must NOT be defined.<\/p>\n\n\n\n
Accounts that have not been assigned to a \u201cJob Cost account\u201d being 5-1010 Subcontractors & Suppliers OR 5-1012 Materials, cannot have a job number and\/or Cost Centre assigned to them. Click on the paperclip icon to the right of the error message which will open the transaction in Xero. Edit the transaction and either remove the job number and\/or Cost Centre OR change to a \u201cJob Cost account\u201d.<\/p>\n\n\n\nOverpayment was not created<\/h2>\n\n\n\n
Overpayment from Contact XXXXXX was not created in BP. Reason: Job Number is not specified in Overpayment.<\/p>\n\n\n\n
The DPP Overpayment created in Xero is missing a number in the Job Number column field. Locate the Overpayment in Xero by going to Business-Sales Overview-Awaiting Payment-find the overpayment and click to open-Overpayment Options-Edit-enter DPP job number into \u201cJob Number\u201d field-Update.<\/p>\n\n\n\nRecord of Bill Line was not created<\/h2>\n\n\n\n
Record of Bill Line for XXXXXX was not created in BP. Reason: one of the required Tracking Option(s) Job# and Cost Center# is missing.<\/p>\n\n\n\n
Click on the paperclip icon to the right of the error message which will open the transaction in Xero. Edit the transaction and enter the job number & Cost Centre, process. If the Bill is still in draft awaiting these details ignore the error message.<\/p>\n\n\n\nBill was not synchronized<\/h2>\n\n\n\n
Bill was not synchronized, ID: 899b1d06-5dd7-4ce7-81f9-af1fc757ff2e. Main exception cause: PSQLException: ERROR: value too long for type character varying(20).<\/p>\n\n\n\n
Check the length of the characters and initialize a re-sync. To Find the invoice you need to prefix the ID with https:\/\/go.xero.com\/AccountsPayable\/View.aspx?InvoiceID=<\/p>\n\n\n\nDo not use Cost Centre number in Line Item(s) for the Sales Invoice<\/h2>\n\n\n\n
Do not use Cost Centre number in Line Item(s) for the Sales Invoice in Xero. It can not be fixed automatically. Correct it in Invoice #INV-XXXX.<\/p>\n\n\n\n
Only non-client\/job income can be entered in Xero as receivable invoices entered in Xero cannot have a job number and\/or Cost Centre. All extra job income to be entered in GJ5.0 as a variation. Click on the paperclip icon to the right of the error message which will open the transaction in Xero. Edit the transaction and either remove the job number and\/or Cost Centre and preferably re-allocate to a Sundry Income account OR remove the transaction altogether and create a variation in GJ5 if related to a job.<\/p>\n\n\n\nContact was not synchronized<\/h2>\n\n\n\n
Contact XXXXX was not synchronized. Main exception cause: XeroBadRequestException: ValidationException: Contact with number ‘ZXRV1K’ has validation errors: The contact name XXXXXX is already assigned to another contact. The contact name must be unique across all active contacts.<\/p>\n\n\n\n
Duplicate contact card in GJ5.0. Go to Contacts in GJ5.0 and search the name, remembering it also includes inactive contact cards. Edit one of the contact cards so the names are distinct, even adding a full stop at the end of the surname works.<\/p>\n\n\n\nEmail Contact is NOT sent to Xero<\/h2>\n\n\n\n
Email for Contact XXXXXX is NOT sent to Xero as the format is not correct. Please correct the email in BP.<\/p>\n\n\n\n
Go to Contacts in GJ5.0 and search the name. Check the Primary email is correct. Go to the \u201cCREDITOR\/SUPPLIER\u201d tab and check if any of the \u201cDELIVER\u201d emails are toggled to \u201cDifferent\u201d that the emails are not blank OR the same as the Primary email, if so, toggle back to \u201cSame\u201d. Process to save changes.<\/p>\n\n\n\nState Value Exceeds Maximum Field Length<\/h2>\n\n\n\n
”State” value exceeds maximum field length. The value will be reduced to 6 characters.<\/p>\n\n\n\n
Run a Contacts > All Contacts report in Xero. Export the list to .csv file. Open the file and look in the PORegion or SARegion column. You may find it easier to sort by column. You are looking for entries that are longer than 6 spaces. ie New South Wales instead of NSW. Go into the contact file and adjust the state field and save changes.<\/p>\n\n\n\nSQLException During Execution Error<\/h2>\n\n\n\n
Xero synchronization is failed: SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk8.WrappedConnectionJDK8@….<\/p>\n\n\n\n
This error does not affect synchronization with Xero. This error occurs on the back end of the application within the Wildfly server. Allow for some time to pass and manually run the Xero sync again to see if it still occurs. <\/p>\n\n\n\n