Mark, Select the field for your account number then choose "in range". Enter the first account number comma then the last account number. IE: '34101','34105'
Regards
Shirley Slattery
Mark Smith <mark_smith@...> wrote: Wayne,
Thanks, I just figured that out before your message. Additionally, I would
like to search the codes in ExpenseChart in the following manner: 341001 to
341005. How can I filter these ranges (ie, what is the statement needed)?
Thanks,
Mark Smith
IT Manager
Innerpac, Inc.
(708) 863-8300
-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Monday, March 11, 2002 9:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vendor Master Table
At 08:59 AM 3/11/2002 -0600, you wrote:
screen: a raw GL number and an AP Expense Code. If you're looking for
the later, it's in Vendor.APAcctId. You can join to the APAcct table if
you need the description or account numbers associated with the code.
If you want the raw GL account, then yes, it's split into Vendor.ExpenseDiv
ExpenseDept and ExpenseChart. The GL#s are always broken out like that in
all of the database. For configuration flexibility, Vantage lets you
choose what order they print in but it really always maintains them as
separate fields.
-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1015859387%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
[Non-text portions of this message have been removed]
Regards
Shirley Slattery
Mark Smith <mark_smith@...> wrote: Wayne,
Thanks, I just figured that out before your message. Additionally, I would
like to search the codes in ExpenseChart in the following manner: 341001 to
341005. How can I filter these ranges (ie, what is the statement needed)?
Thanks,
Mark Smith
IT Manager
Innerpac, Inc.
(708) 863-8300
-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Monday, March 11, 2002 9:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vendor Master Table
At 08:59 AM 3/11/2002 -0600, you wrote:
>So, in order to pull information from G/L Expense I need to use aThere are two different fields you can fill in on the Vendor Maintenance
>combination of these 3 fields? I am trying to pull G/L Expense codes.
screen: a raw GL number and an AP Expense Code. If you're looking for
the later, it's in Vendor.APAcctId. You can join to the APAcct table if
you need the description or account numbers associated with the code.
If you want the raw GL account, then yes, it's split into Vendor.ExpenseDiv
ExpenseDept and ExpenseChart. The GL#s are always broken out like that in
all of the database. For configuration flexibility, Vantage lets you
choose what order they print in but it really always maintains them as
separate fields.
-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1015859387%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
[Non-text portions of this message have been removed]