Bookkeeping module

[DrByte]

Issues related to CK-ERP and Zen Cart can be discussed in the CK-ERP thread here on the forum: http://www.zen-cart.com/forum/showthread.php?t=30041

But issues related to whether the ck-erp.org website is working, navigable, hacked, or working in one browser or another should be handled at the ck-erp website, not here.

[zanget]

I was looking around on sourceforge and found this open source erp package called phreebooks. It's based on the administrator interface of Zencart and has a limited Zencart interface module (download orders and upload products). I'm surprised it's never been mentioned here.

I was able to use the interface to download an order. have not attempted to upload an item yet.
The order did download with all the customer detail and item info, but I can't get it to link to the inventory/sku without manualy going into the order and reselecting the items. Have not played with it much yet, so i may be missing somthing.

It's limited to upload/download 1 transaction or item at a time so it may not be for everyone.
It does look promising so I thought I would mention it here.

BTW they have a live demo on their website (phreebooks.com) without the zencart module.

[point0fsale]

The demo and script does not print:
The failing sql was: select address_book.telephone1 as d0, address_book.telephone3 as d1, journal_main.post_date as d2, journal_main.purchase_invoice_id as d3, journal_main.terminal_date as d4, journal_main.shipper_code as d5, journal_main.purch_order_id as d6, journal_main.terms as d7, journal_main.dept_rep_id as d8, journal_main.sales_tax as d9, journal_main.freight as d10, journal_main.total_amount as d11 from journal_main inner join journal_item on journal_main.id = journal_item.ref_id inner join contacts on journal_main.bill_acct_id = contacts.id inner join address_book on contacts.id = address_book.ref_id where journal_main.journal_id = '10' and journal_item.gl_type = 'soo' and address_book.type = 'cm' and journal_main.id = '607' AND journal_main.id = '607'

1054 Unknown column 'journal_main.dept_rep_id' in 'field list'