AR and dating issues

Hi, our terms for all our customers are 30 days from EOM

Some of our customers purchased goods as at 1/10/2020 and they are showing up as due 31/10/2020 when it should be 30/11/2020, and they are showing up on the AR list as 1- 30days which they should be current. Does anyone know why this maybe happening ?

We are using Reckon Hosted

Thank you

Comments

Acctd4

The EOM terms can occasionally be out by a day or 2 because it's configuration is date driven (eg "30") so this can be slightly out when there are more or less days in a month. I always check the Due Date on a transaction & amend it manually where necessary.

JudyA

Hi Jelfor6,

Check your set up for your terms to see if there is an error, as what you describe sounds like it's set up as 30 days. I have this set up for 30 Days EOM:

And this is for 30 days:

Both seem to do what they are supposed to. I hope that helps.

Acctd4

@Jelfor6 JudyA's screenshot above for "30 Days EOM" illustrates my previous answer.

This is the correct setup however because some months have 28, 29 or 31 days, the "Date Driven" has the occasional hiccup as you can only specify a single date in the "Net due before the ...." box.

Jelfor6

Judy A where do I go to check this ? Is it each customer, I can not seem to find it

Shaz Hughes - How do I manually change a due date ? I do not have it on the invoice as far as I can see ???

Sorry for all the questions

JudyA

To access the terms, on the top tabs go to Lists>Customer & Supplier Profile Lists>Terms List

You may need to set up a new 30 Day EOM, and you can do that from the bottom of the page under Terms>New

You can then add these terms under each customer so that they come up automatically when you invoice them. If you have a large customer list it might be easier to add the terms when you create an invoice. (See screenshot below.) When saving the invoice, you should be asked if you would like to update the terms for that customer.

As for the due date on the invoice, when you click on the invoice tab, do you have something like this on the RHS?

It's here that you can change the due date. If it's not showing, then you will have to play around with your invoice template settings.

I hope that helps.

Jelfor6

Hi Judy

Thank you that has helped I have changed my net due driven date from 31 to 30, so hopefully next month it will be correct, it hasn't seemed to changed the historical invoices, buts that ok.

With the invoice template I have been asked to use, it doesn't have a due date section, it is PO, Terms, Ship via, so I will just keep an eye on it next month, and see if the change to the driven date fixes it

Reckon Accounts Hosted Announcements & Important Info

Check out the latest important info & announcements for Reckon Accounts Hosted

Button

View all Reckon software categories 🗃️

Each Reckon software has its own dedicated category on the Community. Click below to browse all categories.

Explore all categories