Our knowledge-base contains content and resources to help you make the most out of your software. You need to be logged in to view this content.
Not registered, yet? Register for access.
Knowledge base
Page 82 of 86
Tickets by Business Type
–Tickets by Customer Business Type define file param = access al_param, set al_location = cr_main:al_location define file cust = access cs_main, set cs_key = cr_main:cs_key define file name= access rc_name, set rc_name:rc_inv_no = cr_fixat:rc_inv_no, generic define file crtotls = access cr_totls, set cr_totls:cr_transaction = cr_main:cr_transaction, generic define file slname= access sl_name, set sl_name:sl_mfg_cat_no =cr_sales:sl_mfg_cat_no, generic […]
May 21, 2020
Tickets with inactive Rental Items
define date begindt = parameter/prompt=”Enter Beginning Date “; define date enddt = parameter/prompt=”Enter End Date”; define file famain= access fa_main, set fa_main:rc_inv_no = cr_fixat:rc_inv_no, set fa_main:fa_ref_no = cr_fixat:fa_ref_no, generic where cr_main:cr_contract_closed = “N” and cr_main:cr_out_date >=begindt and cr_main:cr_out_date<= enddt and famain:fa_status = “IA” list /domain=”cr_fixat”/nobanner/title = “Inactive Items on […]
Sales Items on Open Tickets by Customer
define number key2 = parameter prompt “Enter Customer Key to Report” ; where ( cr_main:cr_trans_type <> “D” ) and ( cr_contract_closed = “N” ) and ( cs_key = key2 ) list/domain=”cr_sales”/nobanner/title=”Sales Items on Open Tickets by Customer” cr_main:cr_transaction/heading =”BID” cr_main:cr_contract cr_main:al_location cr_sales:sl_mfg_cat_no/heading=”MFG-CAT NO” […]
Contracts by Whole or Partial Job Name
Report Output Example: ********************************************************************************************************* /*========DOCUMENTATION=============* Name: CR_OPENC Overview: Reports Open Contract Domain File: Ext Files: CHANGE HISTORY Author Date Comment ——————- ——– ————————————– Jean-Pierre Chastagnol 29 Nov 93 Ian Dudley 03/10/05 STR 40215 suppress display only notes Susan Russo 02/15/08 Added Ticket total NC1 08/31/12 Custom to pull by job # *==============END OF DOCUMENTATION============*/ define […]
Counter Activity Report
Report Output Example: ****************************************************************************************************************** /*The following report shows counter ticket activitiy in cronological order over a given date range for a given employee:*/ define date begindt=parameter/prompt=”Enter Beginning Date to Report ” define date enddt = parameter/prompt=”Enter Ending Date to Report ” define string inits[3]=parameter/prompt=”Enter Employee Initials to Report (#A = All)”/uppercase define number tckt = […]
Substitute Names Used on Tickets by RC – version2
— list version (for items like a NOTE where it could be anything) define string which_rc = parameter/uppercase prompt “Enter an RC #” define date begdate = parameter/prompt=”Enter beginning date “ define date enddate = parameter/prompt=”Enter ending date “ define file crfrlck = access cr_frlck, set cr_transaction=cr_fixat:cr_transaction, cr_item=cr_fixat:fa_key, cr_item_id=cr_fixat:cr_item_id, generic where […]
Closed Contracts Report with Detail-Versions 16 and up
Report Output Example: ********************************************************************************************************* define file name= access rc_name, set rc_name:rc_inv_no = cr_fixat:rc_inv_no, generic define file crtotls = access cr_totls, set cr_totls:cr_transaction = cr_main:cr_transaction, generic define file slname= access sl_name, set sl_name:sl_mfg_cat_no = cr_sales:sl_mfg_cat_no, generic define file param = access al_param, set al_location = cr_main:al_location define file cust = […]
Substitute Names Used on Tickets By RC – version1
— sum version (for items like a MISC INFLATABLE where it is — more than likely one of a handful) define string which_rc = parameter/uppercase prompt “Enter an RC #” define date begdate = parameter/prompt=”Enter beginning date “ define date enddate = parameter/prompt=”Enter ending date “ define file crfrlck = access cr_frlck, set cr_transaction=cr_fixat:cr_transaction, […]
converted web request
Report Output Example: ****************************************************************************************************************************************************************************** /* List of web request that have been converted to tickets with ticket totals by date */ define file crmain1 = access cr_main, set cr_transaction = cr_web:cr_transaction, one to one file crtotls1= access cr_totls, set cr_transaction= cr_web:cr_transaction, one to one std_date begdate=parameter/prompt=”Enter Beginning Date to Report ” std_date enddate=parameter/prompt=”Enter Ending Date […]
Tickets by whole or partial job name/po/venue
define file param = access al_param, set al_location = cr_main:al_location define file cust = access cs_main, set cs_key = cr_main:cs_key define file name= access rc_name, set rc_name:rc_inv_no = cr_fixat:rc_inv_no, generic define file crtotls = access cr_totls, set cr_totls:cr_transaction = cr_main:cr_transaction, generic define file slname= access sl_name, set sl_name:sl_mfg_cat_no = cr_sales:sl_mfg_cat_no, generic define string Loc[3] = parameter/cls/line = […]
Page 82 of 86
