R04570 is sorting by Address number not by Alphaname and invoice number.

[Jenny]

We upgraded from JDE XE to Peoplesoft 8.10.

After upgrade UBE R04570 report is not sorting by Alpha name and invoice number. It is sorting by address number. But in data sequencing we have Alpha name and invoice number, there is no address number.
I would like to sort by Alpha name and invoice number. Please help to solve this issue.

Win 2000, EO8.10, SQL server

 

[eagleralph]

Jenny,

You can specify data sequencing 3 different places in OneWorld as follows:

1. Using the data sequencing on the version.
2. Data sequencing at the individual UBE section level.
3. In the initialize section of a UBE using a "Set Sequence" system function.

You will have to research what overrides what if data sequencing is specified at more than one of these levels.

Check each of these and see which ones are being used and adjust accordingly to fix your problem.

Hope this helps.

Danny McMillian

Jenny <[email protected]> wrote:
We upgraded from JDE XE to Peoplesoft 8.10.

After upgrade UBE R04570 report is not sorting by Alpha name and invoice number. It is sorting by address number. But in data sequencing we have Alpha name and invoice number, there is no address number.
I would like to sort by Alpha name and invoice number. Please help to solve this issue.

Win 2000, EO8.10, SQL server