Knowledge base

define   number key2 = parameter prompt “Enter Customer Key to Report” ;     where   ( cr_main:cr_trans_type one of “C”, “R” )   and ( cr_contract_closed = “N” )   and ( cs_key = key2 )   list/domain=”cr_main”/nobanner/title=”Open Reservations and Contracts by Customer”   cr_main:cr_reservation   cr_main:cr_contract   cr_main:al_location     cr_main:cr_open_date   cr_main:cr_out_date […]

May 21, 2020

Report Output Example: ********************************************************************************************************** define date indt = parameter prompt “Enter Beginning Date to Report” ; date edt = parameter prompt “Enter Ending Date to Report” ; number key2 = parameter prompt “Enter Customer Key” ; file sale = access sl_name_t, set sl_name_t:sl_mfg_cat_no=cr_sales:sl_mfg_cat_no where ( cr_main:cr_in_due_date >= indt ) and ( cr_main:cr_in_due_date <= edt ) […]

Report Output Example: ************************************************************************************************** –define number MonthPar = parameter/prompt=”Enter Month (1-12): ” define number YearPar = parameter/prompt=”Enter Year (YYYY): ” define string Loc[3]= parameter/prompt=”Enter store location or #A for all stores: “/uppercase define file wkdeflt = access wk_deflt, set wk_def_set = “1”, generic where cr_main:cr_annual_event = “Y” and (trun(loc) = “#A” or trun(cr_main:al_location) = trun(loc)) […]

where cs_main:cs_type_code=”CA” list/domain=”cr_main”/nodetail/noblanklines/noreporttotals/title =”Refund Due Report”   cr_main:cr_transaction/heading =”BID” /name = “c1”   cr_main:cr_contract /name = “c2”   cs_main:cs_name /name = “C3”   cr_main:cr_job_name /name = “C5”   cr_main:cr_open_date /name =”C6″   cr_main:cr_in_due_date /name = “C7”   cr_totls:cr_ticket_total/heading = “PAYMENT-AMOUNT” /name = “C8”   cr_finpy:cr_paymt_amount/heading=”TICKET-AMOUNT” /name = “C9”  cr_totls:cr_ticket_total/HEADING =”REFUND-AMOUNT”/name =”C10″   sorted by   […]

Report Output Example: *********************************************************************************************************** define date begin = parameter/prompt = “Enter Beginning Date” define date enddt = parameter/prompt = “Enter Ending Date” where cr_main:cr_open_date>=begin and cr_in_due_date<=enddt and cr_totls:cr_ticket_total<0 and cr_main:cr_trans_type <> “D” list/domain=”cr_main”/nobanner/title=”Credit Tickets for Date Range” cs_main:cs_key/heading = “Key” /dup cs_main:cs_name/heading=”Name”/name=”c3″/dup if cr_main:cr_trans_type =”Q” then {“B-“+str(cr_main:cr_transaction)/heading=”CONT -RES -BID “/width = 4} else if cr_main:cr_trans_type […]

define Ascii Date from_date = parameter/cls/line=11/prompt=”Enter Beginning Date> “ define Ascii Date to_date = parameter/line=12/prompt=”Enter Ending Date   > “ WHERE       cr_main:cr_contract_closed <> “Y” and       cr_main:cr_trans_type one of “R”,”C” and                   (cr_main:cr_pickup = “Y” and            cr_fixat:cr_in_due_date >= from_date and            cr_fixat:cr_in_due_date <= to_date )  and   (cr_main:cr_delivery = “Y”        and cr_main:cr_out_date >= […]

Report Output Example: ********************************************************************************************************* define date indt = parameter/prompt=”Enter Date Back Posted To (Last Day of Month)” define date fom = indt – day(indt) + 1 define date  eom = dateadd(fom,1) – 1 define file csmain = access cs_main, set cs_main:cs_key = cr_main:cs_key, generic where cr_log:cr_trans_stat = “BP” and cr_log:cr_log_date= eom list/nobanner/title = “Back Posting […]

Report Output Example: ********************************************************************************************************* define file rcmain = access rc_main, set rc_main:rc_inv_no = cr_fixat:rc_inv_no, exact; number dwrent = if rcmain:rc_waiver=”Y” then cr_fixat:cr_extended_amt_net else 0; number nodwrent = if rcmain:rc_waiver=”N” then cr_fixat:cr_extended_amt_net else 0; date begdate = parameter/prompt=”Enter Beginning Date to Report” date enddate = parameter/prompt=”Enter Ending Date to Report” where cr_main:cr_trans_type=”C” and cr_main:cr_contract_closed=”Y” and cr_main:cr_in_due_date>=begdate […]

define file misdesc =  access cr_missc, set cr_missed_rental_code= cr_miss:cr_missed_rental_code, generic define file misname = access cr_missn, set cr_missn:cr_missed_rental_no=cr_miss:cr_missed_rental_no, set cr_missn:cr_nseq = cr_miss:cr_nseq, one to one, generic define date stdt = parameter/prompt = “Enter Starting Date” define date endt = parameter/prompt = “Enter Ending Date”   where cr_miss:cr_missed_date >= stdt and cr_miss:cr_missed_date <= endt list/nobanner/title = […]

Report Output Example: ****************************************************************************************************************************** define date indt = parameter prompt “Enter the Date to Begin Reporting” ; date endd = parameter prompt “Enter Ending Date to Report” ; define file crfialle1=access cr_fiall, set cr_Fiall:cr_transaction = cr_main:cr_transaction, set cr_ftrans_type = “E1”, one to one, generic –file alparam = access al_param, set al_param:al_location = cr_main:al_location, generic define […]