Relationship between Sales Kit and component products in SINVOICED table

I am trying to develop a query that involves aggregating invoice lines such that values for kits are the sum of their components.

I can see there is a flag (LINTYP_0) to determine what is a kit and what isn't, however I am having a hard time figuring out a way to establish a parent-child relationship between the kit and its components in SQL.

How can this be accomplished? 

  • 0

    Hi ,

    Thanks for reaching out. Did you ever find an answer for this issue? If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps. Y

    ou might also want to reach out to the team directly at [email protected] as it looks like you might be affiliated with the account ending 400xxxx506 which is a development partner account with us. 

    Warm Regards,