Hi, the easiest way is to find a index field which meets your sorting needs. Then you create an index for that field (or find an existing one) and just change the "index" property on the datasource of your form to that index - voilÃ, that's it ;-)) hth Tobias
-----UrsprÃngliche Nachricht-----
Von: lourens1210 [mailto:[EMAIL PROTECTED]
Gesendet: Do 30.12.2004 12:21
An: Axapta-Knowledge-Village@yahoogroups.com
Cc:
Betreff: [Axapta-Knowledge-Village] Sort order on Customer Accounts
Hi All
Urgently need help with a problem sorting customer accounts. Our
client decided on a 'open' structure for their customer account
codes, meaning any number of alpha characters. What happens is that
Axapta stores these codes with spaces in front, eg.: _ _ _ABC in a 6
wide field. When sorting _ _ _ _ YZ and _ _ _ABC ascending, YZ is
above ABC - this follows ASCI sorting rules - no problem, except for
the guy working with the data set!
The InventTable does not pad with spaces in front like the CustTable.
I have changed the Extended Data Types for Justification and
Alignment, at the lowest level, to be similar between the CustTable
and the InventTable. Have re-indexed, rebooted, re-imported,
recreated and just about any other re- you can think of, but with no
joy.
How do I get the CustTable to behave like the InventTable!!
Please help
Lourens Botha
------------------------ Yahoo! Groups Sponsor --------------------~-->
$4.98 domain names from Yahoo!. Register anything.
http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
<<winmail.dat>>
