Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Ledger values in Proje...
Microsoft Dynamics AX (Archived)

Ledger values in Project posted transactions listpage ax 2012

(0) ShareShare
ReportReport
Posted on by Akbarpasha

Hi ,

We have a required to show the voucher details in one row such as main account, offset account , amount , voucher number, transaction id, project category,project id for posted project transactions.

The difficulty we are facing right now is "the list page should add the fields dynamically based on number of vouchers". That means consider if we have 5 transactions with different vouchers, those 5 vouchers should be added as a 5 rows .

Can anyone help me on this .

So is there any possibility of developing this functionality.

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger values in Project posted transactions listpage ax 2012

    Hello Akbarpasha,

    What you are looking for is not possible. Yet, there are standard reports, such as the GL account statement report, available that address the same issue in a way that an asterisk is entered in the report if multiple accounts / offset accounts are used. Not sure if this helps you directly but you might benefit from having a look at this report and how it is designed.

    Best regards,

    Ludwig

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Ledger values in Project posted transactions listpage ax 2012

    Hi,

    Client required like the below:

    we need to extract the data to CSV or excel like the below one:

    Date

    Voucher

    Amount

    Currency

    Main account 13200

    Main P&L it would post to*

    Financial dimensions

    Transaction origin

    Transaction type

    projectID

    Project category

    Tax invoice status

    Transaction description

    if a posted project has 4 main accounts , those 4 main accounts should be appended and their debit and credit amounts total need to be shown on a one row.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Ledger values in Project posted transactions listpage ax 2012

    Hi Akbarpasha,

    Can you explain a bit more? Your text is a bit confusing. You are saying that fields needs to be added dynamically with an explanation to show multiple rows. Usually, a field is a column; a record is a row. So please elaborate.

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