Knowledge base

where sl_qtyoh:sl_qty_committed>sl_qty_on_hand and sl_qty_committed>0 list/nobanner/domain=”sl_qtyoh”/title=”OVERCOMMITTED SALES ITEMS” sl_qtyoh:sl_mfg_cat_no sl_name_t:sl_name sl_qtyoh:sl_qty_on_hand/nototal sl_qty_committed/nototal fs_manufacturer fs_vendor sorted by sl_mfg_cat_no

May 21, 2020

define string ttype[1]=parameter/prompt=”Report [R]eservations, [C]ontracts, [B]ids, or [A]ll?”/uppercase valid “R”,”C”,”B”,”A” define string futr[1]=parameter/prompt=”Only include [U}pcoming orders or     include [C]urrent orders as well?”/uppercase valid “U”,”C”define number ticktno=if cr_main:cr_trans_type=”C” then cr_contract else   if cr_main:cr_trans_type=”R” then cr_reservation else cr_transaction where (cr_main:cr_trans_type=ttype or ttype=”A”) and   (futr=”C” or cr_main:cr_out_date>=todaysdate) and     cr_sales:cr_transaction=cr_main:cr_transaction and   cr_main:cr_contract_closed=”Y” list/domain=”cr_sales”/nobanner/title=”ORDERS WITH SALES […]

Report Output Example: ********************************************************************************************************** /*The following report lists AR customers who have not done any business with you in the last year:*/ where cs_main:cs_type_code= “AR” and cs_last_cont_date < todaysdate-365 list/nobanner/title=”AR CUSTOMERS WITH NO ACTIVITY IN THE LAST YEAR” cs_main:cs_key cs_name cs_address_1 cs_city al_st_code al_zipcode cs_last_cont_date cs_contact cs_phone_1 sorted by cs_main:cs_name

Report Output Example: ********************************************************************************************************** define std_date begdate = parameter/prompt=”Enter Reginning Reservation Date to Include” default todaysdate; define std_date enddate = parameter/prompt=”Enter Ending Reservation Date to Include” default todaysdate + 14; define file ocrmain = access cr_main, set cr_contract = fa_main:cr_contract_on_rent, generic where cr_main:cr_trans_type=”R” and cr_main:al_location<> fa_main:al_location and fa_main:fa_type=”I” and cr_main:cr_out_date>=begdate and cr_main:cr_in_due_date<=enddate list/nobanner/domain=”cr_fixat”/title=”ASSETS AT WRONG […]

Multi-Group/Multi-Department Pull Report (Run for a specific ticket or date range, for Delivery/Will-Call or both, and by location) Ticket prompt works the same way as the Counter Ticket Screen. (valid examples: R1234567 or C12345678) Note: The prompts in this report will pre-populate information based on your previous prompt selections for ease of entry. ______________________________________________________________ Everything […]

Report Output Example: ************************************************************************************************************************************************************************ define number firstyr = parameter/prompt=”Enter first year of deliveries to include (i.e. 2015)”where cr_main:cr_trans_type=”C” and cr_contract_closed=”Y” and cr_delivery=”Y” and cr_job_city>”” and trun(cr_job_state)=”CO” and year(cr_in_due_date)>=firstyrsum/nobanner/domain=”cr_main”/title=”COLORADO DELIVERIES” cr_main:units/heading=”CONTRACTS” cr_totls:cr_ticket_total/heading=”DOLLAR-VALUE” across year(cr_main:cr_in_due_date)/descending by highest cr_job_city

Report Output Example: *************************************************************************************************** /* Provides “Event Summary” based on common jobname for a specificied customer or all */ define string job = parameter/uppercase prompt “Enter common job name (keyword)”; string ticket = cr_main:cr_trans_type+” “+str(cr_main:ticket_number); string cust_key = parameter prompt “Enter Key” default “#A”; number cust_key2 = val(cust_key); file csmain = access cs_main, set cs_main:cs_key […]