apmuthu wrote:

Yes, and collect the money off the account books into your pocket! The boss will never know wink

Nice work. Good Standard Operating Procedure, provided that good people manage the books and those who pay their debts after a long time do so with a view to continue to do business and not for merely avoiding long term legal hassles. That way jest above will not become real.

Alright, stick with the credit note then.
Thank you.

ericta wrote:
erwindebruin wrote:

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.

How about discount the whole amount less 0.01 at payment as a way of recording the default/bad debts?
when we do discount at payment, does the discount apply to tax too?

let's say
invoice balance $1000 (including 8% tax)
customer paid $500, we give $500 discount to close the bad debt.

how much tax does the software calculate for this order?
still $80, or it's aware of the the discount and collect $40 on the tax?

Thank you

joe wrote:

One option is to do a normal customer payment and allocation for the bad debts. This will debet your bank account. Immediately after that you do a Bank payment from this bank account with the same amount and use the account for bad deptors (You may need to create such an expense account). Now the bank account is even. Make some good memo/comments.

And you are done.

/Joe

Hi Joe,

What about the tax recorded during the customer payment?

Hi,

We won't be able to collect most of our aged invoices (bad debt).
How do we record this?

Thank you
Eric

30

(4 replies, posted in Installation)

Hi apmuthu,

Thank you for your quick response.
I replaced the code, but same error exists.

Have a great holiday everyone.
Eric

31

(4 replies, posted in Installation)

Hi,

We just upgraded FA from 2.3.14 to 2.3.19 three days ago.
When we try to void a customer payment today we got following error

https://drive.google.com/file/d/0B2hEL1wolzPkSVcwVFZqT2tGRkE/edit?usp=sharing

Can anyone help?
Thank you
Eric

joe wrote:

Use the Bank Payment and select your customer to refund the money.

Joe

do I need to do the "credit notes" first?

Thank you
Eric

33

(2 replies, posted in Setup)

Thank you smile

erwindebruin wrote:

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

34

(2 replies, posted in Setup)

Hi all,

How do I create 2nd company?

Thank you
Eric

when setup this discount item, what do I choose from COGS Account?

still 5010, COSG - retail?

Thank you
Eric

Interest on Principal

How do we record interest?

TIA
Eric

38

(13 replies, posted in Items and Inventory)

I changed code in import_items.php to

line 141        if ($i == 0) $hdr .= $k . ";";
line 142             $str .= htmlspecialchars_decode($d) . ";";

using ";" as separator instead of "," when exporting.
so far it works.

Eric

Thank you Chris.

Eric

but my existing accounts are under one code
eg.

1060 check account 1122
1060 check account 2432

Do I keep using these accounts or create ones under different codes?

Thank you
Eric

what about the existing accounts (eg checking accounts sharing same code), are they still work as intended?
or I need to create new ones for the change?

Thank you
Eric

42

(13 replies, posted in Items and Inventory)

Thank you.

Eric

43

(13 replies, posted in Items and Inventory)

does that mean I can't use this import plugin?

Thank you
Eric

44

(13 replies, posted in Items and Inventory)

category, units, dummy... fields are all wrong!
please see the link below
https://docs.google.com/file/d/0B8lA_TPXJ45GUXhrWldHWXQ4ak0/edit?usp=sharing

tom wrote:

humm... that does not help.

Which lines appear wrong?

45

(20 replies, posted in Setup)

should the path be

/sales/includes/db/sales_order_db.inc

?

Eric

joe wrote:

Well, there was a minor bug in /sales/includes/sales_order_db.inc that eliminated the fallback.

It is now fixed in the HG repo. The file is also attached here:

/Joe

46

(13 replies, posted in Items and Inventory)

please see the link below

https://docs.google.com/file/d/0B2hEL1wolzPkYjFwZ1l3M/edit?usp=sharing

Thank you
Eric


tom wrote:

can you show us the first few lines of the csv file?

tom

47

(13 replies, posted in Items and Inventory)

Hi all,

I installed csv import modules recently, exported item.csv took a look. but
most fields are placed wrong! eg. "unit" field has value like "services". description string in "category" field...

Am I missing anything?

TIA
Eric

Thank you.

Eric

chrison wrote:

Yes, I think that's what he means.

There's another logical reason for having separate GL accounts for each bank account...  it would be extremely difficult to reconcile bank statements with the GL if accounts are intermixed in one GL account.  Having separate GL accounts would be much easier to manage/reconcile in the long run.

Hope that's helpful...

Regards,

Chris

Do you mean I need to create account code eg. 1061 for another checking account, then assign 1061 to the new bank account?

Thank you.
Eric

is this right?

if ($this->formData['doctype'] == ST_SALESQUOTE)
{
    $txt = "test";
    $this->TextWrapLines($ccol, $this->row, $right - $ccol, $txt, 'C')
}

Thank you
Eric