Skip to main content
P
pa-canova
December 11, 2019
Question

Hi all, I want to extract for my customers their quickbooks id. I know that it is possible with zapier for example (not for historical period). Could you help?Thanks

  • December 11, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

E
EmmaM
December 11, 2019

Hello Pa-canova

 

We need a bit more information about what you need to extract.Are you their accountant?Are you referring to the long number that is used to identify which product they have with the phone support or is it actual transactions,like invoices ,sales receipts you are looking to export from the QuickBooks Online package?

 

Thank you

 

 

P
pa-canovaAuthor
December 11, 2019

Hello, 


I am the owner of my QB account. 

 

I am referring to the number shown in the url "https://xxxxxxxx/app/customerdetail?nameId=7". I think you call it name Id.

 

What I want to extract is in an extract :  

client A               Invoice 10                ID name = 5               Amount = 100€

client A               Invoice 11                ID name = 5               Amount = 120€

client B               Invoice 66                ID name = 10             Amount = 100€

Fiat Lux - ASIA
Fiat Lux - ASIA
December 11, 2019

@pa-canova 

I notice there are 55 fields of invoice data in QBO, including RefNumber, Customer, and LineAmount. I didn't see any field related to certain ID. Utilize this exporter tool and filter any data field you want to extract.

https://transactionpro.grsm.io/qbo

 

Hope it helps.

Terms & ConditionsAccessibility statement