News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) how to print customer ...

Microsoft Dynamics AX (Archived)

Unanswered

how to print customer account statement in ER same as standard one using ER

(1) Share

Report

Report

Posted on by CU01071104-0

2

Hi er folks,

I am trying to display customer transaction using er report the same exact way as standard customer account transaction runs but getting all the records.

Here I have made a group in excel

1. I need to display the opening amount as sum of amount of all dates till date<from date.

2. I need to print all transactions between FromDate-Todate.

3.Need to display Opening amount line only if sum of amount is available.

4. need to calculate balance = amount + balance for each line.

eg-- balance 2nd line = amount 1st line + balance 2nd line

balance 3rd line = amount 2nd line + balance 3rd line.

Let me know how we can achieve this functionality.

Thanks!!

All responses Img

All responses (0)

Answers Img

Answers (0)

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,030 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans