Bookkeeping module

[beilana]

Excellent!

INTERESTING INFORMATION...

I have installed several of the free POS systems. Most have been old and ineffective, but there is one in particular that seems VERY interesting. I am loading it onto my home computer because I do not have the latest versions of the software on my server.

It is called "Openbravo" and it already seems to do just about everything linking to a fully expandable network. It merges seemlessly with Tina POS which is opensource and has inventory management, graphs and everything. Tina POS also works with touch screens, UPCs scanning, and even phone sales. It also has security, and a great - user-friendly look for employees.

Here is the site to run the on-line preview and get to the downloads section:

http://www.openbravo.com/index.php?o...244&lang=en_US

At the very least, I think we will be able to port a lot of open source code from this set-up.

Infact, I am almost thinking we should be working on linking it to Zencart. It is a bit of a bear to set up though because you need so many other modules downloaded.

Apache Ant, Java JDK and EE, MySQL, PostgrelSQL or Oracle, Tina POS, the Openbravo itself consists of many modules (Accounting, Backoffice, Warehouse, ERP, CRM, Sales Accounts, etc) ALL OPENSOURCE...

I think the reality is that NO SOFTWARE IS AN ISLAND. You either learn to merge with the many great other open source softwares out there or die. I really think we should help zencart talk to this system - IT LOOKS TO BE THE BEST OPEN SOURCE POS GOING AND COULD LIKELY KNOCK-OUT PLAYERS LIKE QUICKBOOKS IN THE NEAR FUTURE.


Ler me know what you think.

[stagebrace]

Update

• Forces SSL if its set to be used in configure.php
• Added "@" to all mysql functions.
• Makes the bookkeeping table `bk_expenses` if it has not been made already. (No SQL to upload by the user. The table may change soon to accept encrypted data)
• Shows some customer data for an order number.
• Saves order number as cookie (its the safest way to pass a JavaScript variable to a PHP variable)
• Log in to Zen Cart, admin>tools>Bookkeeping
• Re add display for product sold for an order number
• Re add form for expense per order (with add a row button)
• Expense form multiplies the quantity and price then copies it to total.
• JavaScript table for account numbers and descriptions
• Account description populates the account number field
• Quantity, Unit price, and Line Total now calculate with onkeyup event

Working on

1. add try catch and log errors to file
2. Instruction book
3. browser and server based encryption (goal: all data from client to server and server to client to be encrypted. Considering the possibility to save the data encrypted)
4. Save expense form data after encryption.
5. Vendor / Inventory expense management
6. Reports