1 Topic by thehunmonkgroup

(6 replies, posted in Banking and General Ledger)

Just upgraded from FA 2.3.x, and I notice there are some new data fields for Journal Entries, 'Document Date' and 'Event Date'.

I've been unable to find any documentation for what these fields represent -- how are they different from 'Journal Date'?

Also, it adds a bit more overhead to entries to enter 3 dates instead of 1, is there any way to suppress/hide these dates if they are of no use to me?

Go to forum: Banking and General Ledger

2 Reply by thehunmonkgroup

(10 replies, posted in Wish List)

a representative table list (for US QB users) can be found here:

http://doc.qodbc.com/qodbc/20/tables/table_info_all_us.html

this is of course for the third party driver i mentioned.  QB itself uses a proprietary data format AFAIK.

Go to forum: Wish List

3 Reply by thehunmonkgroup

(10 replies, posted in Wish List)

janusz,

Quickbooks is notoriously awful about vendor lock in.  Their export features (at least in all the versions I've seen) are limited to things like customer and vendor lists.  You have no direct access to things like invoices or journal entries.

However, http://www.qodbc.com/qodbc.htm is a third-party driver which exposes all data available in QB by translating it to database tables available via an ODBC connection.  I would think with a little elbow grease it would be possible to build a PHP script that leverages this driver, and maps the QB data to FA.

Unfortunately, the third party driver isn't cheap, currently weighing in at $150 USD for the read-only version.  I think for a lot of people through, that expense would be a reasonable trade for escaping QB's vendor lock in.

Go to forum: Wish List

4 Topic by thehunmonkgroup

(10 replies, posted in Wish List)

Ok, so I know a Quickbooks import feature would never happen without some funding help.  wink

I'm actually curious to know if anyone has looked into doing this.  Failing a full data import module, is there anybody out there crazy enough to help someone who needs to get all of their data out of QB into FA?

Using something like http://www.qodbc.com/qodbc.htm, the data wouldn't be all that hard to get out of QB, I think the difficulty would be in mapping it to the FA data scheme and figuring out all the API calls to stuff things in the right place.

All thoughts welcome.

Go to forum: Wish List

5 Reply by thehunmonkgroup

(7 replies, posted in Wish List)

Just bumping this discussion, would also love to see this feature.  I've got fairly solid PHP skills (Drupal background) and might even be interested in helping to code this, but not for a few months.

At the moment, I'm using the quick entries as a serviceable workaround.

Go to forum: Wish List