Forum Discussion

Sweez's avatar
Sweez
New Contributor III
3 years ago

How to extract C#Elimination data with Data Management using a entity dynamic filter

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|.  

  • PeterFu's avatar
    PeterFu
    Contributor II

    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. 

     

     

  • NicoleBruno's avatar
    NicoleBruno
    Valued Contributor

    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. 

  • Sweez's avatar
    Sweez
    New Contributor III

    Here is the error that I get if I pull C#Elimination without a parent specified.

     

    • PeterFu's avatar
      PeterFu
      Contributor II

      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