Phreesoft Support Forum

Hi Folks!
I hope to find some API stuff for Phreebooks, but I figured a little call for direction might be in order to point me to the best resources available.
I plan to export data from billing tables in OpenEMR, a medical records and billing system that lacks general accounting features, directly into the Phreebooks database. Naturally, I have set up a chart of accounts that reflects how OpenEMR does business, but I have yet to figure out how Phreebooks does things.
The general idea is to enable Phreebooks to be a default accounting software for users of OpenEMR. This would be a great combination.

On the surface, it looks pretty simple...heh.
I am sure I could set up and do some entries and try to map the table usage in Phreebooks, though I would rather do that from an API, or with a little help from you guys.
If everything else in Phreebooks is set up (beginning balances etc..) and I want to port billing items and payments (A/R and Income) from OpenEMR, do I need to worry about more than the "journal_item" field? If so, what other tables would I need to touch? Is there a sort of API that outlines the table usage, or do I need to start digging into the code and look at the sql updates for journal entries?

Cheers!
-Art

journal entries are posted in the journal_main table with the items in the journal_item table (linked ref_id = id). There are also several other tables that are touched depending on the type of transaction. Table chart_of_accounts_history, inventory, inventory_history, to name a few are also affected. Like I said in your other post, the best way to proceed is to prepare an order array (like the one in the zencart module) and post it to the journal class (/modules/phreebooks/classes/gen_ledger.php). I also recommend you create inventory items that match the items (sevices, things or whatever) so they can be cross tracked and historical information posted. This will help in your reports to properly track sales.

Dave