Knowledgebase: Tutorials
[QODBC-Desktop] Where are the "Company & Financial" sp_report for "Cash Flow
Posted by Rajendra Dewani (QODBC Support) on 14 April 2014 01:15 PM

Problem Description 1:

Where is the "Company & Financial" sp_report for "Statement of Cash Flow" and "Cash Flow Forecast"?

Is there any other way I can access values for 'Cash at the beginning of the period' and 'Cash at the end of the period,' please?

Solution 1:

I'm sorry to inform you that the Statement of Cash Flow report is not available through the Intuit SDK, so they are not available through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.

Problem Description 2:

I see where files (Files attached to Bills) are stored on the computer. How do we go about identifying which transaction that file belongs to?

Solution 2:

I'm sorry to inform you that the Files attachment is unavailable through the Intuit SDK, so they are unavailable through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.

Problem Description 3:

What are the field names for item images and item notes under item inventory in QODBC?

Solution 3:

I'm sorry to inform you that the item image and item notes field is unavailable through the Intuit SDK, so they are unavailable through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.

Problem Description 4:

I am trying to add sales tax info to the detail lines, but when I try this:

INSERT INTO "InvoiceLine" ("CustomerRefListID," "TxnDate," "RefNumber," "InvoiceLineItemRefListID," "InvoiceLineDesc," "InvoiceLineRate," "InvoiceLineAmount," "FQSaveToCache," "InvoiceLineIsTaxable," "SalesTaxLineRatePercent," "InvoiceLineAmount," "InvoiceLineItemRefFullName," "Memo," "Subtotal," "SalesTaxPercentage," "SalesTaxTotal") VALUES ('2', {d '2013-10-26'},'  PS11', '2', 'To Professional Services Rendered,' 1.00000, 1320.00, 1, 1, 5, 1352.00, 'PTax2015', 'Here is a memo,' 1352.00, 5, 82.52)

It reports that these fields are not allowed:

"Subtotal" not allowed
"SalesTaxPercentage" not allowed
"SalesTaxTotal"

So how do I include Sales tax?

Solution 4:

I'm sorry to inform you that the "Subtotal," "SalesTaxPercentage," and "SalesTaxTotal" field is not available through the Intuit SDK, so they are not available through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.

Problem Description 5:

How do I update the vendor's website field using an SQL Statement?

Solution 5:

I'm sorry to inform you that the vendor website field is unavailable through the Intuit SDK, so they are unavailable through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.

Problem Description 6:

We have an Access program that we prepare our daily orders with, and it manages our live inventory.
When the trucks are loaded, the last step is to transmit the Access order into QB, which becomes a QB invoice.
Now we need to have these invoices debited against estimates. I found that once the invoice is made in QB, it cannot be linked to the estimate, so I assume I have to do either:
1) send it to the estimate and then have the person convert it to an invoice in QB, or 2. just set the estimate link field to the estimate when I sent it in.
The second option sounds like what I would like, but I don't know. Can you tell me what the appropriate method for doing this is?
(I wrote the code for the original access program, by the way, it's just that I haven't modified it in 3+ years and am not up to speed on QODBC anymore)

Solution 6:

I'm sorry to inform you that the creating link of the estimate to invoice is unavailable through the Intuit SDK, so they are unavailable through QODBC.

QODBC is an ODBC driver for QuickBooks. It uses the QuickBooks SDK to communicate with QuickBooks, which means if Intuit doesn't expose one feature to the application in SDK, QODBC could not do it either.
For the workaround, you may have to follow the first option.

(1 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).