This is a very unusual situation.  Current S/O Invoice Printing form code is using only the SO_InvoiceWrk table and as is, the order prints as we want it to.  That is all fields showing the correct data.  However, in the case of balance due invoices that print, we need to include the AR_OpenInvoice.Balance field to print at the bottom of the Totals section.  I can add the AR_OpenInvoice table no problem and it automatically links to SO_InvoiceWrk as seen in screenshot below. 

As soon as I add the AR_OpenInvoice.Balance field to the form code in Crystal it then prints the following with no line items from the invoice, no totals at the bottom and no data whatsoever at the top of the invoice, i.e. Invoice Number, Invoice Date, Order Number, Order Date, Salesperson, Customer Number, etc., all fields on the invoice are blank.

If I remove the AR_OpenInvoice.Balance field from the Crystal form code but still have the AR_OpenInvoice table linked then the order prints correctly again with ALL fields showing correct data.

We have the BOM module but currently not using nor is it activated in any of our companies as of yet, not sure if these Bill Options that print have to do with BOM or not but there's certainly no BOM tables linked in the Crystal form.

I also tried suppressing Details c through Details l Sections on the form code as seen on screenshot below but that did not make a difference, it just kept the lines from printing but otherwise all fields are still blank with no data showing.

I have tried modifying the Crystal form from both Designer option within S/O Invoice Printing within Sage and also from Windows Explorer but same results either way.  I thought that perhaps when I was working on this initially I was editing the Crystal form from Windows Explorer instead of the Designer option in Sage so I started over from Designer but that did not make a difference.

There has to be a way to keep these lines from printing, showing all the data for that invoice and have it include the OpenInvoice.Balance field too.  Any suggestions would be greatly appreciated. 

Thanks.