Sage 100

 View Only
  • 1.  Terms & Conditions page at end of invoice

    Posted 11-30-2020 14:27
    HI All,
        I have an invoice form that has a terms & conditions section to print at the end.   I am finding that there is a flaw in the common logic (included below) used to suppress the headers & footers..  It assumes that the are an odd number of pages but the client occasionally has one that is two pages long and in those cases, the second page of the invoice has no header or footer and the 3rd page that has the T&C does have both which looks in a word "very funky".   I have played around with some other ideas but cannot get any of them two work as I would like.   Has anyone else ran into this and found a solution?

    formula = PageNumber/2 = int(PageNumber/2) or _
    ({SO_InvoiceWrk.InvoiceNo}+{SO_InvoiceWrk.HeaderSeqNo}) _
    = (NextValue({SO_InvoiceWrk.InvoiceNo}) + NextValue({SO_InvoiceWrk.HeaderSeqNo}))

    ------------------------------
    Bob Osborn
    Consultant
    ACI Consulting
    ------------------------------


  • 2.  RE: Terms & Conditions page at end of invoice

    Posted 11-30-2020 14:45
    I'd try a shared variable to control things.  Reset it in report header, then update it in the group footer section used to print totals (or the page footer after the print totals section...) and reset somehow after your T&C print. 
    When you have the variable working the way you want (drag it in to display / troubleshoot) then change your suppression formulas to use the shared variable instead of what isn't working.  I find it so much easier to troubleshoot a visible formula value vs digging into the multiple screens / options that drive sections suppression / new pages.
    As an alternate idea, if this is just for emailing only, try the new feature for additional attachments.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Terms & Conditions page at end of invoice

    Posted 11-30-2020 15:39
    I typically don't use page headers and footers; instead, I use group headers/footers. You can set the group to repeat group headers on each page and then put the T&C in the group footer (set to new page before). Just a thought...

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------