Microsoft Dynamics AX (Archived)

Customer Link With Multiple Sale man

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

For one customer i want to link multiple sales responsible

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Try this:

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)); } }

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report

Hi SamuSafwan!

Did you solve the issue?

Was this reply helpful? Yes No
Yohann Rolland Axcible 3,111 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

i tried your steps but in salerep is not coming employee name

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report

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.

Was this reply helpful? Yes No