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 are 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 period' and 'Cash at the end of 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 on the computer the files (Files attached to Bills) are stored. 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 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 3:

What are the field names for item image, item notes under item inventory in QODBC?

Solution 3:

I'm sorry to inform you that the item image, item notes 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 4:

I am trying 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", "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 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 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 where it becomes a QB invoice.
Now we need to have these invoices debit 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 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 btw, 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 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.
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).