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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to find invoices t...
Microsoft Dynamics AX (Archived)

How to find invoices that replaced by asterisk in posted customer payment journal

(0) ShareShare
ReportReport
Posted on by Chaidir Ali Assegaf 202

hi everyone,

according to my last question that have been answered (https://community.dynamics.com/ax/f/33/t/272526), i ask about how to pull Invoices that replaced by asterisk when you settle many invoices in Customer Payment Journal.

the difference between my old question is, when i retrieve Invoices from Posted Customer Payment Journal, there's no invoice displayed. this is because TmpCustVendTrans only store invoices from Open Customer Payment Journal.

where i can find it?

Thank's for helping me, i appreciate any answer.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,697 Super User 2026 Season 2 on at

    Hi Chaidir,

    For posted journals, you can pull data from the table CustSettlement. This has a relation between the customer transactions related to invoices and payments (including settled amount).

  • Verified answer
    Andrew Xu Profile Picture
    Andrew Xu 3,877 on at

    Chaidir,

    The easiest way to get the settled invoices from posted payment journal I can think of is to print the payment report from that journal. See screenshots below please,

    2018_2D00_3_2D00_21-9_2D00_59_2D00_30.jpg

    2018_2D00_3_2D00_21-9_2D00_59_2D00_30.jpg

    Or you can write your own logic to get the data from CustSettlement and CustTrans as Andre said. You can also filter out the data from Transaction and Closed transaction editing form of a customer.

  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at

    Check  closed transaction form for customers  and use the same logic.

  • Chaidir Ali Assegaf Profile Picture
    Chaidir Ali Assegaf 202 on at

    Hi André,

    from the CustSettlement table, i looked into the relation it has,

    i found the CustTrans Table and all the invoice is in the CustTrans Table.

    Thanks for your help.

  • Suggested answer
    Khaled Alloud Profile Picture
    Khaled Alloud 3,658 on at

    Hello,

    You can also check the column 'Invoice' from Closed transaction editing from Customer form.

    Thank you,

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans