Skip to main content
S
Sam438
April 6, 2022
Question

Data mining

  • April 6, 2022
  • 1 reply
  • 0 views

Hello there

I wonder is somebody can help with my issue.

I am extracting data from QO and using it in a small reporting Access database.

I am using for my sales reports the tables INVOICE and INVOICELINE.

In order to generate sales reports by item I am using the INVOICELINE but I faced a problem that if a line was deleted from an invoice it stays in the table with no identification what so ever to its deleted status, although when I go to the web interface and request the invoice the line is not there.

can somebody help me on how to identify deleted records in INVOICELINE TABLE.

PS I am using QODBC to connect to Quickbooks online tables.

your help is most appreciated.

1 reply

T
Trish_T
April 6, 2022

Hi Sam438,

 

Thanks for reaching out here.  Welcome!  It's important that you're able to reach your QuickBooks goals in a timely fashion so you can get back to what you love!  In this situation, I recommend contacting QOBDC support for further guidance so you're on the right track with your work.

 

Please don't hesitate to reach back out with other questions.  We'd be happy to help!

Terms & ConditionsAccessibility statement