Skip to content
Sage 1000 Excelerator V1 Help
Changes from November 2010
Initializing search
Sage 1000 Excelerator V1 Help
Introducing Excelerator
Introducing Excelerator
Excelerator Modules
Getting Started
Getting Started
Important Information
Pre-Installation Checks
Download Excelerator
Install Excelerator
License Excelerator
License Excelerator
Remote Desktop/Citrix Licence
Database Connection
Central Database Definitions
Central Database Definitions
Excel Companies Table
Configuring Excelerator
Central DB Config Utility
Start Using Excelerator
Start Using Excelerator
Standard Templates
Designing Templates
Old Style Add-ins
Multisheet Excelerator
System Keys
Toolbar Utility
Using Browses
Using Browses
Power Browses
Data Selection Utility
Advanced Features
Advanced Features
Copy Excel Worksheet
Rename Excel Worksheet
Convert to/Correct to Multiple Sheet
Save Excel Worksheet
Range Definition
Add Excel Format To Range
Add Length Validation
Add Tool Tips
Add Column Headings
Troubleshooting
Troubleshooting
Installation
Licensing
Upgrades
Connection
Designing Templates
Details of Installed Files
Office 2013
Uninstall
Excelerator Modules
Excelerator Modules
Excelerator Modules
Nominal Ledger Journals
Nominal Ledger Journals
Standard Templates
Creating your own templates
Validation
Reversing Posted Journals
Options
Retrieving Existing Journals From Sage
Posting to Different Companies
Caveats and Supported Projects
Sales Ledger Invoices
Sales Ledger Invoices
Creating your own Templates
Methods of Entering VAT
Sample Spreadsheets
Caveats and Supported Projects
Sales Ledger Cash
Sales Ledger Cash
Creating your own templates
Entering Data
Entering Data
Auto Allocations
Manual Allocations
Speed Entry using Invoice Number
Read Only Ranges
Options
Caveats and Supported Projects
DA0814 Multi Currency Receipts
Changes as of Version 1.0.0.111
Sales Journals
Purchase Ledger Invoices
Purchase Ledger Invoices
Creating your own Templates
Methods of Entering VAT
Sample Spreadsheets
Downloading Batches
Saving, Amending and Appending to Existing Batches
Default Date Behaviour
Defaulting Values for a Whole Batch
Get Next Batch Number
Registered Invoices
Caveats and Supported Projects
Using the extended invoice number
Extended Functionality
Extended Functionality
SQL Server Schemas
Additional Data
Additional Data Fields
Activating
Purchase Ledger Code Phase 1 Invoices
Purchase Ledger Code Phase 1 Invoices
Creating Templates
Coding Invoices
Browsing Phase 1 Posted Invoices
Invoice Speed Entry
Cash Book Receipts
Cash Book Receipts
Creating your own Templates
Cash Book Payments
Cash Book Payments
Creating your own Templates
Budget Master
Budget Master
Creating your own Templates
Download From Sage
Saving Budgets to Sage
Saving Budgets to Sage
Designing your Spreadsheet
Spread Codes
Customers
Analyser
Analyser
Creating your own Templates
Download from Sage
Drill Down
Analyse and Adjustment Entry
Trial Adjustment
Generate Adjustment Journal
Other Options
Debtors Management
Creditors Management
Price List Manager
Price List Manager
Downloads from Sage
Uploads To Sage
Creating your own Templates
Troubleshooting
Caveats and Supported Projects
Purchase Orders
Purchase Orders
Caveates and Supported Functionality and Projects
Units and Prices
Multi Order Spreadsheets
Changes from November 2010
PO Receipts
PO Receipts
Caveates and Supported Projects
Creating Your Own Templates
Using the Purchase Order Browse
Options
Stock Master
Stock Master
Downloading from Sage
Entering Data
Options
Supported Functionality
Technical Descriptions
NL Code Manager
NL Code Manager
Upgrading from Posting Code Excelerator
Posting Code Manager
Account Code Manager
Cost Centre Manager
BOM Assemblies
BOM Assemblies
Sample Spreadhsets
Entering and Saving Assemblies
Downloading Assemblies
BOM Assembly Caveats and Supported Projects
Suppliers Information
Suppliers Information
Creating your Own Templates
Suppliers
Suppliers
Caveates and Supported Functionality and Projects
Downloading from Sage
Options
Validation
Entering and Saving Supplier data
Technical Descriptions
Changes from November 2010
New ranges:
- Line Number
- Line Action (insert/delete)