Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accpac Sort Order

Status
Not open for further replies.

dtmb

Technical User
Joined
Jan 22, 2007
Messages
54
Location
JM
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.
 
What I/C version? And do you want to change the report or the UI?
 
My bad 5.3A, It will be great if the UI couls be changed.

Thanks.
 
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.

 
Thats sounds pretty interesting. It would be good if you could give a step by step procedure.
 
thats is for the query update.
 
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"

 
Will try that.


Thanks
 
Had to go the long old route eventually, thanks for the help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top