Knowledge base

Report Output Example: *************************************************************************************************** define number ticket_num = switch(cr_main:cr_trans_type) case “C” : cr_main:cr_contract case “R” : cr_main:cr_reservation default  : cr_main:cr_transaction; where cr_main:cr_contract_closed = “N” and cr_main:al_location <> fa_main:al_location and fa_main:fa_type = “I” list/duplicates/title=”Equipment On-Rent at a Store Other than its ‘Current’ Location”/domain=”cr_fixat” cr_main:cr_trans_type ticket_num/nototal cr_fixat:rc_inv_no cr_fixat:fa_ref_no fa_main:fa_name fa_main:al_location/heading=”FA-CURRENT-LOCATION” cr_main:al_location/heading=”TICKET-LOCATION” sorted by cr_fixat:rc_inv_no cr_fixat:fa_ref_no

May 21, 2020

Report Output Example: *********************************************************************************************************** /*The following report will list the maintenance history for a single Fixed Asset*/ define string famntnote = parameter prompt “Enter FA Key (8-digits, no dashes) ” ; where ( wo_main:fa_key = famntnote ) list/domain=”wo_main”/nobanner/title=”EQUIPMENT MAINTENCE HISTORY” fa_main:fa_key/noduplicates fa_name fa_serial_no wo_main:cr_contract/heading=”MAINT-TICKET” wo_main:cr_comp_date/mask=”MM/DD/YY”/heading=”DATE” wo_type:work_type/dup fa_wktyc:work_type_description/dup sorted by wo_main:cr_comp_date cr_contract

Report Output Example: ***************************************************************************************************** define file maint_code = access fa_mncod, set fa_mncod:fa_maint_type_code = fa_maint:fa_maint_type_code; string sold_key = parameter prompt “ENTER FIXED ASSET KEY NUMBER (xxxxxxxx) ” ; where ( fa_main:fa_key = sold_key ) list/nototals/duplicates/domain=”fa_main”/nobanner/pagelength=80/title=”DETAILED ASSET REPORT” fa_main:fr_group/heading=”GR” fa_main:fa_key/heading=”ITEM” fa_main:fa_name/noheading fa_main:fs_vendor/heading=”VENDOR” fa_main:fs_manufacturer/heading=”MFG” fa_main:fa_catalog_no/heading=”MFG CAT #” fa_main:fa_model_no/heading=”MODEL” fa_main:fa_serial_no/heading=”SERIAL #”/newline=2 “MTD RENTS” fa_main:fa_mtd_util/noheading/column=15 “EARNINGS”/column=28 fa_main:fa_mtd_earnings/noheading/column=35/newline “YTD RENTS” fa_main:fa_ytd_util/noheading/column=15 […]

define file crmain=access cr_main, set cr_contract=fa_main:cr_contract_on_rent, generic define file csmain=access cs_main, set cs_key=crmain:cs_key, generic define string stat[3]= if fa_main:cr_contract_on_rent>0 then “OUT” else “IN” where fa_main:fa_type=”I” and fa_status one of “CU”,”DM” list/nobanner/domain=”fa_main”/title=”CURRENT INDIVIDUAL ASSETS BY LOCATION” fa_main:al_location fa_key/heading=”ASSET” fa_name fa_purch:fa_purch_amt/heading=”PURCHASE-PRICE” fa_main:fa_status/heading=”CURRENT-STATUS” stat/heading=”IN-OUT” if stat=”OUT” then { fa_main:cr_contract_on_rent/heading=”CONTRACT” csmain:cs_name/heading=”CUSTOMER NAME” crmain:cr_job_name, cr_job_address, cr_job_city } sorted by fa_main:al_location/newpage/total/heading=”LOCATION” […]

–#Sales Purchasing Analysis report that shows  –#on-hand quantities, costs, reorder info –# and monthly sales from this and last year define string num[20]=parameter/cls/line=10/prompt=”Enter the manufacturer number, ALL for all”/uppercase default “ALL” define string categ[3]=parameter/cls/line=10/prompt=”Enter the Sales Item Category or ALL for all”/uppercase default “ALL” define string loc[3]= parameter/cls/line=10/prompt=”Enter Location or #A for All”/uppercase default “100”; […]

define  string srlocation = parameter /prompt=”Enter the location or #A for all or NA for blank”/uppercase  string sold = parameter /prompt=”Include Sold Items Y/N”/uppercase Valid(“Y”),(“N”)where  (sl_seril:al_location = srlocation or srlocation = “#A”  or (srlocation = “NA” and sl_seril:al_location = “”))  and(sold = “Y” or (sold=”N” and sl_seril:sl_sold_date =00.00.00))list/nobanner/domain=”sl_seril”  sl_seril:sl_mfg_cat_no sl_acq_date sl_acq_cost sl_serial_number sl_sold_date cr_contract   –if […]

/* This report will list all sales items that are assigned to a non-existent category */ find sl_main not with sl_main:sl_category = sl_categ:sl_category list/nobanner/title=”SALES ITEMS WITH DELETED CATEGORIES” sl_main:sl_mfg_cat_no sl_name_t:sl_name sl_main:sl_category sl_for_sale sl_type sorted by sl_mfg_cat_no

Report Output Example: ********************************************************************************************************************************************* /* The following report will give you Cost of Goods Sold values over a selected date range summarized by category.  It includes sales and work orders. */ define file acq = access sl_acost, set sl_acost:sl_mfg_cat_no = cr_cogs:sl_mfg_cat_no, generic define file slmain = access sl_main, set sl_mfg_cat_no=cr_cogs:sl_mfg_cat_no, generic define file slcateg = […]

list/nobanner/title = “Taxable and Non-Taxable Sales Items” sl_main:sl_category sl_mfg_cat_no sl_name_t:sl_name sl_main:sl_tax_status sl_for_sale sorted by sl_main:sl_category /newlines = 2 sl_main:sl_tax_status /newline sl_for_sale Report Output Example

define   string loc = parameter/prompt=”Enter Location (or #A for All)” ;   std_date start_dt = parameter prompt “Enter Starting Out Date” ;   std_date end_dt = parameter prompt “Enter Ending Out Date” ;   string del_will = parameter/uppercase valid “D”,”W”,”B” prompt   “(D)eliver? (W)ill Call? (B)oth” default “B”;   string del_will2 = switch(cr_main:cr_delivery) case […]