Plugin / Bestbooks

Description

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

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 tinyint(4) 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 tinyint(4) 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

—

— Table structure for table Journal

For Network-aware configurations, aka WPMU

CREATE TABLE IF NOT EXISTS {$wpdb->base_prefix}bestbooks_journal (
txdate date NOT NULL default ‘0000-00-00’,
ref tinyint(4) 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’
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

For non-Network-aware configurations,

CREATE TABLE IF NOT EXISTS {$wpdb->prefix}bestbooks_journal (
txdate date NOT NULL default ‘0000-00-00’,
ref tinyint(4) 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’
) 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 tinyint(4) NOT NULL auto_increment,
name varchar(255) NOT NULL default ”,
txdate date NOT NULL default ‘0000-00-00’,
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 ”,
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 tinyint(4) NOT NULL auto_increment,
name varchar(255) NOT NULL default ”,
txdate date NOT NULL default ‘0000-00-00’,
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 ”,
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 https://github.com/patrickingle/bestbooks/issues. You will require a free account on github.com

Please contact [email protected] or visit the above forum with questions, comments, or requests.