x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 1 reply
  • Subscribers 139 subscribers
  • Views 465 views
  • Users 0 members are here
Browse Forums
Announcements
234
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
207
topics
406
replies
Sage Intelligence Reporting
121
topics
322
replies
David Gambino

Relationship between Sales Kit and component products in SINVOICED table

Posted By

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? 

Parents
  • 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,

    Erzsi

Reply
  • 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,

    Erzsi

Children
No Data

*Community Hub is the new name for Sage City