cancel
Showing results for 
Search instead for 
Did you mean: 
margaret-cosmics
Level 1

I am exporting an invoice to excel for a customer who wants to pay via EDI, when I add the quantity column it shows up as a negative..wondering why

 
3 Comments 3
BettyJaneB
QuickBooks Team

I am exporting an invoice to excel for a customer who wants to pay via EDI, when I add the quantity column it shows up as a negative..wondering why

Glad to have you here in the Community, @margaret-cosmics.

 

I'd like to make sure that we're on the same page so I can give you the right about of information to get this issue sorted out.

 

I want to ask which of the following are you trying to import:

  • Single invoice transaction
  • Invoice list
  • Sales detail report 

Any further details about this matter are much appreciated. This way, it can help me narrow down this concern.

 

Please get back to me by leaving a reply below. I'll be keeping an eye out for your response on this. Take care!

margaret-cosmics
Level 1

I am exporting an invoice to excel for a customer who wants to pay via EDI, when I add the quantity column it shows up as a negative..wondering why

A single invoice

Candice C
QuickBooks Team

I am exporting an invoice to excel for a customer who wants to pay via EDI, when I add the quantity column it shows up as a negative..wondering why

Good Morning, @mergaret-cosmics. 

 

Thanks for the additional information that you gave about trying to export a single invoice transaction. 

 

If you're exporting a single invoice transaction into Excel, then this would be more of an Excel issue. However, you might be able to change some settings within your Excel to make the quantity column shown as a positive as it does in QuickBooks Online. 

 

After trying this in my test account, there isn't a way to export a single invoice transaction. There could be a possibility that you're trying to export a report to Excel and it's making the quantity column show as a negative. 

 

To give you the best solution, can you please provide me with a screenshot or a video of how you're exporting in your QuickBooks Online (QBO) account and the way it looks in the Excel spreadsheet? This will help me determine the best answer to your question. 

 

I want to make sure all of your concerns are addressed, and we get a better understanding of why this is occurring when exporting through your QuickBooks Online (QBO) account. Hit the Reply button at the bottom of the post when you've gathered the other information. Take care!

Need to get in touch?

Contact us