Skip to main content
Post a question

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id : hZBH75H3d+s3RA4V6Ec3Oe
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Invoice Approval journ...
Microsoft Dynamics AX (Archived)

Invoice Approval journal, Find Vouchers missing records

Like (0) ShareShare
ReportReport
Posted on 13 Sep 2019 07:43:32 by CXF 96

Good day all,

In ref to:-

Purchase ledger/Journals/Invoices/Invoice approval journal/Lines/Find Vouchers

...the user is presented with a list of records from the LedgerJournalTrans table, filtered in some way to only show certain records. 

My question is can someone please inform me of the exact criteria AX is using to decide which records to show and which ones not to show please as we have one record that should be there but is not and I cannot work out why?

We are running CU8 with some hot fixes from later releases and as far as I can tell had no development done in this area.

Previously we had issue around this area when journal batches were run and the user had a system crash which left these records in "limbo" as they did not have the correct Journal batch number, but as far as I can tell this is not one of them as it has the correct number, GJBN00007.

Everything else looks the same when comparing to a record that is displayed in comparison to this record that will not display.

Is there any date criteria on these as the only thing different on this record is it dates back to 2018.

Any help will be greatly appreciated.

Regards Cliff

*This post is locked for comments

  • CXF Profile Picture
    CXF 96 on 13 Sep 2019 at 14:12:44
    RE: Invoice Approval journal, Find Vouchers missing records

    Yes this is perfect thank you very much.. was very simple in the end but I did not realise this was kept at this level.

  • Verified answer
    Pedro Tornich Profile Picture
    Pedro Tornich 955 on 13 Sep 2019 at 13:57:54
    RE: Invoice Approval journal, Find Vouchers missing records

    You can check the query behind he form by right clicking the form and choosing "Personalize", then on the dialog that will appear change to the "Query" tab.

    querytab.png

    You can also add the following code to the init() method of the form:

    info(TableName_ds.query().dataSourceNo(1).toString());

  • Zain Mehmood Profile Picture
    Zain Mehmood 2,715 Moderator on 13 Sep 2019 at 12:35:24
    RE: Invoice Approval journal, Find Vouchers missing records

    Hi Cliff,

    Can you please tell what exactly what are you looking for and what record should be placed there?

    Can you provide a scenario with screen shots, this would be helpful.

    Regards,

    Zain Mehmood.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,748 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans