Sage 100

Does anyone happen to have a proven method/routine for customizing the PO Form (or S/O form) in 4.40 to have the Terms & Conditions print on the last page of each PO? It was working perfectly fine on the client's 4.30 form, but it doesn't appear the same logic can be applied since the 4.40 out-of-the-box form is configured differently.

You can't just put it in the group footer #1 (which is suppressed by default but you could unsuppress it)?

I was originally trying to put it in GF #2 (PO #) but then was having issues with preventing the T&C's from going onto a 2nd page - as well as appropriately suppressing the Page Headers and Totals section. I'll try GF #1 and see what happens. FYI, this client prints 1 PO at a time.

Did you try putting it in page footer b?

No, I didn't. Wouldn't that make it print at the bottom of every page, and therefore would require a suppression formula? That's why I was thinking the T&C's should be in a GF section.

What I have done is move the footer section into Group Footer #2 (PurchaseOrderWrk,PurchaseOrderNo)

Page footer b is the order total so should only print at the end of the order. If you want to email me the form, I can take a look at it.

@PhilMcIntosh, I was tinkering with that as well. Can you expand/clarify a little further?

@ThereseLogeais, I'm actually just using the standard out-of-the-box PO form right now. Agreed that the Page Footer b data ""should"" only print at the end of the order, but it's a Page Footer section with a suppression formula (formula = {PO_PurchaseOrderWrk.PurchaseOrderNo} = NextValue({PO_PurchaseOrderWrk.PurchaseOrderNo})). In 4.30 for example, that data was in a GF section. Not sure why ""they"" changed it.

I moved what as in the page footer of the standard form (the order totals) and put the T&C verbiage on the left hand side of that section. Then make sure that section is formatted to print at the bottom of the page, but it won't print until you get to the end of the order.

@PhilMcIntosh, so does that mean you'd have both the Order Totals data and T&C's in the GF #2 section, with Page Footer b now empty?

correct, just suppress page footer b entirely

@PhilMcIntosh, once I add the T&C's text box (which is a full page of text) into the GF2 section, it seems to prevent the Order Totals data from printing at the bottom of the page. It's now printing right below the line items which in this PO example just has 1 line item.

Well I inserted an additional GF2 section (for the T&C's) below where the Order Totals data now resides, and that now has that data correctly printing at the bottom of the page. Now I just need to incorporate the appropriate logic (suppression formulas) so that the Page Header data doesn't print on the T&C page(s). Just having a little trouble with that as well because my T&C's are going onto a 2nd page.

Now looking for a better suppression formula for the Page Header sections. Right now I'm using ""pagenumber = totalpagecount"" - but because the T&C's are going onto a 2nd page, it's only suppressing on the last page.

you should resize the page footer sections as well. Even if you suppress them, Crystal ""saves"" the footer sizes which can use up a lot of space.

hmm, you could try"" pagenumber in totalpagecount-1 to totalpagecount""...

Possibly try the 'onlastrecord"" property for suppressing the header- might only work if there is only one PO printed at a time though

Here are the steps I ended up performing to get the T&C's printing properly on the 4.40 PO form. Thanks so much to @ThereseLogeais and @PhilMcIntosh!!! Inserted new page header (now ph a) section just below report header section, and moved page # data into it from ph so that the page # data prints on pages where the page header is being suppressed Put suppression on page header b and page header c: pagenumber in totalpagecount-1 to totalpagecount Moved the fields (order total, etc.) from pf b to gf2 po#. Inserted new gf2 (b) section below gf2, and put the t&c's in there and played with font size to get t&c's to print on 1 page. Hard-suppressed pf b Gf2 po#: unchecked all settings Gf2a: checked ""print at bottom"" and ""keep together"" Gf2b: checked ""new page after"", ""reset page # after"" and ""keep together

I'm having problems on the SO Invoice form T&C's also. The S/O form works. But the invoice form has an extra grouping for sequence number. Any ideas on that are helpful too.

What sort of problems are you having on the invoice form?

@Clark, I would suggest the same procedure but substitute the sequence group footer for group footer 2. What you want is to get the end of document stuff back to the actual end of document in the data, not at the page level on the form.

Aargh, for some reason my PO form thinks there's an extra blank page at the end of each PO so although the generated pdf is only 2 pages, the page # data shows as 1 of 3, 2 of 3. And of course this client has an ISO requirement to print the page #'s in this fashion. It's weird, too. When previewing the PO to screen, you get some kind of freaky looping going on where you can just keep going to the next page, on and on. At first we noticed that about 1/2 of the T&C's were repeating on that last page even though they all fit fine on the previous page, so we decreased the font size.. But now we have the blank page. Any thoughts?

Any blank space at the end of the T&C section or text block? If there are any suppressed sections after the group footer, reduce their height as much as possible.

Thanks, @PhilMcIntosh! Didn't see anything extra at the end of the T&C's, and my suppressed sections are reduced very small. Ended up just creating a formula field to calc the total pages (totalpagecount - 1). Also, in case anyone is wondering, I performed testing with both 1 item, and several items that go on to a 2nd page.