Queries
The AR run-only queries list now includes:
11/09/2004 - New Queries
- 0AR021_AR_DIST_CODE_BY_BUDG_YR
This new query returns all distribution codes with chartfields by Budget Year. This can be used to verify distribution codes prior to submitting a request to add or change. This query prompts for Business Unit (SETID) and Budget Year. - 0AR007_ITEM_STATUS
Query has been modified to include AR Distribution Codes in column #3 of the query results. There is no change in the prompts for this query.
03/17/2003 - New Queries
- 0AR018_VERFIY_CUST_COST_ALLOCA
This query shows all Receivables, Debit Memos and Credit Memos with a combined total for each Customer for each GL account number. It will prompt on Business Unit, Accounting Period From and Thru, Budget Year and Account From and Thru. - 0AR019_VERIFY_DIR_JOUR_OTHER
This query shows all miscellaneous deposits entered by Direct Journal with a combined total for each GL account number. It will prompt on Business Unit, Accounting Period From and Thru, Budget Year and Account From and Thru.
06/14/2002 - New Queries
-
0AR980_CUST_LABELS
05/10/2002 - New Queries
-
0AR017_Offline_Items_By_Acct_Dt