sage-fifty v1.0.0

Description

This is an early prototype of a Sage 50 Accounts interface for NodeJS. Not suitable for production use.

Prerequisites

• Windows
• .NET framework 4.5
• Sage 50c Accounts Professional v25 (2019)
• Sage Line 50 ODBC drivers (installed with Sage)
• Sage Data Objects (SDO) COM libraries (installed with Sage)

Example Usage

var Sage50 = require('sage-fifty');

// create a new sage link
var sage = new Sage50({
	accdata: "C:\\ProgramData\\Sage\\Accounts\\2016\\Demodata\\ACCDATA",
	username: "manager",
	password: "password",
	version: 25
});

// a simple database query
sage.query("SELECT TOP 5 ACCOUNT_REF, SPLIT_NUMBER FROM AUDIT_SPLIT").then(function(splits){
	console.log('5 SPLITS:', splits);
});

// create a sales receipt and allocate payments to invoice lines
// (invoice lines are identified by their split numbers)
sage.payInFull({
	bankCode: 1200,
	accountRef: "ABS001",
	reference: "Test",
	splits: [1023,1021,1020,1019,1010,1024],
	onprogress: function(currentItem, totalItems){
		console.log('PayInFull Progress %s/%s', currentItem, totalItems);
	}
}).then(function(result){
	console.log('DONE PayInFull test', result);
});

// get splits
sage.getSplitsByRange({start:10, count:5}).then(function(splits){
	console.log('RANGE SPLITS', splits);
});

// get a stream of all splits, fetched in chunks of 2000
sage.getAllSplitsStream(2000)
	.on('data', (s)=>{
		console.log('split', s);
	})
	.once('end', ()=>{
		console.log('split stream ended');
	});

Notes

More info about Sage 50 Accounts data tables can be found here: http://import.makingithappen.co.uk/custom_integration_files.htm