Distribution, Manufacturing, and Internet Modules

[jnelsonut]

When doing Credit Memos in Sales Order Invoicing, the Due Date field is grayed out.  This causes problems with the aging, because there is not a due date on the Credit Memo.  I would think it should automatically fill the date field based on the terms code like it does when doing a standard invoice.

Is there a setting somewhere we're missing or is it working as designed with the version we're on?

Mas90, Ver 4.05

Thanks

Joe

[Heather]

Working as designed.  Still works that way on v4.3.  I don't know about v4.4, but I doubt it's any different.

[jnelsonut]

So how do you get the aging to work?

Example:

May has 25 Invoices and no Credit Memos giving a May Balance of $4500.00.

June has 25 Invoices totalling $4500.00 and 5 Credit Memos totalling $1000.00 giving June a Balance of $3500.00.

Print statements at the end of June and aging shows:

Current - $4500.00

May - $3500.00

Balance - $8000.00

In options aging is set to age by due date and the invoices are always aged correctly, but the CM's never have.

Also the Finance charges work the same way.  A June FC will show on the aging as due in May.

It's been this way for as long as I can remember and I never worried too much about it until I just got yelled at for 30 minutes by a customer and told that if I can't fix it he will find another vendor.  For now I created a new form code just for him and deleted the aging from it.

Any insight into this would be greatly appreciated.

Thanks

Joe

[Heather]

Well actually, my AR option is set to age by invoice date.  So I don't have any experience with things that age by due date. 

But I can tell you that my credit memos show up in the proper buckets at the bottom of the statement.

[jnelsonut]

Thanks Heather,

Maybe I'll play around with that setting and see if I can get it to work for us.

Joe

[MickeyW]

Has anyone found a working solution to this? 

We have the same issue, and know of at least one customer who found a loop hole to let them float on us:

Feb has 2 orders... #1 = $2000, #2 = $2000

March has 1...  #3 = $4000

Customer returns order #3, and gets a credit...

Mar statement balance shows a $0.00 due.... even though customer never paid anything too date.

yes, eventually, they must pay up... but they have affectively extended their terms.

[timmjlane]

When the CM is being generated, are you applying it to the original invoice or just generating a CM as a stand-alone?

I haven't tested it but it seems to me that if you applied it to the CM to the original invoice it should adjust the correct aging period.  Like I said, I haven't tested it...will try to do that when I can and post back.

[jnelsonut]

MickeyW,

The working solution I found was to do as Heather suggested and age by Invoice Date instead of Due Date (change in AR Options).  I haven't tested it in depth, but a quick look seemed to give me what I was looking for.  The problem is that CM's do not have a Due Date, so aging by Due Date will rarely give you the results you desire.

Jeremy,

This doesn't work if the Invoice has been paid.  In our business it's not uncommon to get something returned a couple of months after it's paid and the return rate for this business is at least 15%.

Joe