Bookkeeping module

[stagebrace]

Added some navigation input and buttons.

1. Log into admin
2. copy the bookkeeping.php file into your admin folder
3. call it manually "http://www.yourstore.com/youradmin/bookkeeping.php

[beilana]

I personally think this is a wonderful idea. I am not a very good coder, but I have a physical store opening up in about 2 months. Shortly after that, I will start selling online with my newly updated version of zencart. I will be donating money to zencart regularly as the store becomes lucrative.

I would personally love to see zencart take over the additional functions of a FULL PHYSICAL STORE quality POS system which could be run on the back end of the site by employees and look nice for customers that may inadvertently see the checkout screen. It is already not too far from this - besides POS software costs a lot of money per register. Zencart could save me thousands of dollars and I would be more than happy to invest that money directly back into zencart.

I know quite a bit of accounting, and I would be more than happy to review anything suggested or help with the basic design.

I think trying to take over quickbooks itself might be a little bit too ambitious.
Besides this, an attempt such as this would need constant updates with tax prep software from around the world. This still requires a large corporation to keep up with the constant upgrades in tax code - individual coders would have a hard time keeping up.

[stagebrace]

I know quite a bit of accounting, and I would be more than happy to review anything suggested or help with the basic design.

This is great news. Please continue to monitory this thread for updates and questions. I will not have much time this week due to a funeral for brother in law . But I will be back next week.

Thank you so much for you offer of help. You will be needed!

[realforever]

Hi,

Early today, I just opened another thread on "Inventory module". Maybe I should have searched well before I did that, since your subject here is pretty tie to what I'm looking for: SO - PO - Receiving - Shipment - Invoice - Accounting.

Stagebrace, I hold double degrees in CIS & Finance. And I've been filing my small biz taxes for the past years since I started one. I know exactly how you feel. Maybe it's time for me to do some real programming work. I've done VB and Java applications, but had no motivation on php until now.

