Hi All,
I am working on a requirement to automatically populate or set the Sales Representative in the SalesRepresentativeTest
financial dimension based on the city entered in the Sales Order delivery address.
Here's what I have done so far:
- Created a backing table view named
DimAttributeCommissionSalesRepTable
based on theCommissionSalesRep
table. CommissionSalesRep
fields:AddressCity
,URSName
,URSPartyNumber
DimAttributeCommissionSalesRepTable
fields:- Key:
RecID
- Value:
URSPartyNumber
- Name:
URSName
- Key:
- Created and activated a financial dimension called
SalesRepresentativeTest
. - Added
SalesRepresentativeTest
to the Sales Order page. - I am able to get the lookup for the
SalesRepresentativeTest
financial dimension as expected.
Now, I need to automatically set the SalesRepresentativeTest
value based on the Sales Order's delivery address.
Could anyone please guide me on how to access and set the SalesRepresentativeTest
field in X++ code based on the city of the Sales Order address?