Finance | Project Operations, Human Resources, ...

Is it possible to move a category from one parent to another in Category Hierarchy through code?

(0) Share

Report

Posted on by Community Member

For example, would it be possible to move commodity code "Test1" from "TESTSummCommCode" to TESTSummCommCode2"?

I looked into methods of EcoResCategory table but there doesn't seem to be a method that can be used for this. Update method doesn't work properly if I change the parent category of a commodity code. And the AddToHierarchy method throws a validation error that parent category cannot be changed. Has anyone tried to accomplish something like copying the commodity code record, deleting it from wrong parent category and adding it under the right parent category?

Apologies for posting this in AX 2012 forum even though the snapshot is from D365FO because this works quite similar in both versions but AX 2012 has more active user base.

Thank you for your time!

I have the same question (0)

All responses (4)

Answers (0)

Deepak Agarwal 8,602 on at

Like (0)

Report

Hello,

May I know whats the business needs to do this. Ideally, you should be able to delete a category and create the same in another header.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

agarwal AX So I need to do this because the product records come through integration and they already have commodities codes on them. But the summary commodity codes/parent categories come through another integration. So some commodity codes may not have parent category when they get created and so they sit under some generic parent category. And when the actual parent category finally gets created, the related commodity codes need to move from generic to actual parent automatically after the actual parent categories are created via batch job. So that is the business need. Thanks!

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi GNJ,

Can you think about any other feasible integration option?

I am asking because the categories are shared across companies and trying to code something might result in problems in other companies and/or modules.

Rather than fixing the problem afterwards I wonder if there is something that you could do with your integrations and how they are initially created.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Deepak Agarwal 8,602 on at

Like (0)

Report

I see. How about having another integration (maybe inward only) to get all categories in F&O first then get their relevant transactions.

Was this reply helpful? Yes No