Vendor Master Table

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:
>So, in order to pull information from G/L Expense I need to use a
>combination of these 3 fields? I am trying to pull G/L Expense codes.

There are two different fields you can fill in on the Vendor Maintenance
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]
Hi,

I am trying to create an apparently simple report from the Vendor
Master Table using VendorID, Name, Approved (status) and G/L
Expense. However, I am unable to locate the G/L Expense field
anywhere in the table. It does however appear as a field on the
screen.

Thanks in advance,

Mark
3 separate fields in vendor master: expensediv, expensedept, expensechart



[Non-text portions of this message have been removed]
So, in order to pull information from G/L Expense I need to use a
combination of these 3 fields? I am trying to pull G/L Expense codes.

Thanks,

Mark Smith
IT Manager
Innerpac, Inc.
(708) 863-8300

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Monday, March 11, 2002 8:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vendor Master Table

3 separate fields in vendor master: expensediv, expensedept, expensechart



[Non-text portions of this message have been removed]




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=1015858198%
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]
At 08:59 AM 3/11/2002 -0600, you wrote:
>So, in order to pull information from G/L Expense I need to use a
>combination of these 3 fields? I am trying to pull G/L Expense codes.

There are two different fields you can fill in on the Vendor Maintenance
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
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 a
>combination of these 3 fields? I am trying to pull G/L Expense codes.

There are two different fields you can fill in on the Vendor Maintenance
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]
Sarah is right. G/L Expense code in the Vendor Master is generated from
ExpenseDiv, ExpenseChard, ExpenseDept. In order to combine this 3 code
together is depending on your Configuration of you Account Format setup (eg.
Div-Dept-Chart, Div-Chart-Dept....) ring a bell?
Best Regard,
Richard Chuah
e-Business Specialist
Simplicity Technologies Sdn Bhd
Tel: +6 03 7880 3550 Ext. 303
Fax: +6 03 7880 3055
Mobile +6 012 488 5745
Email: richard.chuah@...

This information sent is intended only for the person or entity to which it
is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or talking of any
action in reliance upon, this information by persons or entities other than
the intended recipient is prohibited. If you received this in error, please
contact the sender and delete the material from any storage devices.

-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Monday, March 11, 2002 10:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vendor Master Table


Hi,

I am trying to create an apparently simple report from the Vendor
Master Table using VendorID, Name, Approved (status) and G/L
Expense. However, I am unable to locate the G/L Expense field
anywhere in the table. It does however appear as a field on the
screen.

Thanks in advance,

Mark



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=1015857939
%3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1
>

<http://us.adserver.yahoo.com/l?M=215002.1818248.3328688.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=917659380>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<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]