FASTR row account range question

[Tim_Miller]

This is probably a stupid question, but I'm asking it anyway just to
make sure. When specifying a range of accounts in FASTR row specs, are
the accounts sequenced in the same order as they would appear on the
Accounts by BU screen (V0901)? I was working on a FASTR and found out
that specifying 7010.1 through 7010.10 does not include 7010.3, which I
assumed it would. I just want to make sure I understand how it works in
case this comes up again in the future. Thanks.

Tim Miller
Financial Systems Analyst
Ph. 913-814-2609
Fax 913-814-5573
A7.3 c13

 

[ian_morton99]

Tim,

7010.3 would be excluded as it is not between the values 7010.1 and 7010.10.
It's been a while since I have worked on World, but I believe it would
view that range the same way as Excel, meaning any 7010.1* value would come
before any 7010.3* value.

Hope this helps.


Ian Morton
Peregrine Group, Inc.





----Original Message Follows----
From: Tim_Miller <[email protected]>
Reply-To: [email protected]
To: [email protected]
Subject: FASTR row account range question
Date: Thu, 6 Feb 2003 17:02:18 -0800 (PST)

This is probably a stupid question, but I'm asking it anyway just to
make sure. When specifying a range of accounts in FASTR row specs, are
the accounts sequenced in the same order as they would appear on the
Accounts by BU screen (V0901)? I was working on a FASTR and found out
that specifying 7010.1 through 7010.10 does not include 7010.3, which I
assumed it would. I just want to make sure I understand how it works in
case this comes up again in the future. Thanks.
Tim Miller
Financial Systems Analyst
Ph. 913-814-2609
Fax 913-814-5573
A7.3 c13
--------------------------
To view this thread, visit the JDEList forum at:
http://www.jdelist.com/ubb/showflat.php?Cat=&Board=W&Number=49366
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World™ mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail



Ian Morton
Peregrine Group, Inc.

 

[Colin_Hugill]

Hey there Tim,

There is an old saying about "assume".

Think through your select statement - why the dickens would 7010.3 be
included in the range you specified? Check against the sort specification
values associated with the AS/400!

As for sequencing, this is controlled through either the General
Specifications detail or the Row Specifications depending what you are
doing.


----- Original Message -----
From: "Tim_Miller" <[email protected]>
To: <[email protected]>
Sent: Friday, February 07, 2003 11:58 AM
Subject: FASTR row account range question





Colin Hugill
Consultant
(World A7.3 cum12)

 

[SallyWhite]

TIm,

If you view the video T/B for this BU, I think you will find that 7010.10 sorts above 7010.3 because these are character fields, not numeric. If your subsidiary accounts were all 2 positions (i.e., 01, 03, 10), then you would get the desired FASTR row results by specifying 7010.01 through 7010.10. HTH!