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