Spire UDF Import

Spire UDF Import imports data directly into Spire UDF fields from Excel. Features include: Use either the Spire API or ODBC to update the Spire database.Make backups of your UDF…

Continue Reading Spire UDF Import

GET GL Net Change

This Excel example shows how to retrieve the net change in a GL account between certain dates. It introduces some concepts not covered in this blog yet such as building…

Continue Reading GET GL Net Change

GET Customer Balance in Excel

This post demonstrates a simple Excel function to retrieve a customer's balance using the API. You can easily use it in any spreadsheet where you have a customer number. While…

Continue Reading GET Customer Balance in Excel

Order Entry from Excel

Perhaps the most requested automation for Spire is the ability to add sales orders to the system. The Spire API makes this very easy. Only the bare minimum of information…

Continue Reading Order Entry from Excel

Importing Data To Spire

The post is going to show how you can use Excel to import data into Spire. Although Spire has extensive importing ability, there are a few reasons why you might…

Continue Reading Importing Data To Spire

Running Reports Outside Spire

This article shows you how to output Spire reports without using the Spire application. You will still need Spire installed, but won't need to log in. The password required will…

Continue Reading Running Reports Outside Spire

Daily Sales by Email

This post shows a fairly easy way to setup a VBScript that will email you a CSV file of the days sales. It requires no special programs to be installed.…

Continue Reading Daily Sales by Email