We are trying to determine if the Due date calculations currently in Adagio Receivables are sufficient for managing the different types of due dates and discount dates our customers are using or that are common in their specific industries.

If you grant payment terms or early payment discounts to your customers, have you been able to automate those terms using the current calculations available in Adagio Receivables? If not, what type of payment terms (not installment receivables) are you granting and how do you calculate them from the invoice date?

Thanks for any and all feedback.

Dating terms.

Payment will be due on a specific date. Date does not change relative to Invoice date. Usually a new date will be assigned for each season - i.e. Due date might be 12/15/08 for goods shipped 9/15/08 to 11/30/08. Usually subject to a credit limit, and customer can purchase more by paying for past shipments.

Allows small retailers to purchase ahead for the season. Easier for vendor to manage inventory and shipments by spreading seasonal purchases out.

Hi Kate,

OK - we've had a couple of requests for this. Should we just store the month/day and assume that the year will always be such that it is in the future? Or would a specific date be better (which might result in invoice due dates in the past and unexpected aging results)?

Hi Kate:

I had the same request from a client recently for the same reason.

Andrew had a suggestion that serves our client well. You may already know this but it was news to me!

If the Terms code on the Order/Invoice header is left blank, you can enter any Due Date that you want. It's not as good as a special Terms code because it relies on the user, but it works in most cases.

Thanks for the tip, Bruce.

Andrew,

Assuming the year in the future would be fine. Usually dates are up to several months out but not more than that.

Is this something others have had requests for?

We have been asked for aging to the end of x months rather than just the end of the next month which currently exists.

Using existing options and adding 60 or 90 days will result in a day or two either side of the actual month end date which is not the desired result.

The previous posts touch on this to some extent but do not resolve the issue completely.

Hi Frank,

Would the addition of date fields for entry of the aging days (so that you could see the dates being selected), be a reasonable improvement?

That sounds like a reasonable solution Andrew.

When you say date fields do you mean a pop-up calendar? Some people are not so good at determining month end dates without visually seeing the calendar.

If so I might suggest only being able to move forward or back month by month so as to avoid aging years in advance by mistake.

Hi Frank,

Yes - a pop-up calender as in all other Adagio dialogs. You'd could choose either the number of days or a secific date. Selecting one would change the other, so you'd notice 400 days in the future.

Did this get set aside?

I have a client that has similar invoicing practices as Kate described, they would prefer not to have to have to remember to edit the due date so often. Being able to select a calendar day rather than have it relative to the invoice date would make them very very happy!

Hi Warren,

Since changing the Terms management actually has to occur in Invoices, Time&Billing and OrderEntry before any changes can be made to Adagio Receivables, and there was little push for additional defined Terms, this improvement has not made the cut for recent upgrades. It also hasn't been mentioned in any Adagio Wish.

Guess it's not that big a deal for people!

Thanks for the update Andrew, I'll let the client know to not expect anything soon then. I'm not sure what the wish submissions process is(I'm still a little green...) but could this be considered as one?

Hi, Warren,

Have entered your suggestion for AR Terms.

Hi Andrew,

Our AR Terms are working great except for 1 issue. We have some customers that take their discount before tax and others that take their discount after tax. Adagio AR only allows us to select one or the other in the Company Profile. We need this option to be in the Terms Code, not the Company Profile.

That's a good suggestion. Thanks.

Susan:

It would be nice to have what you ask for but given that you are not allowed to discount GST or HST in Canada you might want to ask your customers to stop discounting taxes (as effectively they are taking more than they are entitled to which is money out of your pocket).

Douglas is quite right but we all have customers that take their discount after taxes - it's just easier to calculate. But it's not illegal to give a discount on an invoice. Enough said.

I tested the "calculate base for discount with tax included" in the Company Profile and whether it's checked or not doesn't seem to make any difference. Either way, it calculates the discount pre-tax.

Hi Susan,

When I set the Receivables company profile for the 'calculate base for discount with tax included' to a particular setting (either with or without tax), it is correctly determining the discount base when the invoice is created. I used a tax-included distribution on the invoice to see.

Note that changing the company profile option will not recalculate the discount base to include or exclude tax. If you have an unposted invoice and change the company profile option, you can force a recalculation by editing and saving the invoice in the batch. Posted invoices cannot have the discount base recalculated.