Knowledge base

Report to see who Sales Items are Committed for

From Glenn at Durant’s Tents and Events: This report showns when any open ticket has a specific sales item on it. define string mfg[20]=parameter/uppercase/prompt =     “Enter SL_MFG_CAT_NO “ define string loc = parameter/uppercase/prompt =     “Enter Location #A for All ” default “#A” where cr_main:cr_contract_closed <> “Y” and      (loc = “#A” or cr_main:al_location […]

May 21, 2020

Sales Item List with Barcode

— Sales Item List with Barcode define string num[20]=parameter/cls/line=10/prompt=”Enter the manufacturer number, #A for All”/uppercase define string categ[2]=parameter/cls/line=10/prompt=”Enter the Sales Item Category or #A for ALL”/uppercase define string loc[3]=parameter/cls/line=10/prompt=”Enter Location or #A for All”/uppercase define string sort_by[1] = parameter/line = 12/prompt = “Select a sort order: 1-Name/2-Catalog#/3-Category/4-Mfg, Name/5-Mfg, Catalog#/6- Cat, Name “ define string slmfgno[20] […]

Sales Quantity on Hand VS Quantity Sold

— The following report will show sales item available quantities and — sales of the same item in a selected period. define   date startdt = parameter/prompt=”Enter a starting date”   date enddt = parameter/prompt=”Enter an ending date”   string somenums[200] = parameter/prompt=”Enter a bunch of Cat #s seperated by commas”/uppercase;   where   ( […]

Parts Sold and On-Hand

The following report will show quantities of sales items on hand and the quantity sold at locations numbered ‘100’ and ‘200’.  (Note – you can change the location identifications and/or add more locations by editing the variables defined and listed) define date begdat = Parameter/prompt =”Enter Beginning Sale Month (MM/01/YYYY) “ define date enddat = […]

List of Work Orders for One Part

This report will give a list of Work Orders that a given Part has been used on. define string mfg_no[20]=parameter/prompt=”Sales Item Manufacturer’s Catalogue Number: “/uppercase define date begin_dt=parameter/prompt=”Beginning Sales Date: “ define date end_dt=parameter/prompt=” Ending Sales Date: ” define file csmain = access cs_main, set cs_key=wo_main:cs_key, generic where wo_parts:sl_mfg_cat_no=mfg_no and wo_main:cr_comp_date>=begin_dt and wo_main:cr_comp_date<=end_dt and cr_contract_closed= […]

Sales items with negative quantity

From Glenn at Duant’ Tents and Events: This report shows any sales item that has quantity on hand less than zero. define string loc[3]=parameter/cls/line=10/prompt=”Enter Location or #A for All”/uppercase define file slname = access sl_name_t,   set sl_name_t:sl_mfg_cat_no = sl_qtyoh:sl_mfg_cat_no, generic where sl_qtyoh:sl_qty_on_hand < 0 and        (trun(loc) = trun(sl_qtyoh:al_location) or  trun(loc)=”#A” ) list/nobanner/domain=”sl_qtyoh”  sl_qtyoh:al_location […]

Sales Items by Category List

define string groupno[2]=parameter/prompt=”Enter Category to Report”/uppercase where sl_main:sl_category=groupno list/domain=”sl_main”/title=”SALES ITEMS BY CATEGORY”/nobanner sl_main:sl_category/noduplicates sl_mfg_cat_no sl_name_t:sl_name sl_main:sl_for_sale sl_type

List Sales Items by Income GL Account

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

Cost of Goods Sold Analysis with customer name added

/*============================= 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 […]

Count of Closed Tickets by Year by Location

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