Good Day ,

can i use a prepareStatement in QODBC for inserting of  a Invoice with null values in some fields.

is their any other way of inserting invoice with out using the (FQSaveToCache ) field .

How can i extract the Balance of a Customer with in Particular Period of Time  like first 30 days,next 30 days and so on ..........

a) NULL values can be used in INSERT statements providing QuickBooks permits the use in the column or line.

b) FQSaveToCache only needs to be used for multiple lines. If a invoice only has a single line then the column can be omitted.

c) You can use the CustomerBalanceSummary stored procedure report for Customer Balances and set the DateFrom and DateTo values for the 30 day periods you're interested in:

sp_report CustomerBalanceSummary show Amount_Title, Text, Label, Amount
parameters DateFrom = {d'2007-01-01'}, DateTo = {d'2007-01-30'}, SummarizeColumnsBy = 'TotalOnly'

Note: Questions need to be asked as single topics in future so they can be searched by other users.