cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
cpc-copierpc-com
Level 1

I'm trying to import invoices with 0 quantity, rate of $0.15 for an item, it failed. How can we import invoices with 0 qty? In QB global successf, but in QB SG, it failed

 
5 Comments 5
JessT
Moderator

I'm trying to import invoices with 0 quantity, rate of $0.15 for an item, it failed. How can we import invoices with 0 qty? In QB global successf, but in QB SG, it failed

Hi there!

 

Let's check to see why you're unable to import your invoices.

 

I have successfully imported an invoice with one item with 0 qty and a $0.15 rate into my QBO SG trial company. There was no error or anything. What about you? There must be a reason or error if you can't import.

 

If there was no error on your end, we can do the browser troubleshooting steps. This is a way to find out if you're just experiencing random browser issues.

 

We can start by signing in to your QBO company using a private window. This step will disable the extensions and stops the cache from saving your search history.

 

  • Google Chrome: Ctrl + Shift + N.
  • Safari: Command + Shift + N.
  • MS Edge and Firefox: Ctrl + Shift + P.

 

If private browsing lets you import your invoice, you can clear your browser's cache. If not, please use a different browser to see if this only happens to the one you are using.

 

Feel free to share an update after doing the basic troubleshooting steps. We're just around if you need more help.

cpc-copierpc-com
Level 1

I'm trying to import invoices with 0 quantity, rate of $0.15 for an item, it failed. How can we import invoices with 0 qty? In QB global successf, but in QB SG, it failed

Hi, thank you for the suggestion but it does not work out. I still get this error after using google private window.

cpccopierpccom_0-1674356066472.png

 

The files that i upload looks like this:

cpccopierpccom_1-1674356126344.png

The moment i changed the 0 to other numbers, it will upload successfully. But not with 0. 

katherinejoyceO
QuickBooks Team

I'm trying to import invoices with 0 quantity, rate of $0.15 for an item, it failed. How can we import invoices with 0 qty? In QB global successf, but in QB SG, it failed

Thanks for sharing your screenshots, @cpc-copierpc-com.

 

As an overview, when you import invoices with multiple line items, make sure each line entry has an invoice number, customer, invoice date, and other required details, just like in the sample spreadsheet.

 

I can see that the error occur because there are blanks on line entries from the second and fifth lines with invoice numbers: 2301118.

 

To fix this, I'd recommend removing those lines or filling those lines so it will go through. 

 

For your reference, check out this article to learn more about importing invoices in QuickBooks Online.

 

Get back to us here if you have additional questions. We're always around here to lend a hand of your importing concerns.

cpc-copierpc-com
Level 1

I'm trying to import invoices with 0 quantity, rate of $0.15 for an item, it failed. How can we import invoices with 0 qty? In QB global successf, but in QB SG, it failed

Hi, 

 

I have tried your method to input everyline item. As below:

 

Untitled.jpg

But the same error still occured as previous.

 

As i mentioned earlier, the error occured is because of the quantity 0. As when i changed it to other number, it's able to upload successfully. 

It had no problem with Quickbooks global, but problem occured with Quickbooks Singapore. Can you please check. I have attached the file in pdf (not allowed to send you the csv file), maybe you can try and see if it works.

Rubielyn_J
QuickBooks Team

I'm trying to import invoices with 0 quantity, rate of $0.15 for an item, it failed. How can we import invoices with 0 qty? In QB global successf, but in QB SG, it failed

I want to ensure this is taken care of, @cpc-copierpc-com.

 

Since the issue persists after doing the steps provided by my colleague above, we have a designated team that'll help with opening your account and find the root cause of issues with error when importing invoices. 

 

Here's how to contact our QuickBooks Online support:

 

  1. Go to the Help (?) icon at the top.
  2. On the Assistant tab.
  3. Type a question, keyword or topic for QuickBooks Online self-help content or select Contact Us, type a question and Continue. Choose a way to connect with us:
  4. Select Start a chat with a QuickBooks support expert online.

  

Additionally, I've added these articles that'll help you manage your invoices when importing in QuickBooks:

 

 

Please know that we're determined to get this resolved. Keep us posted if you have follow-up questions about importing invoices in QuickBooks.