Knowledge base

define file categ = access sl_categ, set sl_category = sl_main:sl_category list/domain = “sl_main”/duplicates/title=”SALES ITEMS BY INCOME ACCOUNT”/nobanner  sl_main:sl_mfg_cat_no sl_name_t:sl_name sl_main:sl_category categ:sl_category_desc gl_acct sorted by sl_categ:gl_acct sl_main:sl_category

May 21, 2020

/*============================= DOCUMENTATION =============================== # Name: SL_SPEC # # # ALERT Easy*Pro ™ # Copyright by Interactive Management Systems, Inc # Use of this software is by license only, see license agreement for # conditions of useage. # # Overview: Cost of Goods Sold # # Domain File: CR_COGS # Ext Files: n/a # # #CHANGE […]

Report Output Example: ********************************************************************************************************** sum/nobanner/title = “# Closed Tickets by Location” cs_inv:units across cs_icreate_date/year/h=”Invoice Date” by al_location

Report Output Example: ******************************************************************************************************************************************** /*The following report shows the Number of TIckets and the Average Ticket Total for each AR customer who has does business with you in the last year:*/ where cs_inv:cs_icreate_date>=todaysdate-365 and cs_main:cs_type_code= “AR” and cs_ytd_sales> 0 sum/domain=”cs_inv”/nobanner/title= “AVE TICKET TOTAL FOR AR CUSTOMERS IN LAST 12 MONTHS” cs_inv:cs_iamount/heading=”TOTAL SALES” cs_iamount/average/heading=”AVERAGE SALE” cs_inv:units/heading=”NUMBER […]

Report Output Example: ********************************************************************************* /*The following report shows the average revenue generated by ticket by date by location:*/ define date begindt=parameter/prompt=”Enter beginning date : ” define date enddt = parameter/prompt=”Enter ending date : ” where cr_main:cr_in_due_date>=begindt and cr_in_due_date<=enddt sum/nobanner/title=”AVERAGE TICKET REVENUE BY DATE BY LOCATION”/domain=”cr_totls” cr_totls:units/heading=”#Tickets” cr_ticket_total/average/heading=”Average Ticket Total”/nototal across cr_main:al_location by cr_main:cr_in_due_date/heading=”Date”/mask=”mm-dd-yy”

define std_date open_beg_date = parameter/prompt=”Beginning for Open Date” define std_date open_end_date = parameter/prompt=”Ending for Open Date” define std_date req_beg_date = parameter/prompt=”Beginning for Req Date” define std_date req_end_date = parameter/prompt=”Ending for Req Date” define string l_vendor[6] = parameter/prompt=”Vendor or #A for all” define string l_status[2] = parameter/prompt=”Status (Req/OpenPO/Closed or #A for all)” define string sort_by[1] = […]

define file slpodet = access sl_podet,                       set sl_po_req_no = sl_pohdr:sl_po_req_no, one to many, generic  — STR 13066 define file slnamet = access sl_name_t, set sl_mfg_cat_no =                       slpodet:sl_mfg_cat_no, one to one, generic define std_date open_beg_date = parameter/prompt=”Beginning for Open Date” define std_date open_end_date = parameter/prompt=”Ending for Open Date” define std_date req_beg_date = parameter/prompt=”Beginning for […]

  define string serial = parameter/prompt = “Enter All or Part of Serial Number to Look Up” /uppercase where         wo_main:wo_ser_number contains serial list/nobanner/noreporttotals/domain=”wo_main”/pagelength=60/title=”Work Orders and Estimates by Serial #”   wo_main:cr_estimate/mask=”ZZZZZZZ9″/heading=”EST#”   wo_main:cr_contract/heading = “WO#”   wo_main:cs_key/mask=”ZZZZZ9″/heading=” CUST#”   cs_main:cs_name/duplicates/heading=” NAME”   wo_main:cr_open_date/width=8/heading=” ORD”     wo_main:rc_inv_no+”-“+fa_ref_no/heading=”    ITEM”   wo_main:wo_item_descr/heading=” DESC”   wo_main:wo_brand_model/heading=” […]

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

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