Bookkeeping module

[Gonz0]

I am a newbie sire so bear with me. We are looking at a way to export from our Zen Cart a method of exporting data from our report mod that would go by the catagories and sub catagories so that we could figure out how much we owe each entity.

[stagebrace]

I spent the last month entering 3 years of expense per order data. That works good. No reports yet.
I really could use some help with checking for good programing practices to stop sql injection and such.

[beilana]

stagebrace,

I will do the best I can - but I really think you should take a look at this.

http://wiki.openbravo.com/wiki/index.php/Project_Ideas

Look at the installation link to Zen Cart developer area down on part 2.3 - it tells you all the rules and exactly how to patch to Openbravo.

This program ALL the things you would like with book keeping and everything else. Those account types I gave you were from Openbravo, so if you have used it, you are likely already writing to it.

Please check out this project. It really does do everything you want and then some.

I am installing your software now to do the best I can to help you out.

[barco57]

I believe the problem with using openbravo at this time with zen-cart is that it doesn't work with MySql databases.......they are supposed to be adding that in the future.......openbravo would be perfect for some of what my client need but the fact that it won't work with the ZC DB makes it DOA


I suppose I could use an integration technology of some kind, but would prefer native MySql support

[stagebrace]

beilana,
I have looked at openbravo. I will pass on using it for this project. Thanks for the suggestion.

[beilana]

Thanks for the response stagebrace.

For all others -> I understand that Openbravo is written in postgreSQL, however, it and everything (almost everything) I know of links via JAVA.

That is how TINAPOS was, and TINA POS+ is being written into the zencart database. Both of those systems connect with Openbravo.

Any business that has both a physical store and website will have to get their servers to talk some way and the databases will inevitably end up on several different computers/servers. Otherwise, when the internet goes down, sales at the physical store will stop. It would be difficult to run a company of any size on computers that could not talk to other databases.

[RWerksman]

Has there been any developments on this recently?

[poosk]

I spent the last month entering 3 years of expense per order data. That works good. No reports yet.
I really could use some help with checking for good programing practices to stop sql injection and such.

umm is the zip on purpose missing bookkeeping.php which the menu link leads to or am I just being stupid?

[stagebrace]

I will post an update today.

[poosk]

ok let us know.