Jump to content

Printing related records

Recommended Posts

So I have an order entry solution that I am working on where the items can have "options" that effect the item's pricing.  Basically I have orders --- > orderLines ---> items ----> options.  In a basic invoicing solution I could easily just goto related records on the order lines and print an invoice type document.  What I need to do is add these option lines to that type of print layout.  

I have seen a very similar post in the forum, but was wondering what else I could do to print these "option lines" on the invoice.  I feel like I am missing something simple and obvious.

Share this post

Link to post
Share on other sites

Responding to my own topic in hopes that this helps someone else.  It was so simple, I just needed to get related records using the options table and use a sub summary by orderLines::itemSku and that produces what I need. 

Share this post

Link to post
Share on other sites

Never mind a little premature, this would only work if every item had an entry in the options table, and they don't, so back to the drawing board.  

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who Viewed the Topic

    2 members have viewed this topic:
    Carson  bac mac 

Important Information

By using this site, you agree to our Terms of Use.