Author: Peter Wright

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…

The Spire Desktop program spire.exe supports command line parameters that allow you to automatically log on to a specific company from a single short-cut. It should be noted that this…

This project will demonstrate a simple application that allows a user to create and post a journal entry into Spire. This is far from being a complete application. It is…

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…

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…

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…

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…

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…

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.…