Categories
Blog Posts

Auto Login to Spire with One Click

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 does reduce the security of your Spire system in that anyone with access to your desktop can not only run Spire as you, but they […]

Categories
Blog Posts

Make Journal Entries in Excel

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 to demonstrate proof of concept and how the API can be used and how to go about doing it. It should be considered more of […]

Categories
Blog Posts

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 complex criteria with JSON and pagination – retrieving records in batches when there are expected to be many. The net change code uses the API […]

Categories
Blog Posts

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 convenient, it is not ideal for very large lists of customers, as an individual API call is made for each customer. For very large lists […]

Categories
Blog Posts

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 is required to add an order. For any information not provided, the Spire API adds the correct data automatically as if you were typing the […]

Categories
Blog Posts

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 want to do it yourself. Spire may not support the import you need. Spire is an “all or nothing” import. You may want to just […]

Categories
Blog Posts

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 be secured inside a compiled MS Access application. This solution requires the following to implement: Spire Microsoft Access A copy of Crystal Reports. 2008 onward […]

Categories
Blog Posts

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. It does not require an ODBC DSN to be created. It can be run as a scheduled task so you get an email every day […]

Categories
Blog Posts

Automate ODBC DSN Creation

Automate the creation of Spire PostgreSQL ODBC Datasources with a batch file.

Categories
Blog Posts

Welcome to SpireAssists

Today I am launching SpireAssists. Check out Spire Functions