Bestbooks

Provides an accounting application framework for wordpress.

Author:PressPage Entertainment Inc DBA PINGLEWARE (profile at wordpress.org)
WordPress version required:2.9
WordPress version tested:5.8.1
Plugin version:2.6.3
Added to WordPress repository:11-04-2010
Last updated:30-09-2021
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
Rating, %:0
Rated by:0
Plugin URI:http://wordpress.org/plugins/bestbooks/
Total downloads:2 432
Active installs:10+
plugin download
Click to start download

BestBooks For WordPress originally was developed in Java, the original framework. The goal behind Bestbooks is to provide an accounting application framework modelled after common accounting terms (t-account,ledger,jornal) and the GAAP (Generally Accepted Accounting Principles) while providing open database connectivity. At the time, accounting frameworks had a proprietary, closed database structure. The original Bestbooks for Java has connectivity for multiple databases including MSSQL, DB2, Oracle and MySQL.

BestBooks for WordPress started as a minimal accounting framework but with inspiration (not copy) from waveaccounting.com, BestBooks is becoming a full fledge accounting application.

BestBooks for WordPress has enough functionality that you can create workable scripts that solve accounting problems. You will be able to
implement many of the accounting problems on the accounting learning website, http://www.simplestudies.com

Additional help from the excellent tutorials at https://www.keynotesupport.com/menu-accounting.shtml

BestBooks Accounting Application Framework is a registered trademark of PressPage Entertainment Inc.

Creating Documentation

Documentation is created using phpDocuemtor

  1. Install PEAR (see http://pear.php.net/manual/en/installation.getting.php)

    wget http://pear.php.net/go-pear.phar
    php go-pear.phar (a copy is in the root directory of bestbooks)

  2. Add the phpdoc channel to PEAR

    pear channel-discover pear.phpdoc.org

  3. Install phpDocumentor via PEAR

    pear install phpdoc/phpDocumentor

  4. Update the BestBooks documentation by executing the script

    ./docs.sh

    Arbitrary section

Tables creation from SQL:

These tables are created automatically within the wordpress database

—

— Table structure for table Accounts

For Network-aware configurations, aka WPMU

CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}bestbooks_accounts (
id int(11) NOT NULL auto_increment,
txdate date NOT NULL default ‘0000-00-00’,
name varchar(50) NOT NULL default ”,
type varchar(20) NOT NULL default ”,
data varchar(25) NOT NULL default ”,
class varchar(255) NOT NULL default ”,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

For non-Network-aware configurations,

CREATE TABLE IF NOT EXISTS {$wpdb->prefix}bestbooks_accounts (
id int(11) NOT NULL,
txdate date NOT NULL DEFAULT ‘0000-00-00’,
name varchar(50) NOT NULL DEFAULT ”,
type varchar(20) NOT NULL DEFAULT ”,
data varchar(25) NOT NULL DEFAULT ”,
class varchar(255) NOT NULL DEFAULT ”,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

—

— Table structure for table Journal

For Network-aware configurations, aka WPMU

CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}bestbooks_journal (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL DEFAULT ‘General Journal’,
txdate date DEFAULT NULL,
ref int(11) NOT NULL DEFAULT 0,
account varchar(50) NOT NULL DEFAULT ”,
debit decimal(10,2) NOT NULL DEFAULT 0.00,
credit decimal(10,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

For non-Network-aware configurations,

CREATE TABLE IF NOT EXISTS {$wpdb->prefix}bestbooks_journal (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL DEFAULT ‘General Journal’,
txdate date DEFAULT NULL,
ref int(11) NOT NULL DEFAULT 0,
account varchar(50) NOT NULL DEFAULT ”,
debit decimal(10,2) NOT NULL DEFAULT 0.00,
credit decimal(10,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

—

— Table structure for table Ledger

For Network-aware configurations, aka WPMU

CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}bestbooks_ledger (
id int(11) NOT NULL AUTO_INCREMENT,
num int(11) NOT NULL DEFAULT 0,
name varchar(255) NOT NULL DEFAULT ”,
txdate date DEFAULT NULL,
note varchar(255) NOT NULL DEFAULT ”,
ref double NOT NULL DEFAULT 0,
debit decimal(10,2) NOT NULL DEFAULT 0.00,
credit decimal(10,2) NOT NULL DEFAULT 0.00,
balance decimal(10,2) NOT NULL DEFAULT 0.00,
type varchar(10) NOT NULL DEFAULT ”,
cleared char(1) NOT NULL DEFAULT ‘U’ COMMENT ‘U=uncleared, X=cleared’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

For non-Network-aware configurations,

CREATE TABLE IF NOT EXISTS {$wpdb->prefix}bestbooks_ledger (
id int(11) NOT NULL AUTO_INCREMENT,
num int(11) NOT NULL DEFAULT 0,
name varchar(255) NOT NULL DEFAULT ”,
txdate date DEFAULT NULL,
note varchar(255) NOT NULL DEFAULT ”,
ref double NOT NULL DEFAULT 0,
debit decimal(10,2) NOT NULL DEFAULT 0.00,
credit decimal(10,2) NOT NULL DEFAULT 0.00,
balance decimal(10,2) NOT NULL DEFAULT 0.00,
type varchar(10) NOT NULL DEFAULT ”,
cleared char(1) NOT NULL DEFAULT ‘U’ COMMENT ‘U=uncleared, X=cleared’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;”;

Testing:

Create a page with the following shortcode, [bestbooks-sample-1]
then check your database tables for the validation.

If you get an error, please report it!

Credits

We make honorable mention to anyone who helps make Bestbooks for WordPress a better plugin!

Contact

Support is provided at Support. You will require a free account on github.com

Please contact presspage.entertainment@gmail.com or visit the above forum with questions, comments, or requests.