Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Regarding Recurring Journal Lines Table.

(0) ShareShare
ReportReport
Posted on by 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

  • mmv Profile Picture
    11,467 on at
    RE: Regarding Recurring Journal Lines Table.

    Hi,

    How you are getting the value in RecMontlyRentPaid recordset?  Please paste the code used.

  • javedakhtar Profile Picture
    1,751 on at
    RE: Regarding Recurring Journal Lines Table.

    Sir ,

    i didnt understand what you said ?

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

    this is what you mean to say

  • mmv Profile Picture
    11,467 on at
    RE: Regarding Recurring Journal Lines Table.

    Hi,

    How you are getting the value from RecMontlyRentPaid."Posting Date" field?  Could you post the code?

  • javedakhtar Profile Picture
    1,751 on at
    RE: Regarding Recurring Journal Lines Table.

    Mahesh Sir

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

  • Rajasekhar@MS Profile Picture
    5,569 on at
    RE: Regarding Recurring Journal Lines Table.

    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

  • mmv Profile Picture
    11,467 on at
    RE: Regarding Recurring Journal Lines Table.

    Hi,

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

  • javedakhtar Profile Picture
    1,751 on at
    RE: Regarding Recurring Journal Lines Table.

    Sir,

    you mean to say any default value .

    there is no default value set for this field

  • mmv Profile Picture
    11,467 on at
    RE: Regarding Recurring Journal Lines Table.

    Hi,

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

  • Rajasekhar@MS Profile Picture
    5,569 on at
    RE: Regarding Recurring Journal Lines Table.

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

  • javedakhtar Profile Picture
    1,751 on at
    RE: Regarding Recurring Journal Lines Table.

    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")

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans