Sage 100

I need to bring the totals only from a Crystal sub-report to the main report. I have tgried following the Crystal instructions but can't get it working properly. Does anyone have good instructions or perhaps a report that does it so I can see how it is done. Thanks.

Are you talking about using shared variables?

Yes. Here is the problem. Client has 3 inventory items they want to combine into one on the SO invoice. I would use a kit except that one item is subject to sales tax and the other two are not and all post to different GL accounts. So, I thought about combining the items on the invoice and leaving inventory the way it is. Any suggestions are welcome.

Each of the 3 items would always be ordered in the same qty? (Not same as in always 100, but if one is 100, the other two are 100, as well)

http://www.s-consult.com/2009/07/30/how-to-show-country-names-on-forms-using-older-mas-90-and-mas-200-versions/

Similar concept I think

@BethBowers -yes, the same quantity for all. @WayneSchulz - thank you - I will check it out.

I'm thinking of another group and suppressing the details instead, but maybe subreports can work. My little brain just ain't getting it right now.

@BethBowers - I am trying what you are thinking now but my head isn't wrapping around it. I need the main description to show and the totals for the price and extension amount.

I have a client doing something similar, but the lines combined vary from item to item. Our solution involves a detail line UDF that combines all lines with the same UDF code into one line displaying on the invoice. Has been working for 10 years now but maybe there is a more efficient method.

@JeffSchwenk sounds like what I need but my combinations don't change. Do you know how it is combined on the invoice?

Create a formula for the item number - if the item is x,z, or z, then it's the special ""combined"" item. If it's not x,z,y, then it's just the item number. if SO_InvoiceWrk.ItemNumber in [""x"",""y"",""z""] then ""Combineditem"" else So_InvoiceWrk.ItemNumber. Then do a group by this formula. Then move stuff in the Detail into this Group Footer. For this item, divide the qty summary by 3, for all others, just let it stay the summary.

Listen to @BethBowers - she is right on the money here!

Working on Beth's solution now and this is the way to go. Thanks Beth. This is good because I hate sub-reports, but thank you Wayne for the step-by-step instructions.