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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Customize a report 120...
Microsoft Dynamics NAV (Archived)

Customize a report 120 "Aged Accounts Receivables".

(0) ShareShare
ReportReport
Posted on by Community Member

hi all,

i need to customize a report 120 "Aged Accounts Receivables".
what i try to do is to group the report by the salesperson.
eg: salesperson JS hv 5 customer then

Salesperson: JS

customer no
1) xxxxxxxxxx xxxxx
2) xxxxxxxxxxxxxxx
.
.
5)XXXXXXXXXXXXXX

but i've no idea on it.

although i already set the key for the customer table...but it didn't work also..the rpt only group by salesperson when the user filter the salesperson code b4 preview the report....

IF user do not filter the salesperson...the report display all record that belong to all salesperson within the aging period.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    Do you want totals for each salesperson ?

  • Community Member Profile Picture
    Community Member on at

    yes, i want totals GrandTotalCustLedgEntry[1]."Amount (LCY)" for an salesperson that user put in the customer filter

    Customer Customer

    Cust. Ledger Entry <Cust. Ledger Entry>

    Cust. Ledger Entry OpenCustLedgEntry

    Integer CurrencyLoop

    Integer TempCustLedgEntryLoop

    Integer CurrencyTotals

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,269 Super User 2026 Season 1 on at

    Add a new dataitem for saleperson/purchaser and Specify DataItem Link to the customer and indent the other dataitem properly then add a new section called group footer for saleperson/purchaser and copy the textboxes from the customer footer to that section

    .customer-sp.png

  • Community Member Profile Picture
    Community Member on at

    it not work !! i have a nav 5 and its not like you have in your picture
    5367.2.PNG

    5367.2.PNG

    8081.3.PNG

  • Community Member Profile Picture
    Community Member on at

    it not work !! i have a nav 5 and its not like you have in your picture
    0121.2.PNG

    0121.2.PNG

    4745.3.PNG

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,698 on at

    Check the grouping in report as report mau be using grouping from cust ledger entry tabld

  • Community Member Profile Picture
    Community Member on at

    how i will do this ? and i'll grouping by what ?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans