You don’t need to do so much with XSL these days

As most of you know, we recommend XSL style sheets as the way to turn systems@work records into transactions for your accounting, or other systems. XSL style sheets can be invoked from Ledger Export to take the XML output from systems@work and turn it into transactions for import, as XML, a text, or Excel file.

The process of taking a set of systems@work transactions, for example a set of Invoice transactions that you want to import into your accounting system, involves several transformations.

First, because typically a systems@work transaction includes Net, Tax and Gross values all on one line, you have to produce three lines (one debit, and two credits) for each systems@work row.

Second, you will want to summarise all the resulting debit transactions so that there is just one debit for each invoice, and summarise net and tax transactions differently (by product, for example, and by tax code).

Third, you will want to sort the entire set of resulting invoice transactions by invoice number.

Fourth, you need to supply new field values to the resulting transactions, such as the journal type in your accounting system.

Fifth, you will need to convert the format into the appropriate text, XML or Excel format that your accounting system can import.

Until recently, one or more XSL style sheets were used for all of these purposes.

Now, the first three tasks can be handled more straightforwardly using three programs that we supply, and which you can parameterise in simple ways to MULTIPLY records, GROUP records by nominated fields, and then SORT the result.

That leaves XSL with the task of supplying a few extra values and formatting in the right way.

This very greatly eases the process.

Please contact us for more assistance on this.