Populate Fixed Asset (Financial Dimension) based on customized field

Finance and Operations/AX Developer Forum
1

Hi All,

My scenario is, need a customized field on Purchase Requisition Line (lookup to Fixed Asset Number). Based on the selection of Fixed asset number i need to auto populate the Financial Dimension (Fixed Asset field). How i can implement that ?

Thanks

2

Can you write code in modified method of the custom purchase requsition line/fixed Asset Number field to populate dimensions when ever the fixed asset number is changed?

3

Yeah, That is what i want to know how i can populate the Financial Dimension (Line > Details > Financial Dimension) ? As in i need to know which field i need to update ?

4

Default Dimension

5

Well, i will put my question in a different manner.

Customized field = COMP-000004 (selected this value from lookup)

Fixed Asset i need to populate with same value i.e. ‘COMP-000004’. How i can find the DimensionAttributeValueSet record so that i can update in DefaultDimension field in PurchReqLine ?

Thanks

6

From where do you wish to default the dimensions in purchReqLine, if you intend to default from fixed assets then default from AssetTable.DefaultDimension to purchReqLine.DefaultDimension…

7

Hi Sushanth,

What i did just now, created a customized field named as AssetId on PurchReqLine with EDT AssetId and put the below code on modifiedfield method of same :-

case fieldNum(PurchReqLine, AssetId) :

this.DefaultDimension = AssetTable::find(this.AssetId).DefaultDimension;

break;

But here DefaultDimension is coming as 0 from AssetTable.

Thanks

8

Sorry Varun, not really sure why you are receiving 0 in default dimension. Check in table if the specific asset has some default dimension. Let others suggest some solution.