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           Abs - SQL Function           AmountDecimals - SQL Function           CostPriceDecimals - SQL Function           Fix - SQL Function           Floor - SQL Function           FormatNumber - SQL Function           Margin - SQL Function           Markup - SQL Function           MaxNumber - SQL Function           MinNumber - SQL Function           Percent - SQL Function           PriceDecimals - SQL Function           QuantityDecimals - SQL Function           Ratio - SQL Function           Rnd - SQL Function           Round - SQL Function           RoundDown - SQL Function           RoundUp - SQL Function           SellPriceDecimals - SQL Function           Sgn - SQL Function           StringToNumber - SQL Function        SQL Period Functions        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