Knowledge base

define file warcust = access cs_main, set cs_main:cs_key = wo_main:warranty_key, generic file warinv = access cs_inv, set cs_inv:cs_key = wo_main:warranty_key, set cs_inv:cs_invoice =wo_main:cr_contract, one to one, generic   where   ( wo_main:cr_contract_closed = “Y” ) and    (wo_type:work_under_warranty_flag = “Y” )  and (warinv:cs_iamount <> warinv:cs_ipaid)   list/domain=”wo_main”/noreporttotals   wo_main:cr_contract/heading=”WO#”   wo_main:al_location   warcust:cs_name/heading =”WARRANTOR”   […]

May 21, 2020

define std_date open_beg_date = parameter/prompt=”Beginning for Open Date” define std_date open_end_date = parameter/prompt=”Ending for Open Date” where ( sl_pohdr:sl_po_status = “C”)and ( sl_pohdr:sl_po_open_date >= open_beg_date and sl_po_open_date <= open_end_date) sum /nobanner/title=”Vendor Summary Report for Closed POs”/noheadings sl_pohdr:sl_po_amount_approved by fs_vendor:fs_vendor_desc/heading=”Vendor”/duplicates sl_pohdr:al_location/heading=”Loc” Report Output Example

define date begindt = parameter/prompt = “Enter Begining Date to Report” default todaysdate -1; date enddt = parameter/prompt = “Enter Ending Date to Report” where     begindt <= wo_main:cr_comp_date and   enddt >= wo_main:cr_comp_date and   wo_main:cr_contract_closed = “Y” and   cr_finpy:cr_pay_type one of “AR”, “FC” list/domain = “WO_main”/nobanner/title=”WO Invoiced in Date Range with Prefered Customer Contact Info” wo_main:cr_comp_date/width=8/heading […]

For customers that have bought RenTrain that will allow them to easily see if an item has a PID. This report can be run for a selected rental class or all.  It can then show all items, only those without any kind of PID or only those that have a PID.  define   string rcoral[ 4 […]

define string wo_loc = parameter/uppercase default “#A” ; where ( wo_main:cr_contract_closed <> “Y” ) and ( fa_key <> “” ) and ( al_location = wo_loc or wo_loc = “#A” ) list/domain=”wo_main”/nobanner/title=”OPEN WORK ORDERS WITH OPEN DAYS” wo_main:cr_contract/heading=”WORK-ORDER#” wo_main:al_location wo_main:fa_key wo_main:wo_item_descr todaysdate-(wo_main:cr_open_date)/heading=”DAYS” sorted by todaysdate-(wo_main:cr_open_date)/descending

list/nobanner /title = “Codes Setup Tax Areas” st_rate:st_tax_area st_description st_rent_rate/heading = “RENT” st_sale_rate/heading = “SALES” st_dw_rate/heading = “DW” st_sme_rate/heading = “SME” st_labor_rate/heading = “LABOR” st_ec1_rate/heading = “EC1” st_ec2_rate/heading = “EC2” sorted by st_rate:st_tax_area end of page “”/newline =3″Found in Codes Setup>Tax Codes>Tax Areas Tab.”

list/nobanner/title=”SALES TAX RATES” st_rate:st_tax_area st_rate:st_description st_rate:st_rent_rate st_rate:st_sale_rate st_rate:st_dw_rate st_rate:st_sme_rate st_labor_rate/heading=”LABOR-RATE” st_rate:st_ec1_rate/heading=”EC1-RATE” st_rate:st_ec2_rate/heading=”EC2-RATE” st_rate:st_tax_pa_cents/heading=”USE-PA-CENTS” st_rate:st_tax_county_max/heading=”USE-COUNTY-MAX” st_rate:st_tax_canada_gst_pst/heading=”USE-CANADA-GST/PST” sorted by st_tax_area

list/nobanner/title=”Easy*PRO Users List” al_init/heading=”User-Initials” al_init_desc/heading=”User-Name” al_employee_no/heading=”Emp#” al_tc_emp_pswd/heading=”Timecd-Passwd” al_tc_project/heading=”Timecd-Proj” al_init_type/heading=”Mgr/-Reg”   al_tc_ssn/heading=”SSN Code” al_uinit:al_tc_active/heading=”Active?”   al_tc_entry_req/heading=”Timecd-Reqrd?” al_uinit:al_delete_cc_special_fn/heading=”Delete-Credit-Cards?” al_uinit:al_tax_changes_special_fn/heading=”Change-Tax-Info?”   al_uinit:al_change_customer_special_fn/heading=”Change-Cust-Web?” al_mgr_hrddwn_ovr_rd_special_fn/heading=”Override-HardDown?” al_bad_guy_special_fn/heading=”Approve-BadGuy?” al_disable_taxinfo_special_fn/heading=”Ticket-to-NonTax?” al_override_crdt_lmt_special_fn/heading=”Approve-Over-Credit-Limit?” al_reopen_ticket_wo_special_fn/heading=”Reopen-Old-Tickets?” al_fin_trans_special_fn/heading=”Cancel-Fin-Chgs?” al_change_customer_special_fn/heading=”Clear-Cust-w/$$?” al_user_email/heading=”Email Address?” sorted by al_tc_active/descending/newline al_init

Report Output Example: ************************************************************************************************************************************************************************* define file slmain = access sl_main, set sl_main:sl_mfg_cat_no=cr_darea:cr_del_area, generic list/nobanner/title = “Codes Setup Delivery Labor Codes”/duplicates/nototals/domain = “cr_darea” cr_darea:cr_del_area cr_del_description cr_del_rate cr_mon_del_spec cr_tue_del_spec cr_wed_del_spec cr_thu_del_spec cr_fri_del_spec cr_sat_del_spec cr_sun_del_spec cr_mon_del_am cr_tue_del_am cr_wed_del_am cr_thu_del_am cr_fri_del_am cr_sat_del_am cr_sun_del_am cr_mon_del_pm cr_tue_del_pm cr_wed_del_pm cr_thu_del_pm cr_fri_del_pm cr_sat_del_pm slmain:sl_tax_status end of page “”/newline =3 “Found in Codes Setup>Party […]

list/nobanner/title = “Codes Setup Sales Categories”/dup sl_categ:sl_category sl_category_desc/heading = “Description” gl_acct/heading = “GL Account” cogs_gl_acct inv_gl_acct priority al_dept_code/heading = “Department” sorted by sl_categ:sl_category end of page “”/newline =3 “Found in Codes Setup>Sales Items>Sales Categories Tab.”