Interfaces to SQL-Ledger

sunsetsystems wrote on Friday, April 15, 2005:

I’ve been doing some interfacing to SQL-Ledger recently.

There’s now a cash receipts report module at interface/billing/sl_receipts_report.php, which you can get to by clicking “Reports” from the billing page.  There are some new variables in interface/globals.php that you will need to customize in order for this to work.  Also there’s now a library/sql-ledger.inc that contains some general-purpose PostgreSQL interfacing.

Another thing I’m working on (and have almost finished) is an EOB entry piece, consisting of a page where you can search for and list invoices, and another popup window where you put in the EOB data for a chosen invoice.  I’m doing this because the EOB stuff that was customized into SL is a dead-end for ongoing maintenance, and because I could never figure out how to make it work.  It seems to be broken.

The EOB thing will also launch from the billing screen.

I’ll soon be starting on access control with phpgacl, which becomes even more important with the accounting system in the picture.

All comments and questions are welcome.

– Rod <rod at sunsetsystems dot com>

tekknogenius wrote on Friday, April 15, 2005:

You are the Mack-Daddy! That’s awesome…

sunsetsystems wrote on Friday, April 15, 2005:

Mack-Daddy?  Um, thanks.  :wink:

OK I have checked in the following to facilitate data entry from EOBs:

interface/billing/sl_eob_search.php
interface/billing/sl_eob_invoice.php
interface/billing/sl_eob_help.php

This is brand-new code in a "works for me" status.  It writes to your SQL-Ledger database - so make a backup before you try it out!

Also be sure to get the latest interface/globals.php and library/sql-ledger.inc.

– Rod <rod at sunsetsystems dot com>