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

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Customer - History By ...
Microsoft Dynamics AX (Archived)

Customer - History By Transaction Report

(0) ShareShare
ReportReport
Posted on by Muthusamy 4

Hi All,

I have the scenario of Booking Customer Sales Invoice for Projects along with Retention Concepts.

So, in the same voucher we have Account type customer having 3  lines different amounts based on projects dimensions as well as Retention ledger also having 3 lines with different mounts.

Journal is Validated and posted. We have History By Transaction report in Accounts Receivable module.

Report is showing the Retention ledger amount with multiplied by number of lines of Customer transaction for the same voucher.
How to solve this?

Thanks,

 

 

 

 

 

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Muthusamy v,

    I do not think that the AR 'History By Transaction' report is originally made for that purpose.

    Have you tried making use of the retention report and the inquiry forms that are available in the project module instead?

    Best regards,

    Ludwig

  • Muthusamy Profile Picture
    Muthusamy 4 on at

    Hi Ludwig,

    we are making financial entry in  General ledger journal for Project Rentention. So, we cannot use Project Module reports.

    FYI, In  Accounts Payable module -->  History By transaction report working fine.

    But, Accounts receivable module --> History By Transaction report is not working for the same scenario.

    Thanks,

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Muthusamy v,

    Just need to clarify whether I understood that right.

    In GL you manually post the retentions for the project that you want to have included in the history by transactions report.

    So, you do not make use of the project retentions functionality but rather post that manually, right?

    Can you share this manual GL posting how you record it for the AP and the AR side?

    Many thanks,

    Ludwig

  • Muthusamy Profile Picture
    Muthusamy 4 on at

    Hi Ludwig,

    Yes, i am not using project module functionlity and i am using GL journal to record the finance entry.

    4786.GL.png

    Thanks,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Muthusamy v,

    I replicated the example you show above and got the some outcome (in ax2012r3 cu12) if I use a single voucher only. So, this seems to be the standard output of the report.

    Is it an option for you to post the three customer transactions each with an offset account? In other words, rather than using a single voucher, you will have 3 voucher numbers. In this case the report shows the correct totals.

    The alternative would be asking a developer for some help to modify the standard history by transactions report.

    Best regards,

    Ludwig

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

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 21

#2
dekion Profile Picture

dekion 4

#2
Virginia99 Profile Picture

Virginia99 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans