@package_instance_name@

General Ledger provides services to other packages and provides a basic UI for directly managing a ledger and accounts.

Features

Converted:

Preliminary data model for Postgresql including preloading chart templates and language translations when installing.
Num2text in SL, lc_number_to_text in accounts-payables package

Plan summary

Basic general ledger posting via web and service (also callback?), and editing chart templates. One ledger per package instance. See sql-ledger's features and What's new pages.

notes

sql-ledger        package-key  table name

<table_name>        qal_<table_name>

Need to add package_key to data model.

porting notes and guidelines

The locale data has been extracted using a custom program located in the accounts-ledger/info directory of this package. Configuration data is set in convert.tcl. Be sure to remove xml language files in accounts-ledger/catalog/ before running the program.

Any functions dependent on either AP or AR data are moved to those packages. When something is dependent on two or more accounting packages, it is moved into the "full accounting features" accounts-desk package.

Each package has a set of Model-View-Control features and services. Most any of these packages should provide a basic level of features without requiring other packages. Optional (integrated) features are built into the packages where appropriate.

Table of "critical path" package dependencies

package-key	depends on
accounts-ledger	contacts, inventory-control
accounts-payables	accounts-ledger
accounts-receivables	accounts-ledger
accounts-desk	accounts-payables, accounts-receivables, accounts-payroll
ref-gifi	none, integrates with accounts-ledger
ref-unspsc	none, integrates with categories
accounts-payroll	accounts-ledger
inventory-control	none
online-catalog	none
shipping-tracking	accounts-ledger

(see ecommerce G2)

functions and procedures

lc_number_to_text proc is made from the the SL Num2text procedure which has localized cases in the locale directories, and the default Num2text.pm in sql-ledger/SL/

SQL

The Oracle SQL will be added after the PG SQL has settled a bit.

Some of the SQL has been changed to the OpenACS standards. See http://openacs.org/doc/current/eng-standards-plsql.html and http://openacs.org/wiki

for Postgresql:

INT changed to INTEGER
some of the TEXT types were changed to VARCHAR so that they get indexed
FLOAT changed to NUMERIC