Accpac Sort Order

[dtmb]

Is there a way to change the sort order for accpac inventory worksheets, its currently set to category then item number. Could it be changed to category them item description.

Thanks.

 

[Jay Converse]

What I/C version? And do you want to change the report or the UI?

 

[dtmb]

My bad 5.3A, It will be great if the UI couls be changed.

Thanks.

 

[Jay Converse]

Yeah, it is pretty stupid that you can sort all those different ways, except for Item Description.

The way to cheat is to generate it, then use a query to update ICWKUH.SORTCODE and ICWKUD.SORTCODE with ICITEM.ITEMDESC.

 

[Jay Converse]

I mean ITEM.DESC.

 

[dtmb]

Thats sounds pretty interesting. It would be good if you could give a step by step procedure.

 

[dtmb]

thats is for the query update.

 

[Jay Converse]

This is off the top of my head, something like:

UPDATE ICWKUH INNER JOIN ICITEM ON ICWKUH.ITEMNO = ICITEM.ITEMNO SET ICWKUH.SORTCODE = "ICITEM"."DESC"

 

[dtmb]

Will try that.


Thanks

 

[dtmb]

Had to go the long old route eventually, thanks for the help.