Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Payment Summery by dat...
Microsoft Dynamics AX (Archived)

Payment Summery by date Report showing duplicate payment references

(0) ShareShare
ReportReport
Posted on by Rohin 4,624

Hi,
I am running payment summery by date report and it is showing same payment references for different vendors, please see below screenshot:

NLI.png

please suggest.

*This post is locked for comments

  • Rohin Profile Picture
    Rohin 4,624 on at
    RE: Payment Summery by date Report showing duplicate payment references

    Okay need to refresh dataset and deploy the report is also necessary ?

  • Rohin Profile Picture
    Rohin 4,624 on at
    RE: Payment Summery by date Report showing duplicate payment references

    Okay Crispin,You means I need to add this relation to my query to work it correctly??

    Please confirm?

  • Rohin Profile Picture
    Rohin 4,624 on at
    RE: Payment Summery by date Report showing duplicate payment references

    Thanks Crispin, But even BankAccountTrans also shows correct data i.e. same voucher for different line with different payment reference.

  • Rohin Profile Picture
    Rohin 4,624 on at
    RE: Payment Summery by date Report showing duplicate payment references

    In addition to above, Yes report is working correct but if every lines has different voucher but problem occurs if some lines has same voucher but others details are different (like Vendor account, paymentReference, amount etc..)

  • Rohin Profile Picture
    Rohin 4,624 on at
    RE: Payment Summery by date Report showing duplicate payment references

    Is it not correct that same Voucher number for some lines in one payment journal because CheckNum(Payment reference ) is different for every line ?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans