Share
ReportHi,
i want to link One Customer to multiple Sales Responsible, please guide me with complete process
Regard,
Safwan
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
i want to link One Customer to multiple Sales Responsible, please guide me with complete process
Regard,
Safwan
*This post is locked for comments
Hi SamuSafwan!
It's not clear what you want to achieve.
You need to create some report which collect data from sales orders or you need to setting up the sales rep for customer?
And you mentioned 3.0 version instead of 2012 in tags.
i tried your steps but in salerep is not coming employee name
Hi, you can use sales groups on the Customer record. From there, you can add as many as sales rep as you want.
Then sales group is retrieve on sales orders.
Hi SamuSafwan!
Did you solve the issue?
Try this:
All responses (
Answers (
static void Job278(Args _args)
{
CustTable custTable;
SalesTable salesTable;
EmplTable emplTable;
while select custTable
group by AccountNum
where custTable.AccountNum == 'yourCustomerCode'
join salesTable
group by SalesResponsible
where salesTable.InvoiceAccount == custTable.AccountNum
join emplTable
group by Name
where emplTable.EmplId == salesTable.SalesResponsible
{
info(strfmt("%1 %2 %3",custTable.AccountNum, salesTable.SalesResponsible, emplTable.Name));
}
}
For one customer i want to link multiple sales responsible
Hi SamuSafwan!
You should use CustTable, SalesTable and EmplTable.
Can you provide more information about your requirements?
And you tell about AX 3.0 right?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
