Results 1 to 10 of 101

Hybrid View

  1. #1
    Join Date
    Sep 2004
    Posts
    15
    Plugin Contributions
    0

    Default Re: Bookkeeping module

    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.

  2. #2
    Join Date
    Feb 2005
    Posts
    70
    Plugin Contributions
    0

    red flag Re: Bookkeeping module

    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'

 

 

Similar Threads

  1. Online bookkeeping?
    By amram in forum Managing Customers and Orders
    Replies: 0
    Last Post: 14 Nov 2010, 01:42 PM
  2. Create a new module for International Checkout payment module
    By icecold in forum Addon Payment Modules
    Replies: 63
    Last Post: 27 Apr 2010, 03:04 AM
  3. Developing an Intabill Module by adapting from the Nochex APC Module?
    By haostaff in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 20 Oct 2008, 02:13 AM
  4. Credit Card Module Strange behavior.... using Edit Orders module
    By FrenchFrog in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 5 Jan 2008, 06:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg