Knowledge base

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

May 21, 2020

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

/*This report finds sales serial numbers that show as committed to a ticket, but that ticket is either still open or has been switched back to a reservation/estimate or deleted.*/ define string ttype=if cr_main:cr_transaction=sl_seril:cr_transaction then cr_main:cr_trans_type else if wo_main:cr_transaction=sl_seril:cr_transaction then wo_main:cr_trans_type else ” “ Define number ticketno = if cr_main:cr_transaction=sl_seril:cr_transaction and cr_main:cr_trans_type=”C” then cr_main:cr_contract else […]

–This report will show the last time and item was sold or used on a customer —WO under sold, and the last time it was on an internal repair 06/22/12 — Updated to include Mfg Name 01/05/23   define number cutoffmos = parameter prompt “Enter number months not sold” valid if cutoffmos > 0 define […]