[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 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. 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. | |
|