You’re offline. This is a read only version of the page.
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 see. How about having another integration (maybe inward only) to get all categories in F&O first then get their relevant transactions.
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
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!
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (