1 / 18

AgVantage Software’s Most Commonly Used Queries Lab - Part 2

AgVantage Software’s Most Commonly Used Queries Lab - Part 2. Presented by: Mike Smark AgVantage National Conference 2010.

summer-dean
Download Presentation

AgVantage Software’s Most Commonly Used Queries Lab - Part 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AgVantage Software’s Most Commonly Used Queries Lab - Part 2 Presented by: Mike Smark AgVantage National Conference 2010

  2. AGENDAMore “common” queries discussedHow to read and use File Structure DocumentsShare Queries – discuss central databaseHow to modify to your specific needs

  3. TerminologyLibraries, Files, Records and Fields I-Series – Stores information much like a file cabinet Libraries – AgVantage stores your information in a company library named CO*DATA where * is your company letter, number or a symbol. iSeries COUDATA COBDATA COSDATA

  4. Example • Library Co*data – Data library which contains all AgVantage files • Files U4CSTMR – Customer Master • Records Each individual customer’s information • Fields CSLKNM – Customer Lookup Name

  5. Query Libraries Recommendations: Create your own library for queries. CRTLIB command Use QRY at the end of the name. Ex. “COOP”QRY or SMARKQRY (own server) Most already have “base” Query Library ASP customers (Use company name/abbrev, then your name in description) Common AgVantage Query Libraries GRNQRYV65 (Version 7 not there yet) SYSQRYV6 (Version 7 not there yet)

  6. File Structures USYSTM AgVantage System Menu Select one of the following: 1. General Ledger GLS or U1 2. Accounts Payable U2 3. Payroll U3 4. Accounts Receivable U4 5. Grain Accounting U5 6. Agronomy U6 7. Energy Management U7 8. Inventory U8 9. Patronage U9 10. Mailing Manager UA 11. Counter Invoicing 12. Investments UI 13. Interfaces 14. Feed Selection or command F3=Exit F4=Prompt F9=Retrieve F12=Cancel

  7. Accounts Receivable U4CSTMR Customer Master U4ITMMR Item Master U4ITMBL Item Master Balance U4DEPT Department U4FLC Fine Line Code U4TRNH A/R Header Information U4TRND A/R Detail Information U4CAGE A/R Aging Information

  8. Grain U5CROPS Crop Information U5PCTRL Purchase Control/Contracts U5PLOAD Purchase Load Header File U5PLOADJN Purchase Load Header File Joined with Archive U5PSBLD Sub-Load Information U5SCTRL Sales Control/Contracts U5SETTLH Purchase Settlements Header U5SETTLD Purchase Settlements Detail U5SETTLDJN Purchase Settlements Detail Joined with Archive U5SARLD Sales Settlements SPECIAL NOTE: Library GRTRANx contains crop position and general ledger daily posting information

  9. RUNQRY (F4)Used to display the data in the fileUsed to run a specific query Type choices, press Enter. Query . . . . . . . . . . . . . Name, *NONE Library . . . . . . . . . . . *LIBL Name, *LIBL, *CURLIB Query file: File . . . . . . . . . . . . . Name, *SAME Library . . . . . . . . . . *LIBL Name, *RUNOPT, *LIBL, *CURLIB Member . . . . . . . . . . . . *FIRST Name, *RUNOPT, *FIRST, *LAST + for more values Report output type . . . . . . . *RUNOPT *RUNOPT, *DISPLAY... Output form . . . . . . . . . . *RUNOPT *RUNOPT, *DETAIL, *SUMMARY Record selection . . . . . . . . *NO *NO, *YES

  10. WRKQRYUsed to create, change, delete, display & run queries Let’s review more Queries ! Work with Queries Type choices, press Enter. Option . . . . . . 2 1=Create, 2=Change, 3=Copy,4=Delete 5=Display, 6=Print definition 8=Run in batch, 9=Run Query . . . . . . . Name, F4 for list Library . . . . . SMARKQRY Name, *LIBL, F4 for list

  11. QUERIES TO SHARE ? • VIA AgVantage MESSAGE BOARD (Track updates, User interaction) • VIA AgVantage WIKI BOARD (Similar to Message Board) • MAINTAIN ON AGVANTAGE SERVER (Own Library CUSTV65QRY, Need Administrator)

  12. THANKS FOR ATTENDING ! • PLEASE FILL OUT YOUR EVALUATION FORM !

More Related