Report R04570- sort by Alpha name and Invoice number.sz

[Jenny]

We have recently upgraded from Oneworld Xe to Peoplesoft EO 8.10. In Onework Xe, report R04570’s output used to sort by Alpha name and Invoice number. But after Peoplesoft EO 8.10 upgrade, report R04570’s output is sorting by address number. We need to display by Alpha name and Invoice number. Any help will be greatly appreciated.

Windows 2000, EO 8.10, SQL server 2000
Thanks in advance

 

[Ray Justus]

The data sequencing setting of the Create Payment Control Groups UBE (R04570) versions controls the order in which records are written to the A/P Payment Processing tables (F04571, F04572 and F04573) from the Accounts Payable Ledger table (F0411).

The Sequence ID on the Printing tab of the Processing Options for Create Payment Control Groups UBE (R04570) is for the check printing sequence. Different Payment Sequence IDs can be set up in the Payment Sequence application (P0415) on the OneWorld menu, G04411. Sequence selection items are controlled by the UDC, H04|SF. You cannot add to this list because the available selections are hard coded in the Print Automatic Payments UBEs (R04572 and R04572J). Only "PYE", "ATT", "ALPP", "AN8", "ALPH", "CRC", "STUB", "CO", "TNST", "CBNK", "DL01", "ADSA", "PAAP", "VLDT", "AC01", "AC02", "AC03", "AC04", "AC05", "RMK", "PO", "PDCT", "PKCO" and "MCU" may be used.

Workaround: To make checks print in the same order as all our other documents, we added HDC, Payment Control Group Number, and CKC, Check Control Number AP Check, to the UDC, H04|SF. We then set up a Sequence ID with these two selections. Since these two items are not in the code, they will be ignored, defaulting the order to the primary key of the F04572 – HDC, CKC. The order that records are written to the F04572 is determined by the data sequence settings in the R04570.

 

[Jenny]

I have created different combination of Seq Id to test the display order. But nothing got reflected in report R04570. Finally I have added ‘set user sequence’ alpha name, invoice# in report R04570’s event rule (Initialize). Now report is sorting by alpha name, invoice#.

Thanks for your help.
Jenny

 

[Ray Justus]

Re: Report R04570 - sort by Alpha name and Invoice numbers

The first three data sequence items in the data sequencing setting of R04570 must be PYIN, GLBA, and CRCD. If you do not leave these items as is, you may get unpredictable results in the level breaks. Always place your desired additional data sequencing items after these three items.