Search options (Page 2 of 5)

1) you can select your own GR/IR account after installing the COA (goto the "Instellingen" menu and select "Instellingen Systeem en Grootboek". I don't use such account, but you can enable it if you prefer to.

2) I think the current tax-types/percentages as included in the Dutch COA are suitable for the most users by including only the main Dutch VAT Tax groups/types. What kind of tax type/percentages would you suggest to include? Including all kind of taxes could be too confusing.

I think the easiest way is to use a redirect from your subdomain to the main domain and not to make separate installations. Create a .htaccess file with the following text and upload it to de mainfolder of your subdomain:

You can also do the following to keep better track of your aged receivables:

1. Create the following G/L accounts (only the first time, if not already created)
    * Bad debtors (Balance)
    * Provision bad debtors (Balance)
    * Write-off bad debts (P&L)
    Make sure both balance accounts are in the same G/L Accounts Group
2. Create an article "write-off bad debt" with the "bad debtors" account as default COGS account and default Revenue account
3. Issue a new credit note to the bad debtor with the article  "write-off bad debt" and the full outstanding amount as credit amount.
4. Allocate the issued credit note to the customer/outstanding receivable. The receivable is now moved from your A/R account/list and recorded as receivable on the created "Bad debtors" account (receivable).
5. Make a manual journal entry:
    Write-off bad debts (P&L) costs
    A/ Provision bad debtors (Balance)
6. In "old-school accounting" it is common to not write off the whole amount, but the amount minus 0,01. For example if your outstanding aged amount for a customer is € 100, write of € 99,99 in step 5 (so after issuing the credit note for the whole amount and only when the recaivable is "replaced" outsite the regular A/R account/list). Now you still have an outstanding amount of € 0,01 (€ 100 om the bad debtors balance account, minus € 99,99 on the provision bad debtors balance account. Togehter € 0,01). This € 0,01 will cause the debtor will remain visible in your administration and will not disappear/forgotten.

Goto Setup > Company Setup > Select 2013 as active fiscal year.

Hi Apmuthu,

Thanks for your response. I have followed your steps and now know which file will trigger the following error:

The 1305 error is triggered by the changed file /gl/includes/db/gl_db_bank_trans.inc

I have googled a bit on the error code and found this post: http://blog.152.org/2009/12/mysql-error … s-not.html

According to this instruction I have removed several spaces between IFNULL and the ( character in the file /gl/includes/db/gl_db_bank_trans.inc (1 space on each line in 69-71, so 3 in total).

Original code (extract)

        IFNULL(abs(dt.ov_amount), IFNULL (abs(st.ov_amount), bt.amount)) settled_amount,
        IFNULL(abs(dt.ov_amount/bt.amount), IFNULL (abs(st.ov_amount/bt.amount), 1)) settle_rate,
        IFNULL(debtor.curr_code, IFNULL (supplier.curr_code, act.bank_curr_code)) settle_curr

Changed code (extract)

        IFNULL(abs(dt.ov_amount), IFNULL(abs(st.ov_amount), bt.amount)) settled_amount,
        IFNULL(abs(dt.ov_amount/bt.amount), IFNULL(abs(st.ov_amount/bt.amount), 1)) settle_rate,
        IFNULL(debtor.curr_code, IFNULL(supplier.curr_code, act.bank_curr_code)) settle_curr

I understand this error doesn't occur on all MySQL versions. But I think other user might have this issue to. So can this fix sent to the repo?

See your e-mail....

Sounds ok Janusz!

Goto the setup tab and select "Create/Update Companies"

See the extentions settings in the setup/settings screen. Select the company which you would like to activate the extention for. Check the activate checkbox for the dashboard extention.