Sage 100

**v2015 - Crystal PO form section suppression incorrectly impacting ""Continued"" and ""Totals"" sections** On the PO form in the details b section, we've edited the suppression formula to be: {PO_PurchaseOrderWrk.ItemType} = ""4"" or {@Qty Balance} <= 0. It's that 2nd part, which is QtyOrd minus QtyRecd, that causes a single page PO to display ""Continued"" in lower right of PO form instead of the Totals section - and this only happens with _Backordered-status PO's that have backorder qtys on the lines_. If I simply remove that 2nd part of the suppression formula, the Totals section prints fine. I don't get it. If I add that addt'l suppression to the STANDARD form, no issues. I can't figure out what's different between our custom form and STANDARD. And apparently the client says it was working fine previously but no one is aware of any changes that have been made. And if I try their older PO form from last year, it does the same thing. Also, I can make this happen on my local system with their custom form.

Maybe a null value slipped into the Qty Balance calc? If you post the form I can take a peek.

Thanks, @SteveIwanowski. Attached. I too had a slight thought about maybe some null setting/value being the culprit, but I didn't see anything. I'm praying you can find something.

It's pretty hinky either way...

I'm able to duplicate the issue, so I guess that's good news. In my scenario, the Qty Ordered and Qty Received are both zero on the back ordered item, so I have no detail lines that actually show when I see the Continued. If I force a detail line to show, the Totals show up correctly. I wonder if this is just a sorting issue. Does the backordered item happen to be the last line item? What happens if you move it up?

For me, it's the OnLastRecord that's not triggering correctly. Placing a small empty Detail line 'fixes' it, though I can't explain at all why...

I have a couple concerns with this approach. 1. Not every item on PO (/M) will have Qty Ordered and Qty Received, and 2. suppressing items may omit them from PO, but there can be more records in temp file, so the OnLastRecord or NextValue formulas won't work.

Brett, Edit the two problem sections as follows: 'Page Footer A Suppress Formula - the ""Continued"" section '-------------------------------- formula = OnLastRecord or ({PO_PurchaseOrderWrk.PurchaseOrderNo} + {PO_PurchaseOrderWrk.LineSeqNo}) <> (NextValue({PO_PurchaseOrderWrk.PurchaseOrderNo}) + NextValue({PO_PurchaseOrderWrk.LineSeqNo})) 'Page Footer B Suppress Formula- the ""Totals"" section '-------------------------------- formula = ({PO_PurchaseOrderWrk.PurchaseOrderNo} + {PO_PurchaseOrderWrk.LineSeqNo}) = (NextValue({PO_PurchaseOrderWrk.PurchaseOrderNo}) + NextValue({PO_PurchaseOrderWrk.LineSeqNo}))

Finally getting back to this. @ChrisStAmand, that worked!! Thanks so much, and others! So I assume this is needed because of the addt'l 'or {@Qty Balance} <= 0' criteria that we have in the details b section suppression formula, along with what I just realized (as @SteveIwanowski alluded to)if the last line on the PO is a suppressed line. If a backordered line is the last line on the PO, this issue doesn't occur.

@ChrisStAmand, I hate to do this to you, but the PO form is now printing the Totals section on all pages of a multiple-page PO, instead of just on the last page. Currently I have the following Section suppression in place: - PF a (Contined): formula = OnLastRecord or ({PO_PurchaseOrderWrk.PurchaseOrderNo} + {PO_PurchaseOrderWrk.LineSeqNo}) <> _ (NextValue({PO_PurchaseOrderWrk.PurchaseOrderNo}) + NextValue({PO_PurchaseOrderWrk.LineSeqNo})) - PF b (Totals): formula = ({PO_PurchaseOrderWrk.PurchaseOrderNo} + {PO_PurchaseOrderWrk.LineSeqNo}) = _ (NextValue({PO_PurchaseOrderWrk.PurchaseOrderNo}) + NextValue({PO_PurchaseOrderWrk.LineSeqNo}))

So I've changed the Section suppression formulas as follows, and it seems to be working fine - and I tested both Quick Printing a single PO and printing multiple PO's. @ChrisStAmand and anyone else, do you see any issues with this? I'm wondering why the standard PO form (and other forms) don't just have this logic instead of the ""OnLastRecord"", ""NextValue"", etc. logic. - PF a (Contined): formula = PageNumber = TotalPageCount - PF b (Totals): formula = PageNumber <> TotalPageCount

Nice Work Zip!!