Finance | Project Operations, Human Resources, ...

The due date is before the invoice date. Select a date that is the same as or later than the invoice date. While posting the customer free text invoice

(0) Share

Report

Posted on by ax Financial

746

Hi Forum experts,

Question-

I have imported the all the opening Customer invoice through Free text invoice journal and when i am trying to post the free text invoice getting error message as shown in the below

Error message - The due date is before the invoice date. Select a date that is the same as or later than the invoice date.

Document date is my invoice date of legacy system - 01/01/2009

and due date is 01/01/2009

and i am using the invoice date as 12/31/2021

We have some other custom fields data is available which i need to move along with these free text invoice.

Could you please provide the solution other that creating fiscal calender and posting the invoice and running the year end close.

any other alternative solution.

I have the same question (0)

All responses (6)

Answers (0)

Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

My first question would be - why do you have an open customer invoice that is over 13 years past due? Why wouldn't it have been written off as uncollectable?

Was this reply helpful? Yes No
ax Financial 746 on at

Like (0)

Report
Copy link

Link copied!

Hi Frank

We are migrating the data from legacy system to F&O. Still these opening invoices we need to collect monthly bases deferred revenue

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

Got it, that makes sense. Do you absolutely need that Due date to 1/1/2009 for correct Deferred revenue calculations? What would happen if you made the Due date 1/1/2022? I assume that messes something up in future billing?

Was this reply helpful? Yes No
ax Financial 746 on at

Like (0)

Report
Copy link

Link copied!

Hi Frank,

If i consider the due date as 1/1/2022 and the invoice date as 12/31/2021 and document date as 1/1/2009

If i fetch the Customer aging report then my aging data will be incorrect if the customer fetch the data based on the Due date.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,627 Moderator on at

Like (0)

Report
Copy link

Link copied!

Aging may be the least of the evils. I don't think the system is going to let you post an invoice with a Due date prior to the Invoice date. I tried creating a Terms of payment with a due date in the past and F&O doesn't like that. You can't enter a negative number in the Months or Days field.

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,045 Moderator on at

Like (0)

Report
Copy link

Link copied!

I think even if differed revenue needs to be recorded then also your due date will never be before invoice date

Why don't you use invoice date = 01/01/2009 and posting as 31/12/2021

Was this reply helpful? Yes No