x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 1 reply
  • Subscribers 18 subscribers
  • Views 81 views
  • Users 0 members are here
Browse Forums
Announcements
150
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
631
topics
887
replies
Reporting and Analytics
573
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
434
topics
671
replies
Year End
83
topics
128
replies
BamaDon

Link JrnlHdr to itself

Posted By

I added the JrnlHdr to the report twice in hoping the link the second JrnlHdr to itself.  How do I do this?  My first instance JrnlHdr is restricted to JrnlHdr.JournalKey_Journal 11 - Sales Orders.  While my second is restricted to JrnlHdr.JournalKey_Journal = 3 - Sales.  So I want to show Sales Orders and the subsequent billing of those orders on the same report.  How do I link these tables?

  • 0

    To update if anyone is interested, you link JrnlRow to JrnlHdr with PostOrder.  I aliased these as JrnlRow_SalesOrders and JrnlHrd_SalesOrders and restricted the report to JrnlHrd_SalesOrders.JournalKey_Journal = 11 (Sales Orders).  The second group I aliased as JrnlRow_Invoices.  and JrnlHrd+Invoices.  I then linked JrnlRow_SalesOrders.PostOrder to JrnlRow_invoices.LinkToAnotherTrx.  So I can pull in Sales Order Data in column 1 thru 4 and Invoice Data in column 5-8.  And I can compare them..

    This works, but I will go to my death bed complaining about how Sage 50 needs to open up the entire database to us.

*Community Hub is the new name for Sage City