how to change the value of custgroup and get subgroupid in salestable form ax 2012

(0) Share

Report

Posted on by satendra singh ax

hi,

I add two fields in sales table custgroup, subgroupid. from--- i change the value of customer group field select 10 custgroup than subgroupid is not selected same cutomergroup.

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Hi,

I assume this "sub group" is some customization. Since it's a property of Customer group, it actually doens't necessarily make sense to copy it to the sales order. Otherwise you are duplicating data, and risk having wrong data as you have just described.

But, you can add logic in insert and update methods to always initialize the sub group from CustGroup to solve your problem. But please consider one more time if it is a good idea to duplicate this data.

Was this reply helpful? Yes No
Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi satendra singh,

Is Sub group Id a customized field? You will need to write your code in Tables\SalesTable\modifiedField method to assign the new sub group Id whenever the customer group is changed.

Was this reply helpful? Yes No
satendra singh ax 5 on at

Like (0)

Report

Hi,

i modify the custgroup like that i selected coustmergroup 10 than sub groupid field default select first value .

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I'm sorry but I don't understand.

Do you want to automatically set subgroup, based on the selected customer group?

Or do you want to only show subgroups related to specific customer group in the lookup?

If you just want to impact the lookup, make sure that you have properly defined table relations between your SalesTable fields and Customer sub group table. The relation should include customer group id and customer sub group id. Then the user can only select such subgroups that are related to the already selected customer group.

Was this reply helpful? Yes No
satendra singh ax 5 on at

Like (0)

Report

Hi Gunjan,

Sub Group Id is Customized field. whenever i changed the customer group that time sub groupid default first value select .

Was this reply helpful? Yes No
satendra singh ax 5 on at

Like (0)

Report

hi,

Do you want to automatically set subgroup, based on the selected customer group?

yes.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Ok, then just add your code in the modifiedField method of SalesTable.

If modified field is CustGroupId, select first customer sub group that has the same customer group id, and put that in the sub group field. Is it clear?

Was this reply helpful? Yes No
satendra singh ax 5 on at

Like (0)

Report

hi,

Yes

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (0)

Report

Hi satendra singh,

Were you able to get this working? Or are you still facing any issues?

Was this reply helpful? Yes No
satendra singh ax 5 on at

Like (0)

Report

Hi Gunjan,

I am writing the code in SalesTable /Methods /ModifiedField. Still I am facing this issue.

Was this reply helpful? Yes No