Contents

Accredo  Accredo Backup & Restore  Contact Accredo  Accredo Data Organisation  Typographical Conventions  Accredo Module Compatibility  Accredo Module Integration  Select System  Accredo File Locations  Accredo File Name Extensions  Acknowledgements  Copyright Notice  The Navigator  Accredo Main Window  Accounts Receivable  Inventory Control  Invoicing System  Order Entry  Accounts Payable  Purchase Orders  Cash Book  Fixed Assets  General Ledger  Job Costing  Special Pricing  Purchase Pricing  Company  Goods and Services Tax  Foreign Exchange  Global Tools  Sales Analysis  Purchase Analysis  Job Analysis  Scripts & Scripting  MaxBasic  Web Service  Accredo Mobile Applications  Automation  Table Designer  Data Interchange  SQL Query Builder  SQL Overview     SQL Clauses     SQL Functions        SQL Aggregate Functions        SQL Application Functions        SQL Case Functions        SQL Cast Function        SQL Date Functions        SQL Environment Functions        SQL Foreign Exchange Functions        SQL GST Functions        SQL Number Functions        SQL Period Functions           AddPeriod - SQL Function           CurrentPeriod - SQL Function           DateWithinPeriod - SQL Function           FirstAvailablePeriod - SQL Function           FirstInYear - SQL Function           FirstPeriod - SQL Function           FirstUserPeriod - SQL Function           LastAvailablePeriod - SQL Function           LastInYear - SQL Function           LastPeriod - SQL Function           LastUserPeriod - SQL Function           MakePeriodID - SQL Function           PeriodEndDate - SQL Function           PeriodForDate - SQL Function           PeriodName - SQL Function           PeriodPeriodNo - SQL Function           PeriodStartDate - SQL Function           PeriodYearNo - SQL Function           SystemPeriod - SQL Function           YearName - SQL Function        SQL String Functions     SQL Operators     SQL Reserved Words  Memory Table Builder  Report Designer  Form Designer  Periodic Tasks  Accredo Keyboard Shortcuts  Tutorials  Troubleshooting  Accredo Installation  Glossary of Terms  Index