web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Regarding Recurring Jo...
Microsoft Dynamics NAV (Archived)

Regarding Recurring Journal Lines Table.

(0) ShareShare
ReportReport
Posted on by javedakhtar 1,751

whenever i am trying to asssign a value to the posting date of the recurring journal lines from my record variable .fieldname

"Gen.Jn2.Line".VALIDATE("Posting Date",RecMontlyRentPaid."Posting Date");

My record variable is RecMonthlyRentPaid,

My field is Posting Date of the above record variable .

it giving me error 

the date field is not valid 

both data type is same .Date.

Thanks in Advance

*This post is locked for comments

I have the same question (0)
  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    Please post the error message.

  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Hi

    Can you check whether the RecMontlyRentPaid."Posting Date" have any date or 0D, if it is 0D (i.e no date) you will get this error.

    Regards

    Rajasekhar.Y

  • javedakhtar Profile Picture
    javedakhtar 1,751 on at

    Sorry Rajasekhar Sir ,

    there is  no 0D.

  • javedakhtar Profile Picture
    javedakhtar 1,751 on at

    Mahesh Sir,

    i am getting this error message.

    "the date is not valid"

    on debugging  i got break code

    Codeunit 12 Gen. Jnl.-Post Line\PostGLAcc() .

    in the below line of code .

    IF "Posting Date" = NORMALDATE("Posting Date")

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    is there any date value in the RecMontlyRentPaid."Posting Date" value or it is blank?

  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    As mentioned by Rajasekhar, please check whether the value is flowing to the above "Posting Date".

  • javedakhtar Profile Picture
    javedakhtar 1,751 on at

    Sir,

    you mean to say any default value .

    there is no default value set for this field

  • mmv Profile Picture
    mmv 11,471 on at

    Hi,

    That means the "Posting Date" is not flowing into the posting routine.  Do you have any customization in the codeunit 12?

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Hi Javed

    "Gen.Jn2.Line".VALIDATE("Posting Date",RecMontlyRentPaid."Posting Date");

    If there is any value in the RecMontlyRentPaid."Posting Date" then it will assign the value to the Genjn2Line Posting Date, if there is no value you will receive error

    so fill the RecMonthlyRentPaid posting date and check whether the same flowing to Gen.Jn2.Line""Posting Date".

    Regards

    Rajasekhar.Y

  • javedakhtar Profile Picture
    javedakhtar 1,751 on at

    Mahesh Sir

    i dont think so .........

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans