Got an error code 3070 when exporting file to QuickBooks

Asked By VladiM 0 points N/A Posted on - 12/07/2011

Hi,

I tried to export an Excel file to Quickbooks when I got this error below. 

 

QuickBooks Export Error

ErrorCode: 3070

Severity: Error

Description: The string “JLABQ1238-01” in the field “ RefNumber” is too long.

 

I didn’t know how to fix the problem. 

It’s a very long file in Excel and it would be tedious for me to revise each field.  Is there a workaround for this? 

Please help me fix the issue. 

Thanks in advance.

 

• Status: Open
• Question Views: 1888
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Business Management

Answered By Crag fresh 0 points N/A #120214

Got an error code 3070 when exporting file to QuickBooks

                            You problem is due to using of long character which is not allowed for the field.  The error itself describes already what your problem is. QuickBooks (Premier Edition 2005) on allowed only maximum of 11 characters. If exceed to that length you will encounter this error. So that means you should minimize the character that you want to user.  Instead of JLABQ1000 you can try to use JLABQ001 or JLABQ01. You can try also other solution like use you QuickBooks auto numbering so you will not get a problem regarding to this one. If you want to use this solution just search the internet.

 

 

About Crag fresh

Questions
1

Answers
135

Best Answers
22

• Vote Up 0 Vote Down

• Posted on - 12/08/2011
• Question Category: Business Management