I also have experience on erp package for the big smb, like Everest ICODE, Microsoft Solomon, Compiere (was open source, not so open now and has a shxxx webstore never been updated and only used by its own), Opentaps (pretty good open source one; except maybe too much for what you ask here; and I'm learning on it.) Hopefully, with your simple functional requirement, and with complicated structure from Opentaps and Compiere, I could come up something. Any other php developer want to dip in could discuss getting pay job from me

Lastly, only 6 day left for tax filing It would be much easier if we had the module in place ...

[realforever]

Turbocash is overkill unless you're a totally accountant. Besides, it's written in Delphi. If I remember right, it's kind of like VB and used in ICODE as well. It's easy to start but difficult to expand.

This one zen cart + ck-erp is another close thought. But went to the demo, I didn't really see any inventory, warehouse or accounting functions other than regular zen cart.

[DogTags]

Here's the latest CK-ERP:

http://sourceforge.net/forum/forum.php?forum_id=670818

A new release, v.0.22.1, of CK-ERP, has been posted at SourceForge.Net, http://sourceforge.net/projects/ck-erp .

This release features connectors for Moodle, Atutor, vTiger, XRMS, WordPress, b2evolution and e107.

CK-ERP is an open source accounting/MRP/ERP/CRM system that runs on top of multiple middlewares. It comprises 22 modules - Administration, i18n, Contact Management, Customer Relationship, Customer Self Service, Vendor Relationship, Ledger, Bank Reconciliation, MRP, Warehouse, Inventory, Service, AP, AR, PO, SO, Quotation, POS for Cashier, POS for Manager, HR, Staff Self Service and Payroll. Operating platform can either be LAMP or LAPP. It provides accounting and back office functionalities to SMEs and utilizes the underlying middleware to administer accounts/groups. Please report error and suggestion to the discussion group / mailing list, CK-ERP-en(at)googlegroups.com or CK-ERP-zh_CN(at)googlegroups.com . General history and expected development is available at the discussion group's Archive.

Supported MiddleWares: eGroupWare, Horde-GroupWare; Zencart, CRELoaded, osCommerce; Drupal, Joomla, Mambo, e107, XOOPS, Xaraya; Moodle, Atutor; vTiger, XRMS; WordPress, b2evolution; TikiWiki; phpBB.

[savanik]

I would personally love to see zencart take over the additional functions of a FULL PHYSICAL STORE quality POS system which could be run on the back end of the site by employees and look nice for customers that may inadvertently see the checkout screen. It is already not too far from this - besides POS software costs a lot of money per register. Zencart could save me thousands of dollars and I would be more than happy to invest that money directly back into zencart.

I know quite a bit of accounting, and I would be more than happy to review anything suggested or help with the basic design.

I think trying to take over quickbooks itself might be a little bit too ambitious.
Besides this, an attempt such as this would need constant updates with tax prep software from around the world. This still requires a large corporation to keep up with the constant upgrades in tax code - individual coders would have a hard time keeping up.

Yeah, Quickbooks is way powerful and constantly updated. And isn't there already a way to sync Zencart with it?

But using Quickbooks as a POS is a POS, from what I understand. And this is *exactly* what I've been searching for. Inventory control and POS from Zencart for our physical brick-and-mortar store. From what I can tell, doesn't quite exist yet for Zencart. All the parts are there, they just haven't quite been put together.

My thought is to code up a 'Register' module accessed from the admin screen. People would sign on to the Admin account, then open up the Register module and everything they need to sell things to physical customers would be right there.

What do you guys think? We have a couple coders and a fair amount of free time. Where should we begin?

Craig Rickel
Tech Gurus

P.S. I tried out that CK-ERP thing, and it seemed both highly user-unfriendly and ... er... broken. ' Please inform System Admin: /ck-css/reportfilter.php MD5 checksum failure' was all I got on most pages.

[stagebrace]

Here is the next set of changes. We are reading database info now but not saving it yet.

Place the bookkeeping.php into <your admin name folder>.
Log into Zen Cart admin and manually enter "bookkeeping.php" into the url address line.
I will be back in Tennessee on Sunday. To start on the data save function.

All comments requested..

[beilana]

Hello Guys,

I Noticed Several Links To Ollecart Which Is A Pos System That Works With Zencart. It Has A Nice Set-up, But There Is One Major Problem, --> I Understand That It Does Not Work With The Multiple Attributes Module (a Big Draw-back). This Is Likely Because It Is The Most Difficult Coding To Include In Any Pos System. It Additionally Has To Be Part Of The Base Coding Because It Makes The Number Of The Queries Expands Exponentially With Each Attribute Dramatically Reducing The Speed Of The Whole System. Therefore, I Think We Should Look At Ways Of Decreasing The Queries And Then Start By Integrating The Attributes & Upc Code. Only Then Does It Make Sense To Then Build The Pos Around This Code.

The Zencart's Own Dr. Bite Has Posted The Road Map Which Addresses Many Of These Major Issues (stream-lining The Database, Integrating The Upc Codes, And Make The Cart Accept Attributes.

***so Before We Consider Methods Of Building The Pos Around The Core, We Should Have The Zencart Team Chip In Some Ideas They May Have Already Started To Implement. Also, We Need To Know What They Are Planning So We Continue To Compliment The Zencart Team Rather Than Constantly Have To Re-work The Core Of The Module.

Ideas:
Quickbooks Uses A Grid System Which Assigns Numbers To Each Attributes And Then Reads The Numbers Something Like This:

Item: Xxxxx
Attribute A (color) Blue (1) / Red (2) / Yellow (3)
---------------------------- /----------------------- /---------------------
Attribute B / /
(type) Rough (1) A1b1 / A2b1 / A3b1
---------------------------- /----------------------- /---------------------
Smooth(2) A1b1 / A2b1 / A3b1
---------------------------- /----------------------- /---------------------
Bumpy(3) A1b1 / A2b1 / A3b1
---------------------------- /----------------------- /---------------------
Lumpy(4) A1b1 / A2b1 / A3b1

Therefore, A Rough Blue Item Would Code Something Like This

Xxxxx.a1.b1

I Would Be More Than Honored To Have One Of The Zen-cart Team Help Direct Our Task To Help Them Eventually Include Our Code Into Their Module.

Please Help Our Direction....

[stagebrace]

It Additionally Has To Be Part Of The Base Coding Because It Makes The Number Of The Queries Expands Exponentially With Each Attribute Dramatically Reducing The Speed Of The Whole System. Therefore, I Think We Should Look At Ways Of Decreasing The Queries And Then Start By Integrating The Attributes & Upc Code. Only Then Does It Make Sense To Then Build The Pos Around This Code.

beilana, would you be able to build a fake store with the above issues then send me a copy. So I can see your issues with my code, live. Dennis