Adagio Ledger - G/L Account Information ======================================= Filters All Income Statement accounts {Acct Type} = "I" All Balance sheet accounts & retained earnings OR({Acct Type} ="B", {Acct Type} = "R") All Accounts with Budgets ({Budget Figure Period 1} +{Budget Figure Period 2} +{Budget Figure Period 3} +{Budget Figure Period 4} +{Budget Figure Period 5} +{Budget Figure Period 6} +{Budget Figure Period 7} +{Budget Figure Period 8} +{Budget Figure Period 9} +{Budget Figure Period 10} +{Budget Figure Period 11} +{Budget Figure Period 12} +{Budget Figure Period 13}) <> 0 Calculated Columns Total Budget {Budget Figure Period 1} +{Budget Figure Period 2} +{Budget Figure Period 3} +{Budget Figure Period 4} +{Budget Figure Period 5} +{Budget Figure Period 6} +{Budget Figure Period 7} +{Budget Figure Period 8} +{Budget Figure Period 9} +{Budget Figure Period 10} +{Budget Figure Period 11} +{Budget Figure Period 12} +{Budget Figure Period 13} Total Transactions Current Year (YTD if no future postings) {Current Year Net Trx Period 1} +{Current Year Net Trx Period 2} +{Current Year Net Trx Period 3} +{Current Year Net Trx Period 4} +{Current Year Net Trx Period 5} +{Current Year Net Trx Period 6} +{Current Year Net Trx Period 7} +{Current Year Net Trx Period 8} +{Current Year Net Trx Period 9} +{Current Year Net Trx Period 10} +{Current Year Net Trx Period 11} +{Current Year Net Trx Period 12} +{Current Year Net Trx Period 13} Total Transactions Last Year {Prev Year Net Trx Period 1} +{Prev Year Net Trx Period 2} +{Prev Year Net Trx Period 3} +{Prev Year Net Trx Period 4} +{Prev Year Net Trx Period 5} +{Prev Year Net Trx Period 6} +{Prev Year Net Trx Period 7} +{Prev Year Net Trx Period 8} +{Prev Year Net Trx Period 9} +{Prev Year Net Trx Period 10} +{Prev Year Net Trx Period 11} +{Prev Year Net Trx Period 12} +{Prev Year Net Trx Period 13} Budget Remaining (amount) ({Budget Figure Period 1} +{Budget Figure Period 2} +{Budget Figure Period 3} +{Budget Figure Period 4} +{Budget Figure Period 5} +{Budget Figure Period 6} +{Budget Figure Period 7} +{Budget Figure Period 8} +{Budget Figure Period 9} +{Budget Figure Period 10} +{Budget Figure Period 11} +{Budget Figure Period 12} +{Budget Figure Period 13} ) - ({Current Year Net Trx Period 1} +{Current Year Net Trx Period 2} +{Current Year Net Trx Period 3} +{Current Year Net Trx Period 4} +{Current Year Net Trx Period 5} +{Current Year Net Trx Period 6} +{Current Year Net Trx Period 7} +{Current Year Net Trx Period 8} +{Current Year Net Trx Period 9} +{Current Year Net Trx Period 10} +{Current Year Net Trx Period 11} +{Current Year Net Trx Period 12} +{Current Year Net Trx Period 13}) Budget Spent (percent) ({Current Year Net Trx Period 1} +{Current Year Net Trx Period 2} +{Current Year Net Trx Period 3} +{Current Year Net Trx Period 4} +{Current Year Net Trx Period 5} +{Current Year Net Trx Period 6} +{Current Year Net Trx Period 7} +{Current Year Net Trx Period 8} +{Current Year Net Trx Period 9} +{Current Year Net Trx Period 10} +{Current Year Net Trx Period 11} +{Current Year Net Trx Period 12} +{Current Year Net Trx Period 13}) / ({Budget Figure Period 1} +{Budget Figure Period 2} +{Budget Figure Period 3} +{Budget Figure Period 4} +{Budget Figure Period 5} +{Budget Figure Period 6} +{Budget Figure Period 7} +{Budget Figure Period 8} +{Budget Figure Period 9} +{Budget Figure Period 10} +{Budget Figure Period 11} +{Budget Figure Period 12} +{Budget Figure Period 13} ) * 100 Budget Remaining (percent) 100 -(({Current Year Net Trx Period 1} +{Current Year Net Trx Period 2} +{Current Year Net Trx Period 3} +{Current Year Net Trx Period 4} +{Current Year Net Trx Period 5} +{Current Year Net Trx Period 6} +{Current Year Net Trx Period 7} +{Current Year Net Trx Period 8} +{Current Year Net Trx Period 9} +{Current Year Net Trx Period 10} +{Current Year Net Trx Period 11} +{Current Year Net Trx Period 12} +{Current Year Net Trx Period 13}) / ({Budget Figure Period 1} +{Budget Figure Period 2} +{Budget Figure Period 3} +{Budget Figure Period 4} +{Budget Figure Period 5} +{Budget Figure Period 6} +{Budget Figure Period 7} +{Budget Figure Period 8} +{Budget Figure Period 9} +{Budget Figure Period 10} +{Budget Figure Period 11} +{Budget Figure Period 12} +{Budget Figure Period 13} ) * 100 ) Adagio Payables - A/P Vendors ============================= Filter Vendors with balance including credit balances {Outstanding Balance} <> 0 Calculated Columns Credit Room {Credit Limit} - {Outstanding Balance} Telephone # (formatted) IF((LENGTH(TRIM({Telephone})) > 1),(STRCAT("(",MID({Telephone} ,1 ,3 ),") ",MID({Telephone} ,4 ,3 ),"-",MID({Telephone} ,7 ,4 )))," Not on File") Fax # (formatted) IF((LENGTH(TRIM({Fax})) > 1),(STRCAT("(",MID({Fax} ,1 ,3 ),") ",MID({Fax} ,4 ,3 ),"-",MID({Fax} ,7 ,4 )))," Not on File") Adagio Receivables - A/R Customers ================================== Filters Customers with Balance including credit balances {Balance Outstanding} <> 0 Runtime Parameters: Use in combination with a True/False statement for creating filters {Cust #} = QueryString("Enter the Customer Number code") {Date} >= QueryDate("What is the first date of the range?") Calculated Columns Credit Available {Credit Limit} - {Balance Outstanding} Telephone # (formatted) IF((LENGTH(TRIM({Telephone})) > 1),(STRCAT("(",MID({Telephone} ,1 ,3 ),") ",MID({Telephone} ,4 ,3 ),"-",MID({Telephone} ,7 ,4 )))," Not on File") Fax # (formatted) IF((LENGTH(TRIM({Fax})) > 1),(STRCAT("(",MID({Fax} ,1 ,3 ),") ",MID({Fax} ,4 ,3 ),"-",MID({Fax} ,7 ,4 )))," Not on File") Sales YTD as % of Last Year's Sales (including Debit and Credit Notes) IF(({Inv Total - LY} +{DN Total - LY} +{CN Total - LY}) <>0, ({Inv Total - YTD} +{DN Total - YTD}+{CN Total - YTD} ) / ({Inv Total - LY} +{DN Total - LY} +{CN Total - LY} ) * 100, "-") Runtime Parameter: use in a calculated column for customized formula values {Sales Amount} * QueryNumber("Enter the Salesperson Commission %") / 100 Adagio Inventory - I/C Master Items =================================== Calculated Columns Sales Margin YTD If({Amt Sold YTD} <> 0,({Amt Sold YTD} -{Total Costs YTD} )/{Amt Sold YTD} *100,"-")