Customer and Parts question

system · October 5, 2007, 12:12pm

We are new to this and have little documentation. Can you tell me a
bit about this seperate repository?

I was thinking that the best way to get what we need for web users is
use the vantage user, control company access by access level(access
levels are named companyid) and for addresses use the customer
contacts.

Have you done anything yet with searching and displaying customer
parts on the web? We can't join the 2 with the business objects.

--- In vantage@yahoogroups.com, "C. Lu" <cminglu@...> wrote:
>
> I am pretty much doing the same thing.
>
> As for (2), I don't think Custcnt will have the
> ability to log in though.
>
> I am planning to use a seperate repository to store
> the mapping between the customer login and the Vantage
> Customer, and creating a super web-user in handling
> the Vantage access.
>
> Hope this helps.
>
> --Charlie
>
> --- genui1 <atkins.jason@...> wrote:
>
> > We are creating web sites for our customers to place
> > orders for their
> > parts.
> >
> > 1).
> > Our customers are specifically related to parts we
> > have in inventory
> > (using custxprt).
> >
> > We would like to be able to get a list of all
> > customer parts (get full
> > part dataset for parts filtered based on company
> > realition). The
> > location of this relation is in 2 spereate tables
> > and business objects.
> >
> >
> > Is there some way to easily join the Part and
> > CustXPart business object?
> > We looked into doing a join or addint to the
> > PartList where clause
> > something like 'where partnum in ( select partnum
> > from custxpart where
> > custnum=2)' but the where clauses in business
> > objects do not seem to
> > like having a secondary where in them.
> >
> > How do we join these?
> >
> > 2).
> > We want to give our customers the ability to login
> > with a password and
> > are confused as to which user we should use. There
> > are 3 types as I
> > see it: 1. System User (userfile) 2. Web user
> > (webuser) 3. Customer
> > Contact (custcnt)
> >
> > The System User seems to have the best business
> > object methods to use
> > as a web user but it has no way of relating to a
> > customer.
> >
> > We also want to link multiple addresses to a
> > customer user/contact.
> >
> >
> >
> >
> > 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
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
>
>
>
>
______________________________________________________________________
______________
> Check out the hottest 2008 models today at Yahoo! Autos.
> http://autos.yahoo.com/new_cars.html
>

system · October 5, 2007, 10:54am

We are creating web sites for our customers to place orders for their
parts.

1).
Our customers are specifically related to parts we have in inventory
(using custxprt).

We would like to be able to get a list of all customer parts (get full
part dataset for parts filtered based on company realition). The
location of this relation is in 2 spereate tables and business objects.

Is there some way to easily join the Part and CustXPart business object?
We looked into doing a join or addint to the PartList where clause
something like 'where partnum in ( select partnum from custxpart where
custnum=2)' but the where clauses in business objects do not seem to
like having a secondary where in them.

How do we join these?

2).
We want to give our customers the ability to login with a password and
are confused as to which user we should use. There are 3 types as I
see it: 1. System User (userfile) 2. Web user (webuser) 3. Customer
Contact (custcnt)

The System User seems to have the best business object methods to use
as a web user but it has no way of relating to a customer.

We also want to link multiple addresses to a customer user/contact.

system · October 5, 2007, 11:09am

Off the top of my head, thinking out loud....

You are going to control web access by an ID and password. That
ID/Password would determine the query back to the database which
limits the results to just that ID/Password....

Use an ODBC / SQL query to retrieve info from database where the
tables can be joined very easily.

Then, depending on what you want to do with the data, you can connect
to business objects/ web services to perform that function..

bw

--- In vantage@yahoogroups.com, "genui1" <atkins.jason@...> wrote:
>
> We are creating web sites for our customers to place orders for
their
> parts.
>
> 1).
> Our customers are specifically related to parts we have in
inventory
> (using custxprt).
>
> We would like to be able to get a list of all customer parts (get
full
> part dataset for parts filtered based on company realition). The
> location of this relation is in 2 spereate tables and business
objects.
>
>
> Is there some way to easily join the Part and CustXPart business
object?
> We looked into doing a join or addint to the PartList where clause
> something like 'where partnum in ( select partnum from custxpart
where
> custnum=2)' but the where clauses in business objects do not seem
to
> like having a secondary where in them.
>
> How do we join these?
>
> 2).
> We want to give our customers the ability to login with a password
and
> are confused as to which user we should use. There are 3 types as
I
> see it: 1. System User (userfile) 2. Web user (webuser) 3.
Customer
> Contact (custcnt)
>
> The System User seems to have the best business object methods to
use
> as a web user but it has no way of relating to a customer.
>
> We also want to link multiple addresses to a customer user/contact.
>

system · October 5, 2007, 11:28am

We need some reports in Crystal for our implementation.

