Sage 100

Crystal printing issue in version 2018 PU4 - Has anyone experienced a \C on a sales order invoice printing at the top of the lines when it is not the first line on the lines tab. No changes were made to the form. The customer always enters a \C as the last item number so it is at the bottom of the lines. I have tried various changes to the suppression on the details in a, b and c with no luck so far. The form is attached if anyone has time to take a look.

Is the picking sheet set to print by bin location? Maybe this is now driving invoices?

I'm guessing it's because they are adding the /C at the time of invoicing and not on the SO itself. With the new feature to be able to invoice multiple SO's on one invoice, it sorts the lines (whether you have that new group in your report or not) by the SO number. Since the /C was added in Invoice Data Entry, there is no SO number on that line, therefore it prints it first. If they don't plan to use the new feature you can add a group #4 off the LineSeqNo so it prints in the order they are in SO Inv entry. Just FYI that the .rpt you attached isn't the latest and greatest version of the invoice form. The new one adds a group to print the SO number and Cust PO number from the SO.

No, picking sheet is by order. I tried Jenny's suggestion and that worked. Thank you so much Jenny and thanks for the heads up on the new form information.

yes thanks Jenny, that is a bit of a byproduct of the new feature that I didn't realize

@JennySearl nice catch!!

Thank you for the tip @JennySearl ! We'll certainly be dealing with that in the future, and it is good to be ahead of the issue. (I wonder how long it will take for Sage to come up with a KB article even acknowledging problems with previously customized invoice / packing slip forms...).

I take it this means if the customer wants to take advantage of the multiple SO on one invoice w/SO and PO sort/group then a new form had to be created or the group has to be added onto the existing customized invoice form?

That would be my guess, and I've made a note to look at the new form grouping / sorting in detail (when I have some spare time... or if a customer needs it).

@WayneSchulz Sage created the new form so it would have a group header that prints the SO # and Customer PO#. No matter if you have the new form or an existing one, it still prints the lines in order of SO # unless you add the group that I mentioned above.

We'll eventually have to do some testing to see how the Sort Field is being populated after the change. We've done some odd things with form grouping / sorting for a couple customers.