ERROR

Maalesef, elimizden gelenin en iyisini yaptığımız halde: bir hata oluştu
Typedatabase
MessageYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categorie..." at line 5
QuerySELECT (SELECT categories_id FROM categories_description WHERE language_id = 12 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 12 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 12 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 12 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 12 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 12 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 12 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 12 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url, (SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt, (SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt

Jane Kelly 
Sage One For Dummies [PDF ebook] 

Support

Get to grips with Sage One in simple steps.
Sage One For Dummies explains every aspect of setting up
and navigating Sage One, the newest accounting solution for small
businesses and sole traders. It includes clear instructions for
using Sage One Accounts including setting up customer and supplier
records, creating invoices, paying customers and suppliers, bank
reconciliation, VAT returns and reporting. It also explains how to
use the Cashbook function (if your business is more cash-based) and
how to work with your accountant using the Accountant Edition.
Packed with step-by-step instructions and fully illustrated with
screenshots, this book is the easiest way to get the most from Sage
One and take control of your business finances.
* Shows readers how to set up, install and navigate using dummy
data
* Features setting up customer & supplier records
* Details how to create invoices for customers and suppliers
* Enables the reader to produce their own reports

€14.99
payment methods

Table of Content

Introduction 1
Part I: Setting Up and Registering Sage One 7
Chapter 1: Introducing Sage One 9
Chapter 2: Sorting Out Your Settings 29
Chapter 3: Keeping in Contact: Setting up Your Records 43
Chapter 4: Recording Your Opening Balances 57
Part II: Using Sage One Accounts 73
Chapter 5: Entering Invoices for Customers and Suppliers 75
Chapter 6: Recording Payments from Customers and to Suppliers 93
Chapter 7: Banking on Your Bank Accounts 109
Chapter 8: Running Your VAT Return 135
Chapter 9: Preparing Reports 145
Part III: Introducing Sage One Cashbook 153
Chapter 10: Setting Up Your Sage One Cashbook 155
Chapter 11: Entering Data into Your Cashbook 165
Part IV: Working with an Accountant 195
Chapter 12: When the Going Gets Tough: Calling an Accountant 197
Chapter 13: Collaborating with Sage One Accountant Edition 207
Part V: The Part of Tens 215
Chapter 14: Ten Top Troubleshooting Tips 217
Chapter 15: Ten Ways to Run Your Accounts System Effectively 221
Appendix: Glossary 227
Index 231

About the author

Jane Kelly is a Chartered Management Accountant, Sage Trainer and the author of Sage 50 Accounts For Dummies.

Buy this ebook and get 1 more FREE!
Language English ● Format PDF ● Pages 256 ● ISBN 9781119953753 ● File size 24.0 MB ● Publisher John Wiley & Sons ● Published 2011 ● Edition 1 ● Downloadable 24 months ● Currency EUR ● ID 2357654 ● Copy protection Adobe DRM
Requires a DRM capable ebook reader

More ebooks from the same author(s) / Editor

1,806 Ebooks in this category