You’re offline. This is a read only version of the page.
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
how i will do this ? and i'll grouping by what ?
Check the grouping in report as report mau be using grouping from cust ledger entry tabld
it not work !! i have a nav 5 and its not like you have in your picture
it not work !! i have a nav 5 and its not like you have in your picture
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
.
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
Do you want totals for each salesperson ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (