Naturally Produced Modules

    sage-fifty

    1.0.0 • Public • Published

    Description

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

    Dependencies Issues

    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

    Keywords

    Install

    npm i sage-fifty

    DownloadsWeekly Downloads

    0

    Version

    1.0.0

    License

    ISC

    Unpacked Size

    583 kB

    Total Files

    9

    Last publish

    Collaborators

    • flamescape