IBM Server Site

IBS Home Up

Pre-Defined Queries

Access to IBS/IBM Queries

  • Go to menu RR, RI, MR or MI then
  • select option 20 (Query Menu)
  • Select option 12 (Work with queries)
  • Tab down to query then press F4 (for listing)

Please note that if this is your 1st time accessing query you may need to also type #QUERY in the library line

ALEASHJ
ALPHAVEND LOOKUP SKU# BY CAT & Vendor
APVEND VENDOR LISTING W/CATAGORY
APVEN2 Vendor Listinb Sorted by Vendor Product #
AR_RECEIPT AR Receipts by Last Payment Date
ARBALBYLOC
ARBMAST A/R Balances by highest owed with phone numb
ARBYLOC A/R Balance by Location
ARGT1000 A/R Sales Greater Than $1,000
ARGT5000 A/R Sales Greater Than $5,000
ARLT1000 A/R Sales Less Than $1,000
ARMAILLBL A/R LABLES FOR MAILING
ARMSTBYJOB A/R Query Combining all Jobs "SUBSTR"
ARSALES A/R Sales Ranked by YTD Gross Profit
ARTOGL ibs gl info per mouth
ARTOTAL A/R Sales Ranked by YTD Gross Profit
ARTR Accounting Transaction Report from ARTR file
AR2000 A/R Sales Greater Than $1,000
AUDIT
BACKORDERS QUERY TO FIND BACKORDERS
BANKORD Query for finding Bank Orders
CASHRETURN
CHCARMST Coleman Home Center A/R File
CHGTOCASH Charge Sales Changed to Cash Sales Report
CHKAPVEN
CHKARMST
CHKARSEQ Temporary to check ARSEQ Number
CHKARTR Accounting Transaction Report from ARTR file
CHKCATCHG
CHKCATGY
CHKCCWRK Variance report for ccwrk and ccivmst file
CHKCMISH
CHKCOUNT
CHKCSALH
CHKGLD
CHKGLDET
CHKGLHOLD
CHKGLM
CHKINVVAL
CHKIVAHS
CHKIVAHS01
CHKIVMHS
CHKIVMST
CHKIVMSTA
CHKMIRPF
CHKMI2
CHKOPITM
CHKORDHDR
CHKORDITM
CHKORDITM2
CHKPADET
CHKPAYHS payment history report
CHKPHYCNT
CHKPOHDR
CHKPOITM
CHKQTHDR
CHKQUOTED
CHKREG
CHKTAX
CKIVAHS
CLASSCD03 C.O.D. Sales by Account
CODE03SLS Lowville Code Sales 3 Customer Sales
CODE03SLSX Lowville Code Sales 3 Customer Sales
CODE3SLS Lowville Code 3 Combined Sales
COMMEQCASH Cash Customer - Commission
COMMISSION
COPYARTR
COSTGTSELL cost greater than selling price
COUNT Count Sheets for Inventory
CSHDRWR Cash Drawer Reconcile from cdwr02cl
CTG99V2 Categroy 99 SKU's
CUSTBAL customer balances - collection dates
CUSTSALES Sales by Customer by Date
CUSTSLSHST Customer Sales History by SKU
CYLCTVAR02 Cycle Count Variance Prior to Posing Listing
DAILYSALES
DEADINV Dead Inventory - No Sales YTD
DELSKU Deleted SKU's by SKU #
DISCOUNT discount customers
DLRSALES
DLRSALESAP
EASTJOB
EDITTICK Open Ticket Report/Inquiry
ENTERPRISE Enterprise file transfer of selected categor
ESTFILE
FAXLIST Import from A/R file for Fax
FINDSKU Find SKU on Orders by Customer
GLDETAIL G/L Detail by Account and/or by Date
HIST0 history detail = 0 do not save
IBSCUSTLST IBS Active Customer List
IBSPAYHS payment history report
INACTIVE A/R Accounts Marked Inactive
INACTIVERP A/R Accounts Marked Inactive (Printed)
INVAUDIT
INVBYVEND Inventory Listing by Vendor
INVMOHST Monthly History with Suggested Order
INVMTD Month to Date Inventory Sales by Product
INVREC
INVSALES Inventory Sales by Product
INVYTD Year To Date Inventory Sales by Product
ISGT1000 Inventory Sales YTD Greater Than or Equal 10
ISGT5000 Inventory Sales YTD Greater Than or Equal 50
ISLT1000 Inventory Sales YTD Less Than or Equal 1000
ITMCUST Item by Customer Number
IVMHS
KNLBYCUST Sales by Customer - Cost Code LT '2'
LOCSALES Sales by Workstation
LOWSALES Low/No Sales Year To Date
MINORDER Monthly History with Suggested Order
NDFSTAX North Dakota Fuel Service Charge
NONTAXSLS Listing of Non-Taxable Sales by Date Range
NOPAYMENTS Payment History
NTDISC
ONORDER Display SKU's with qty. on order
ORDGE2500 Orders $2,500 or over
ORDHDR Listing of Account Charges
ORDHDRITM Combine Order header and Order item
ORDHDR99 Listing of tickets with cost greater than sa
ORDTOTAL Sales Totals - Monthly HPOST LT-3 & Date Ran
PAYHIST Payment History
PAYHISTORY

POBYCATGY

POSALES
PRICEBOOK Contractor Price Book
PRICELEVEL
QRYARTR
QUOTE Quote Query by Salesman
REOPOINT Find zero reorder points or qty
REORDER Inventory Stock Alert/Reorder Report
REPAIR
RI_ACTIVE Active A/R Accounts
SALESBYCAT Sales by Location
SALESBYCTG
SALESBYLOC Sales by Location
SALESBYSMN Sales by Assigned Salesman
SALESORDER sales by month/date report
SALES0203 Sales 2002 thur June
SHEETROCK
SHOWSALES Market Order Sales
SHOWSLS Market Order Sales
SKU$$GT01 $$ SKU Unit of Measure and cost G/T .01
SKUSALES
SKU99SALES Special Order '99' Sales
SLSBYCUST Sales by Customer - Cost Code LT '2'
SLSBYCUSTP Sales/Profit by Customer - Total Tickets
SLSBYCUST3 Sales by Customer - Cost Code GT '2'
SLSBYVEND
SLSCOST
SLSMNBYDTE Home Supply Sales by Year
SLSMTDYTD customer balances - collection dates
STMTFILE
TAXBYSKU
TAXREPORT Tax Report with Date Selection
TEMPIVAHS
TEST01
TKTDETAIL Ticket Detail Inqyiry by Ticket Number
TKTTIME
VENDORLBL Vendor Mailing Labels
YEARLYSLS
ZEROCST SKU's With Zero Cost

IBS Lumber and Building Material Software Copyright © 2006 IBS Lumber Software Inc (TM)
Last modified: November 7, 2011

IBS Sales & Support 888-640-1252
Main Office 888-640-1252
Fax IBS 877-712-8937

All pages contained in this support website are not intended for general public distribution. Any material here can be considered private, confidential with various copyrights and restrictions against public release. You 'the browser' cannot legally release this information for general public distribution.

remote support: http://www.gotomeeting.com | remote support download program