Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

validate Ledger Journal before posting in ssrs report x++

(0) ShareShare
ReportReport
Posted on by 163

I made a ssrs report that loop on all lines of ledger journal and validate journal 

main account suspended or not , vendor on hold or not , project status finished or not and financial dimensions . 

I solved all of this but I didn't find how to validate financial dimensions . 

which method should I use to validate ?

when I try to use ledgerJournalcheckPost.run () --- it validates well but throw error at the end so my report throw error and doesn't continue (I put this method in try catch but doesn't work )

how can I validate this without throw this error ?  

  • Menna Allah Ahmed Profile Picture
    Menna Allah Ahmed 163 on at
    RE: validate Ledger Journal before posting in ssrs report x++

    I don't know what is this all I want to know which method can I call or use to check if financial dimensions validated or not in ledger Journal

  • Martin Dráb Profile Picture
    Martin Dráb 230,846 Most Valuable Professional on at
    RE: validate Ledger Journal before posting in ssrs report x++

    That dimension values aren't suspended is validated already when selecting a value (by LedgerDimensionEntryController.validateValue()), isn't it?

  • Menna Allah Ahmed Profile Picture
    Menna Allah Ahmed 163 on at
    RE: validate Ledger Journal before posting in ssrs report x++

    there is no way to validate financial dimension direct ? , which method can I call to validate financial dimensions ?

  • Martin Dráb Profile Picture
    Martin Dráb 230,846 Most Valuable Professional on at
    RE: validate Ledger Journal before posting in ssrs report x++

    If your problem is that some code throw an exception and you'd like to avoid, you need to find what code it is. Then you consider if it can be prevented.

  • Menna Allah Ahmed Profile Picture
    Menna Allah Ahmed 163 on at
    RE: validate Ledger Journal before posting in ssrs report x++

    I tried to call simulate posting () but gave me the same issue , so which method should I use and give me all of errors , Or method validate financial dimensions ?

  • Menna Allah Ahmed Profile Picture
    Menna Allah Ahmed 163 on at
    RE: validate Ledger Journal before posting in ssrs report x++

    Then How can I get All validations without posting ? , I get all errors with different ways but financial dimensions I can't find How to validate it ?

  • Martin Dráb Profile Picture
    Martin Dráb 230,846 Most Valuable Professional on at
    RE: validate Ledger Journal before posting in ssrs report x++

    Well, setting "post" to Yes is definitely wrong, if your intention is validating the journal and not posting it.

  • Menna Allah Ahmed Profile Picture
    Menna Allah Ahmed 163 on at
    RE: validate Ledger Journal before posting in ssrs report x++

    No , I set it yes , I create Instance from ledgerJournaltrans not ledgerJouralTable (T tried both of them and have the same issue )

    when I set post to no it didn't give me all validations 

    this is my code 

              while select  LedgerJournalTrans
                order by LedgerJournalTrans.LineNum
                where LedgerJournalTrans.JournalNum == JournalId
    
              outer  join LedgerJournalProject
                where LedgerJournalProject.RefRecId == LedgerJournalTrans.RecId
                    {
                    checkPost = ledgerJournalCheckPost::newLedgerJournalTrans(LedgerJournalTrans,LedgerJournalVoucher::Journal,NoYes::Yes);
                    checkPost.parmJournalNum(JournalId);
                    checkPost.run();
                    }

  • Martin Dráb Profile Picture
    Martin Dráb 230,846 Most Valuable Professional on at
    RE: validate Ledger Journal before posting in ssrs report x++

    Did you set "post" parameter to No when creating a LedgerJournalCheckPost instance (e.g. by newLedgerJournalTable())?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans