Buy Support
Incidents
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information:
Click Here
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply).
Click Here
Buy Support
Incidents
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information:
Click Here
AR Summary sp_report - Parameter for 'Name State'
Author
Message
Pete
Group : Members
Posts : 3
Joined : 2006-05-11
Profile
Posted : 2006-05-11 02:45:51
In QuickBooks AR Report, I can filter on 'Name State'. I would like to do the same thing through Access using the sp_report. Is it possible to filter the AR Summary report by 'Name State'?
Tom
Group : Administrator
Posts : 5510
Joined : 2006-02-17
Profile
Posted : 2006-05-11 08:09:29
Sorry, the 'Name State' filter is not exposed. Only the following filters are available:
PARAMETERS AND VALUES FOR: A/R Aging Summary
PARAMETER PARAMETER VALUE
AccountFilterFullNames
FullNameN
AccountFilterFullNameWithChildren
FullName
AccountFilterListIDs
ListIdN
AccountFilterListIDWithChildren
ListId
AccountFilterType
'AccountsPayable'
AccountFilterType
'AccountsReceivable'
AccountFilterType
'AllowedFor1099'
AccountFilterType
'APAndSalesTax'
AccountFilterType
'APOrCreditCard'
AccountFilterType
'ARAndAP'
AccountFilterType
'Asset'
AccountFilterType
'BalanceSheet'
AccountFilterType
'Bank'
AccountFilterType
'BankAndARAndAPAndUF'
AccountFilterType
'BankAndUF'
AccountFilterType
'CostOfSales'
AccountFilterType
'CreditCard'
AccountFilterType
'CurrentAsset'
AccountFilterType
'CurrentAssetAndExpense'
AccountFilterType
'CurrentLiability'
AccountFilterType
'Equity'
AccountFilterType
'EquityAndIncomeAndExpense'
AccountFilterType
'ExpenseAndOtherExpense'
AccountFilterType
'FixedAsset'
AccountFilterType
'IncomeAndExpense'
AccountFilterType
'IncomeAndOtherIncome'
AccountFilterType
'Liability'
AccountFilterType
'LiabilityAndEquity'
AccountFilterType
'LongTermLiability'
AccountFilterType
'NonPosting'
AccountFilterType
'OrdinaryExpense'
AccountFilterType
'OrdinaryIncome'
AccountFilterType
'OrdinaryIncomeAndCOGS'
AccountFilterType
'OrdinaryIncomeAndExpense'
AccountFilterType
'OtherAsset'
AccountFilterType
'OtherCurrentAsset'
AccountFilterType
'OtherCurrentLiability'
AccountFilterType
'OtherExpense'
AccountFilterType
'OtherIncome'
AccountFilterType
'OtherIncomeOrExpense'
AgingAsOf
'ReportEndDate'
AgingAsOf
'Today'
ClassFilterFullNames
FullNameN
ClassFilterFullNameWithChildren
FullName
ClassFilterListIDs
ListIdN
ClassFilterListIDWithChildren
ListId
DateFrom
{d'yyyy-mm-dd'}
DateMacro
'All'
DateMacro
'LastCalendarQuarter'
DateMacro
'LastCalendarQuarterToDate'
DateMacro
'LastCalendarYear'
DateMacro
'LastCalendarYearToDate'
DateMacro
'LastFiscalQuarterToDate'
DateMacro
'LastFiscalYearToDate'
DateMacro
'LastMonthToDate'
DateMacro
'LastWeekToDate'
DateMacro
'NextCalendarQuarter'
DateMacro
'NextCalendarYear'
DateMacro
'NextFiscalQuarter'
DateMacro
'NextFiscalYear'
DateMacro
'NextFourWeeks'
DateMacro
'NextMonth'
DateMacro
'NextWeek'
DateMacro
'ThisCalendarQuarter'
DateMacro
'ThisCalendarQuarterToDate'
DateMacro
'ThisCalendarYear'
DateMacro
'ThisCalendarYearToDate'
DateMacro
'ThisFiscalQuarter'
DateMacro
'ThisFiscalYear'
DateMacro
'ThisMonth'
DateMacro
'ThisWeek'
DateMacro
'ThisWeekToDate'
DateMacro
'Today'
DateMacro
'Yesterday'
DateTo
{d'yyyy-mm-dd'}
DisplayReport
'No'
DisplayReport
'Yes'
EntityFilterFullNames
FullNameN
EntityFilterFullNameWithChildren
FullName
EntityFilterListIDs
ListIdN
EntityFilterListIDWithChildren
ListId
EntityFilterTypes
'Customer'
EntityFilterTypes
'Employee'
EntityFilterTypes
'OtherName'
EntityFilterTypes
'Vendor'
ItemFilterFullNames
FullNameN
ItemFilterFullNameWithChildren
FullName
ItemFilterListIDs
ListIdN
ItemFilterListIDWithChildren
ListId
ItemFilterType
'Assembly'
ItemFilterType
'Discount'
ItemFilterType
'FixedAsset'
ItemFilterType
'Inventory'
ItemFilterType
'InventoryAndAssembly'
ItemFilterType
'NonInventory'
ItemFilterType
'OtherCharge'
ItemFilterType
'Payment'
ItemFilterType
'Sales'
ItemFilterType
'SalesTax'
ItemFilterType
'Service'
ModifiedDateFrom
{d'yyyy-mm-dd'}
ModifiedDateMacro
'All'
ModifiedDateMacro
'LastCalendarQuarter'
ModifiedDateMacro
'LastCalendarQuarterToDate'
ModifiedDateMacro
'LastCalendarYear'
ModifiedDateMacro
'LastCalendarYearToDate'
ModifiedDateMacro
'LastFiscalQuarterToDate'
ModifiedDateMacro
'LastFiscalYearToDate'
ModifiedDateMacro
'LastMonthToDate'
ModifiedDateMacro
'LastWeekToDate'
ModifiedDateMacro
'NextCalendarQuarter'
ModifiedDateMacro
'NextCalendarYear'
ModifiedDateMacro
'NextFiscalQuarter'
ModifiedDateMacro
'NextFiscalYear'
ModifiedDateMacro
'NextFourWeeks'
ModifiedDateMacro
'NextMonth'
ModifiedDateMacro
'NextWeek'
ModifiedDateMacro
'ThisCalendarQuarter'
ModifiedDateMacro
'ThisCalendarQuarterToDate'
ModifiedDateMacro
'ThisCalendarYear'
ModifiedDateMacro
'ThisCalendarYearToDate'
ModifiedDateMacro
'ThisFiscalQuarter'
ModifiedDateMacro
'ThisFiscalYear'
ModifiedDateMacro
'ThisMonth'
ModifiedDateMacro
'ThisWeek'
ModifiedDateMacro
'ThisWeekToDate'
ModifiedDateMacro
'Today'
ModifiedDateMacro
'Yesterday'
ModifiedDateTo
{d'yyyy-mm-dd'}
ReportDetailLevelFilter
'All'
ReportDetailLevelFilter
'AllExceptSummary'
ReportDetailLevelFilter
'SummaryOnly'
ReportPostingStatusFilter
'Either'
ReportPostingStatusFilter
'NonPosting'
ReportPostingStatusFilter
'Posting'
TxnFilterTypes
'All'
TxnFilterTypes
'Bill'
TxnFilterTypes
'BillPaymentCheck'
TxnFilterTypes
'BillPaymentCreditCard'
TxnFilterTypes
'Charge'
TxnFilterTypes
'Check'
TxnFilterTypes
'CreditCardCharge'
TxnFilterTypes
'CreditCardCredit'
TxnFilterTypes
'CreditMemo'
TxnFilterTypes
'Deposit'
TxnFilterTypes
'Estimate'
TxnFilterTypes
'InventoryAdjustment'
TxnFilterTypes
'Invoice'
TxnFilterTypes
'ItemReceipt'
TxnFilterTypes
'JournalEntry'
TxnFilterTypes
'LiabilityAdjustment'
TxnFilterTypes
'PurchaseOrder'
TxnFilterTypes
'ReceivePayment'
TxnFilterTypes
'SalesOrder'
TxnFilterTypes
'SalesReceipt'
TxnFilterTypes
'SalesTaxPaymentCheck'
TxnFilterTypes
'Transfer'
TxnFilterTypes
'VendorCredit'
SQL EXAMPLE FOR: A/R Aging Summary
sp_report ARAgingSummary show Current_Title, Amount_Title, Text, Label, Current, Amount parameters DateMacro = 'Today', AgingAsOf = 'Today'