The first one we need is what we call an Alert List. It is a variant of
the AR aging report. It includes the Account Number, Customer Name,
Sales Person, Over 58 Days $, Over 96 Days $, Over 91 Days, On Hold, and
Notes. Does anyone have something close that they are willing to share?
I just don't want to recreate the wheel if it is already out there.

Thanks!

Dale Kalsow | Information Technologies Director
____________________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... | * http://determan.com/

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

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

system · October 5, 2007, 11:49am

I am pretty much doing the same thing.

As for (2), I don't think Custcnt will have the
ability to log in though.

I am planning to use a seperate repository to store
the mapping between the customer login and the Vantage
Customer, and creating a super web-user in handling
the Vantage access.

Hope this helps.

--Charlie

--- genui1 <atkins.jason@...> wrote:

> We are creating web sites for our customers to place
> orders for their
> parts.
>
> 1).
> Our customers are specifically related to parts we
> have in inventory
> (using custxprt).
>
> We would like to be able to get a list of all
> customer parts (get full
> part dataset for parts filtered based on company
> realition). The
> location of this relation is in 2 spereate tables
> and business objects.
>
>
> Is there some way to easily join the Part and
> CustXPart business object?
> We looked into doing a join or addint to the
> PartList where clause
> something like 'where partnum in ( select partnum
> from custxpart where
> custnum=2)' but the where clauses in business
> objects do not seem to
> like having a secondary where in them.
>
> How do we join these?
>
> 2).
> We want to give our customers the ability to login
> with a password and
> are confused as to which user we should use. There
> are 3 types as I
> see it: 1. System User (userfile) 2. Web user
> (webuser) 3. Customer
> Contact (custcnt)
>
> The System User seems to have the best business
> object methods to use
> as a web user but it has no way of relating to a
> customer.
>
> We also want to link multiple addresses to a
> customer user/contact.
>
>
>
>
> 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
> Yahoo! Groups Links
>
>
>
>
>

____________________________________________________________________________________
Check out the hottest 2008 models today at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html

system · October 5, 2007, 11:50am

You just need to create a new AR Aging Report in Vantage with the
Over Days for each category you require. You can create as many
variations as you want. - Monte

--- In vantage@yahoogroups.com, "Dale R. Kalsow" <dale.r.kalsow@...>
wrote:

>
> We need some reports in Crystal for our implementation.
>
>
>
> The first one we need is what we call an Alert List. It is a

variant of

> the AR aging report. It includes the Account Number, Customer Name,
> Sales Person, Over 58 Days $, Over 96 Days $, Over 91 Days, On

Hold, and

> Notes. Does anyone have something close that they are willing to

share?

> I just don't want to recreate the wheel if it is already out there.
>
>
>
> Thanks!
>
>
>
> Dale Kalsow | Information Technologies Director
> ____________________________________________________________________
> Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432
>
> * Phone: (763) 502-9689 | * Fax: (763) 571-1789
>
> * dale.r.kalsow@... | * http://determan.com/
>
>
>
> "Ambition is the path to success. Persistence is the vehicle you

arrive

> in."
>
>
>
> Electronic Privacy Notice. This e-mail, and any attachments,

contains

> information that is, or may be, covered by the Electronic

Communications

> Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
> proprietary in nature. If you are not the intended recipient,

please be

> advised that you are legally prohibited from retaining, using,

copying,

> distributing, or otherwise disclosing this information in any

manner.

> Instead, please reply to the sender that you have received this
> communication in error, and then immediately delete it. Thank you in
> advance for your cooperation.
>
> ________________________________
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · October 5, 2007, 11:53am

Yes - thank you, I understand that - I was hoping for something a little
closer.

Dale Kalsow | Information Technologies Director
____________________________________________________________________
Determan Brownie, Inc. | 1241 72nd Avenue NE | Minneapolis, MN 55432

* Phone: (763) 502-9689 | * Fax: (763) 571-1789

* dale.r.kalsow@... | * http://determan.com/

"Ambition is the path to success. Persistence is the vehicle you arrive
in."

Electronic Privacy Notice. This e-mail, and any attachments, contains
information that is, or may be, covered by the Electronic Communications
Privacy Act, 18 U.S.C. 2510-2521, and is also confidential and
proprietary in nature. If you are not the intended recipient, please be
advised that you are legally prohibited from retaining, using, copying,
distributing, or otherwise disclosing this information in any manner.
Instead, please reply to the sender that you have received this
communication in error, and then immediately delete it. Thank you in
advance for your cooperation.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Monte Tomerlin
Sent: Friday, October 05, 2007 10:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03 Report

You just need to create a new AR Aging Report in Vantage with the
Over Days for each category you require. You can create as many
variations as you want. - Monte

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Dale R. Kalsow" <dale.r.kalsow@...>
wrote: