Knowledge base

Detailed Rental Earnings by Group Report

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

May 21, 2020

Rental Classes by Group

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

Rental / Fixes Asset Group List

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

FA Earnings by Group – 5 Year Comparison

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

Assets no Longer at Home Base Location

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

Rental Items NOT Rented in Last X Months

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

Find Items Called Off Rent, but not Checked In

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

Replacement Cost and Selling Price of Rental Items

list/nobanner/title = “Replacement Cost/Selling Price for Rental Items” fa_main:fr_group fa_key fa_name fa_status fa_type al_location fa_replace_cost fa_selling_price sorted by fa_status/newlines fa_main:fr_group fa_name

Assets with Deleted Groups

Report Output Example: ****************************************************************** find fa_main not with fa_main:fr_group = fr_group:fr_group list/title = “Fixed Assets With Deleted Groups”/nobanner fa_main:rc_inv_no/heading = “RC#” fa_ref_no/heading = “FA#” fa_name:fa_name fa_main:fr_group

Fixed Asset Count Sheet

/*    – FIXED ASSEST COUNT SHEET Overview: Selects equipment based on these selection criteria: equipment name, equipment type, status, Change History: Author            Date                Comment Jessica Flint     Sept. 15, 1993 NC1 converted fa_slist into count sheet                                                           */ define string grvar[2]=parameter/cls/line=10/prompt=”Enter the group number, #A for All “/uppercase default “#A” define string rcvar[4]=parameter/cls/line=10/prompt=”Enter the rental class […]