Knowledge base

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

May 21, 2020

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.”

list/nobanner/title = “Codes Setup Vendor List” fs_vendor:fs_vendor /heading = “#” fs_vendor_desc /heading = “Vendor” fs_vendor_address_1 /heading = “Address 1” fs_vendor_address_2 /heading = “Address 2” fs_vendor_address_3 /heading = “Address 3” fs_vendor_phone /heading = “Phone” fs_vendor_fax/heading = “Fax” fs_markup /heading = “% Markup *” fs_vendor_email_address /heading = “Email” fs_vendor_contact /heading = “Contact” fs_customer_id /heading = “Customer ID” […]

–This report is for Alert version 14 and before. list /nobanner/title = “Codes Setup Global Misc – V14 and previous”/dup al_uinit:al_init/heading = “INIT” al_init_desc/heading = “NAME” al_employee_no/heading = “EMP#” al_tc_emp_pswd /heading = “PW” al_tc_project /heading = “PROJ” al_init_type /heading = “MGR-REG” al_tc_ssn/heading = “SSN-EMPCD” al_tc_active /heading = “ACTV” al_tc_in_out /heading = “TC-STAT” al_tc_entry_req /heading = […]