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

744

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,623 Super User 2025 Season 2 on at

Like (0)

Report

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 744 on at

Like (0)

Report

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,623 Super User 2025 Season 2 on at

Like (0)

Report

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 744 on at

Like (0)

Report

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,623 Super User 2025 Season 2 on at

Like (0)

Report

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,039 Moderator on at

Like (0)

Report

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

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates