Knowledge base

–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 […]

May 21, 2020

 /*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

— UPDATED 12/6/16 to add initial purchase and last rental define number cutoffmos = parameter prompt “Enter number months not rented” valid if cutoffmos > 0 define date cutoff = date(str(dateadd(todaysdate,-1*cutoffmos,0),”MM/01/YYYY”)) define file firstpurch = access fa_purch, set rc_inv_no=fa_main:rc_inv_no, fa_ref_no=fa_main:fa_ref_no,    one to one, using first index, generic define file lastrent = access fa_hist, set […]

Report Output Example: ************************************************************** where cr_fixat:cr_trans_status = “P” list /nobanner/title= “OFF RENT, NOT CHECKED IN” cr_main:cr_contract cr_fixat:rc_inv_no