Skip to main content
K
kayman-singh-etk
April 15, 2024
Question

I am currently using QuickBooks Online Connector to link to PowerBi. One of our data entry inputs is through "Batch Transactions". I am trying to find the table for this

  • April 15, 2024
  • 1 reply
  • 0 views
Which table can i find the data posted through "Batch Transactions". Through QuickBooks its says that the data is in the "Check" table but I am unable to find that table. Can someone please help me?

1 reply

C
CamelleT
April 15, 2024

Let's work together in locating the data posted through batch transactions, kayman.

 

First, I'd like to confirm if you're referring to data posted in QuickBooks Online (QBO) through Reclassify Transaction. However, if you're talking about the data reflected in PowerBi, I suggest going to their designated forum to ask for assistance.

 

Furthermore, I'll add this resource to help keep your accounts, customers, and vendors organized: Merge duplicate accounts, customers, and vendors in QuickBooks Online.

 

Hit the reply button below if you have other questions about moving multiple transactions. I'll always be around to assist you. Have a nice day!

K
kayman-singh-etkAuthor
April 15, 2024

Hello Camelle, sorry but that's not what I am looking for.

When you open PowerBI and go to get data > Other sources > QuickBooks Online (Beta), a list of data tables is shown such as Bill Payment, Journal Entry, Bills, Account etc. 

What I am saying is that QuickBooks is showing that the transaction is in a "Check" table, but in the list of data tables, there is no "Check" table. We also tried searching for the ID in all the other data tables but it is not there.

So where is this data stored?

Terms & ConditionsAccessibility statement