Baystate Consulting Homepage
Forum Home Forum Home > QuickBooks Products > 01 Transaction Pro Importer 2.0 [Product retired 12/31/2010]
  New Posts New Posts RSS Feed - ErrorTransactions must have at least one line item
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedErrorTransactions must have at least one line item
 Post Reply Post Reply Page  12>
Author
Message
  Topic Search Topic Search  Topic Options Topic Options
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Topic: ErrorTransactions must have at least one line item
    Posted: 06 February 2009 at 12:34pm
I am trying to import invoices into QuickBooks and am receiving the following error:
Transactions must have at least one line item
I have a column of my spreadsheet specified for the "Item" column, so I don't understand what this error means. 
 
Please help.
 
- Mark
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 06 February 2009 at 12:45pm
Are you specifying a price? If not and the item exists in QB does it have a price?
 
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 06 February 2009 at 1:25pm
I am not specifying a price, but the item (with price) is already set up in Quickbooks.
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 06 February 2009 at 1:36pm

Please zip and upload the following information:

settings.txt (for 2.0 this will be in the same folder as TPI - for 3.0 it will be in My Documents\01 Transaction Pro Importer 3.0)

Import file

Map file
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 06 February 2009 at 2:20pm
uploads/1012/Test1_2-6-09.zip
 
I have uploaded the files you requested.  Thank you for your help.
 
- Mark
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 06 February 2009 at 2:56pm
I see you are running 2.142. The latest release 2.151 may resolve this issue. Try clicking About then Check for Updates, download and install the latest release and see if it resolves your issue.
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 11:07am
I have downloaded the newest version and tried importing the same file.  I am still getting the same error.  I am not blaming you, but this is getting frustrating and is very time consuming.  What can I do to get this to work?
 
- Mark
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 11:21am
In your mapping do the following
 
Scroll down to the Quantity row and in the static value column enter 1
Make sure each item in QB has a price
 
This will resolve your issue.
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 12:59pm
I have added "1" into the static value column and I am still getting the same error.
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 1:03pm
Create a QB file that reproduces this error, zip it and upload to this forum. We will respond promptly with what the issue is. We cannot reproduce this with the file we created. Each of our items have a price. Are you certain each of your items have a price in the QB item list?
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 4:11pm
I checked and each of the items have prices in Quickbooks.  I don't understand what you mean by "Create a QB file that reproduces this error."  Can you please explain?
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 4:17pm

What version of QB are you running? I will upload the sample QB file we used and maybe that will help you determine the problem.
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 4:25pm
Pro 2006
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 6:14pm
Here is the file we used for testing. You can download and unzip it then restore the portable company file using QuickBooks. uploads/1/2006_Pro_Test_File.zip
 
I understand this doesn't help with your company file but maybe by looking and importing to this file it can help us pinpoint what is going on.
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2009 at 9:21am
My computer (Windows) is not able to open this file.  What program am I supposed to use to open this file?
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2009 at 9:38am
Unzip the file
Start QuickBooks close any open company
Choose File/Portable Company File/Open File
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2009 at 10:20am

Wow!  It worked.  So what does this mean for my Quickbooks file?
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2009 at 10:24am
Try rebuilding your QB file. File/Utilites/Rebuild Data
Back to Top
OCCMark View Drop Down
Groupie
Groupie


Joined: 06 February 2009
Status: Offline
Points: 13 		Post Options Post Options   Thanks (0) Thanks(0)   Quote OCCMark Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2009 at 11:16am
I have followed those steps and rebuilt the QB file and am still getting the same error.  What can I try next?
Back to Top
Administrator View Drop Down
Admin Group
Admin Group


Joined: 01 October 2003
Status: Offline
Points: 2595 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Administrator Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2009 at 11:24am
If you want to purchase a support incident we can login and help you further troubleshoot the problem seeing that it is limited to your QB file.
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10.14
Copyright ©2001-2012 Web Wiz Ltd.