Knowledge base

define date begin_dt=parameter/prompt=”Beginning Sales Date: “ define date end_dt=parameter/prompt=” Ending Sales Date: “ define file alparam = access al_param, set al_location= wo_main:al_location , generic define string loc = parameter/prompt = “Enter Location” /uppercase where wo_main:al_location = loc and wo_main:cr_comp_date>=begin_dt and wo_main:cr_comp_date<=end_dt and cr_contract_closed= “Y” and wo_main:cs_key <> alparam:al_def_wo_cust sum/domain = “wo_parts”/nobanner/title=”Total of Parts Used on […]

May 21, 2020

Report Output Example: ******************************************************************************************************************************* –Finds Kits with earnings NOT posted to the Kit Header. define string loc[3]=parameter/prompt=”Enter the Location ID to check “/uppercase define file relrate = access rc_rate, set rc_inv_no=rc_reltd:rel_rc_inv_no, al_location=loc, rc_rate_type=”R”,   rc_rate_seq=0, generic define file relrcname = access rc_name_t, set rc_inv_no=rc_reltd:rel_rc_inv_no, generic where rc_main:rc_kit=”Y” and rc_assign_earning_to_header<>”Y” and rc_reltd:rel_rc_inv_no<>”” and rc_kit_related=”K” list/nobanner/domain=”rc_reltd”/title=”KITS THAT WANT TO […]

–Each of the kit parts needs to have a Daily Rate  –or Post earnings to kit header. define string loc[3]=parameter/prompt=”Enter the Location ID to check “/uppercase define file relrate = access rc_rate, set rc_inv_no=rc_reltd:rel_rc_inv_no, al_location=loc, rc_rate_type=”R”,    rc_rate_seq=0, generic define file relrcname = access rc_name_t, set rc_inv_no=rc_reltd:rel_rc_inv_no, generic where rc_main:rc_kit=”Y” and rc_assign_earning_to_header<>”Y”    and rc_reltd:rel_rc_inv_no<>”” and […]

 /*This report will allow you to print any saved rates in the rate increase work screen before committing them*/ list/nobanner/title = “Proposed New Rates” rc_rttmp:fr_group /heading = “GR” rc_inv_no /heading = “RC” rc_name_t:rc_name rc_rttmp:al_location /heading = “LOC” rc_rent_term /heading = “MIN-RENT-TERM” rc_min_rent /heading = “MIN-RENT-AMOUNT” rc_hour_1 /heading = “1HR” rc_hour_4  /heading = “4HR” rc_hour_8  /heading […]

FIXED ASSEST VALUATION LIST FOR INDIVIDUAL Items with Purchase Date Overview: Selects equipment based on these selection criteria: equipment name, equipment type=”I”, status, =============================================================================*/ define file alparam = access al_param, set al_param:al_location = fa_main:al_location, generic –define file fapurch = access fa_purch, set fa_purch:fa_key = fa_main:fa_key, one to many, generic define string num[4]=parameter/cls/prompt=”Enter the equipment number, […]

Report Output Example: **************************************************************************************************************************************************************************** /*NOTE:  Although any beginning and ending dates may be entered, all history records used in this report are dated the first of the month so the entire month’s history is dated the 1st*/ define date begdt=parameter/prompt=”Enter Beginning Date” define date enddt=parameter/prompt=”Enter Ending Date” define string loc[3]=parameter/prompt=”Enter Location to Report or ‘ALL’ […]

define string groupno[2]=parameter/prompt=”Enter Group to Report”/uppercase where rc_main:fr_group=groupno list/domain=”rc_main”/title=”RENTAL CLASSES BY GROUP”/nobanner rc_main:fr_group/noduplicates rc_inv_no rc_name_t:rc_name sorted by rc_main:rc_inv_no

list/nobanner/title=”RENTAL GROUPS LIST” fr_group:fr_group fr_group_desc gl_acct inv_gl_acct sorted by fr_group

Report Output Example: ************************************************************************************************** define number b_year[4] = parameter/prompt = “Enter Most Recent Year to Report” default year(todaysdate) – 1 number b_month[2] = parameter/prompt=”Enter the Starting Month # (1-12)” valid 01,02,03,04,05,06,07,08,09,10,11,12 default 01 number e_month[2] = parameter/prompt=”Enter the Ending Month # (1-12)” valid 01,02,03,04,05,06,07,08,09,10,11,12 default 12 std_date b_date = date(str(b_month) + “.01.” + str(b_year)) std_date […]

Report Output Example: ********************************************************************************************************* define file womain = access wo_main, set cr_transaction=fa_main:fa_work_order_transaction where fa_main:fa_type=”I” and fa_status one of “CU”,”DM” and al_location<>fa_base_location list/nobanner/title=”INDIVIDUAL ASSETS AWAY FROM THEIR HOME STORE” fa_main:fa_key fa_name[1,30] fa_status fa_main:al_location/heading=”CURRENT-LOCATION” fa_base_location/heading=”OWNING-LOCATION” fa_main:cr_contract_on_rent/heading=”CURRENT-CONTRACT”/nocommas/zerosuppress fa_main:cr_last_contract/heading=”PREVIOUS-CONTRACT”/nocommas/zerosuppress womain:cr_contract/heading=”ON WORK-ORDER”/nocommas/zerosuppress sorted by fa_main:al_location/newlines fa_base_location/newlines fa_key