04-07-2022 05:56 PM - last edited on 05-10-2023 07:00 AM by JackLacava
Does anyone know how to extract data using Data Management pulling C#Elimination and a dynamic entity filter such as E#TOTALCO.Descendants? A parent entity is required but I have been unsuccessful at different options for the parent filter such as E#Default, E#TOTALCO.Descendants, E#|PovParent|.
04-08-2022 03:05 AM
Hi,
Have a look at the Data Adapter with Method as Command Type and use one of the Intercompany options for Method Type. See print screen below. That one is under Application Reports and is used for the Intercompany reports.
04-08-2022 10:21 AM
Hello!
Why is a parent entity required (are you getting an error?)? Pretty sure you can leave that field blank and the data will still export correctly but let me know if I'm wrong. We don't have the parent filter populated for any of our exports, IC/elimination data included.
04-08-2022 10:27 AM
Here is the error that I get if I pull C#Elimination without a parent specified.
04-08-2022 11:41 AM
I think you need the parent, it's the same when you want to have the ownership of an entity. An entity can be located under different parent in several structure. Depending on which structure you want the ownership or eliminations from, you will need to tell the system where it's located by specifying the parent. I would recommend you to look at the Data Adapter with the Method which is designed to get the Intercompany eliminations.
Peter