Knowledge base

　 define number custkey = parameter prompt “Enter Customer Account Number ” ; std_date begdate = parameter/prompt=”Enter Beginning Date to Report ” default todaysdate-365; std_date enddate = parameter/prompt=”Enter Ending Date to Report ” default todaysdate; where cr_main:cs_key=custkey and cr_main:cr_in_due_date>=begdate and cr_main:cr_in_due_date<=enddate and cr_main:cr_trans_type=”C” List/nobanner/domain=”cr_fixat”/title=”EQUIPMENT RENTED BY CUSTOMER”/dup cr_main:cr_contract/heading=”CONTRACT” cr_main:cr_out_date/heading= “OUT”/width = 8 cr_in_due_date/heading=”IN”/width=8 cr_fixat:fa_key/noheading fa_main:fa_name/heading= […]

May 21, 2020

Report Output Example: ********************************************************************************************************************* define Ascii Date from_date = parameter/cls/prompt=” Enter Beginning Date ” define Ascii Date to_date = parameter/line=3/prompt=” Enter Ending Date ” define string code = parameter/prompt = “Enter Renter Departmet”/uppercase define string Loc[3] = parameter/line=5/prompt = ” Enter Store Location or #A for all locations “/uppercase define string acct_type[1] = parameter/line=7/prompt=”Enter C […]

Report Output Example: ************************************************************************************************************ find cs_main with any  ((cs_inv:cs_iamount – cs_ipaid)<0) or with any (cs_pymt:cs_pamount – cs_pallocated) <>0 list/nobanner/title=”CUSTOMERS WITH CREDITS”/noblanklines/domain = “cs_main” cs_main:cs_key cs_main:cs_name if (cs_inv:cs_iamount – cs_ipaid)<0 then {cs_inv:cs_invoice (cs_iamount – cs_ipaid)/heading=”CREDIT-REMAINING”} if (cs_pymt:cs_pamount – cs_pallocated)<>0 then{ cs_pymt:cs_check (cs_pymt:cs_pamount – cs_pallocated)/heading=”UNAPPLIED-PAYMENT-AMOUNT”} sorted by cs_main:cs_key

/* The following report will ask for a customer key and date range and list all sales to that customer in that date range by contract. Updated 4/18/14 to include location and serial number. */ define number acctno = parameter/prompt=”Enter Customer Account Number “ define date begindt = parameter/prompt=”Enter Beginning Sale Date to Include “ define […]

Report Output Example: *************************************************************************************************************************************** define string type[3]=parameter/cls/line=10/prompt=”Enter the customer type: #A-ALL/CA-Cash/BG-Bad/AR/AC-AR but COD/PR-Prospect ” /uppercase define string bus_type[2]=parameter/cls/line=10/prompt=”Enter the Business Type or #A to select all Business Types”/uppercase define file wkdeflt = access wk_deflt, set wk_def_set = “1”, generic where (trun(type) = trun(cs_main:cs_type_code) or type = “#A”) and (cs_main:cs_business_type = bus_type or bus_type = “#A”) […]

Report Output Example: ******************************************************************* define number key = parameter/prompt = “Enter Customer Key” define string check = parameter/prompt = “Enter Check #” where cs_pall:cs_key = key and cs_pall:cs_check = check list/domain = “cs_pall”/nobanner/nototal cs_pall:cs_check cs_invoice cs_aamount top of page al_param:al_loc_name/noheading/newline al_loc_address_1/noheading/newline al_loc_city/noheading/newline al_loc_zip/noheading/newline=3 cs_main:cs_key/newline/nohead cs_name/newline/noheading cs_address_1/newline/noheading cs_city/noheading/newline al_st_code/noheading al_zipcode/noheading/newline=2 cs_phone_1/newline=3/nohead end of page box /line […]

Report Output Example: *********************************************************************************************************** define date startdt = parameter prompt “Enter Starting Date to Report” ; date enddt = parameter prompt “Enter Ending Date to Report” ; where cs_inv:cs_icreate_date >= startdt and cs_inv:cs_icreate_date <= enddt and cs_inv:cs_inv_type one of “CC”, “WO” sum/title=”Closed Contract Total by Month by Customer”/domain=”cs_inv” cs_inv:units/heading=”# Tickets”/total/width=20 cs_inv:cs_iamount/heading=”Total” across cs_inv:cs_icreate_date/month/year/total/noheading by highest […]

define date start_of_mo_last_yr = dateadd(todaysdate,0,-1) – day(todaysdate) + 1 where   cs_inv:cs_icreate_date > start_of_mo_last_yr sum/title=”Closed Contract Total by Month by Zip Code – For One Year to Date”/domain=”cs_inv”   cs_inv:cs_iamount/noheading across   cs_inv:cs_icreate_date/month/year/total/noheading by   cs_main:al_zipcode

Report Output Example: ******************************************************************************************* define number key = parameter/prompt = “Enter Customer Key” define Ascii Date lfrom_date = parameter/cls/line = 10/prompt = “Please Enter Starting Date :” default todaysdate define STD_DATE from_date = lfrom_date define Ascii Date lto_date = parameter/cls/line = 10/prompt = “Please Enter Ending Date :” define STD_DATE to_date = lto_date where cs_tcklr:cs_tdate […]

define   number contno = parameter prompt “Enter Customer Key” ; define date begindt = parameter/prompt= “Enter Beginning Date to Include “  define date enddt = parameter/prompt= “Enter Ending Date to Include “     where cs_inv:cs_key=contno and cs_inv:cs_icreate_date>=begindt and cs_icreate_date<=enddt   list/nobanner/title=”Invoice History”/domain=”cs_inv” cs_inv:cs_icreate_date/heading=”Invoice Date” cs_inv:cs_invoice/heading=”Invoice Number” cs_inv:cs_idescription/heading=”Description” cs_inv:cs_inv_type/heading=”Invoice Type” cs_inv:cs_iamount/heading=”Invoice Amount” cs_inv:cs_ipaid/heading=”Amount Paid” […]