Report Help

Yahoo Archive
1
With memos I often have to link only by Company and then filter to what I want. There is a performance hit.

In PriceListParts table the values are in arrays like with commissions for reps and you have to parse them out. I suppose they use the ~ (tilde) character like commissions. You may only be seeing the first entry which starts at zero.

-Todd C.

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Thursday, March 24, 2005 2:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Help


I am building some price lists in vantage and am encountering two
problems.

First, historically we have added a memo in the customer file that
stated that customers tier level pricing for a particular product group.
I have built price lists to replace the need for this memo. I do however
have to assign each customer, the appropriate price list. I cannot see
how memo text relates to the customer file. In other words, how can I
create a report that shows me customer name and the memo text that
applies to them?

Second, I am trying to create a report that can be pulled for a user
defined customer that shows their price list detail. When I Create a
report using the PriceListParts table, it will list the parts in the
price list, the Base Price for the part, but the break quantity and
break price show as zero, even though the price list is complete and
functioning properly in Vantage. Anyone know how to get the break price
to show?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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



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 Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129rjq6h8/M=298184.6191685.7192823.3001176/D=groups/S=1705007183:HM/EXP=1111781825/A=2593423/R=0/SIG=11el9gslf/*http://www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=:HM/A=2593423/rand=282027736>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]
2
Just found out that we currently have a person who each week prints
out the Job Traveler (Work Order) and manually goes through them to
find out what materials we will need to make the product. I was
wondering if anyone out there has a report that could do this for
them so they do not have to keep doing this manually. Basically
looking for a report that would give them Job#/MaterialType/Qty and
have it so I can group it by date....I'm working on one now, but
havent been able to get it right yet.

Thanks

STeve
3
Have you tried using the 'Mtl Status' Report from within the Job Tracker?
This can be run for any cutoff date and shows the status of all materials
for the job. It can be run for everything, or you can chose to see just the
exceptions.




-----Original Message-----
From: sbeals@... [mailto:sbeals@...]
Sent: Friday, August 03, 2001 12:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Help

Just found out that we currently have a person who each week prints
out the Job Traveler (Work Order) and manually goes through them to
find out what materials we will need to make the product. I was
wondering if anyone out there has a report that could do this for
them so they do not have to keep doing this manually. Basically
looking for a report that would give them Job#/MaterialType/Qty and
have it so I can group it by date....I'm working on one now, but
havent been able to get it right yet.

Thanks

STeve



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 http://docs.yahoo.com/info/terms/
4
Can't you use the time-phased material requirements or suggestions?

-----Original Message-----
From: sbeals@... [SMTP:sbeals@...]
Sent: Friday, August 03, 2001 11:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Help

Just found out that we currently have a person who each week prints
out the Job Traveler (Work Order) and manually goes through them to
find out what materials we will need to make the product. I was
wondering if anyone out there has a report that could do this for
them so they do not have to keep doing this manually. Basically
looking for a report that would give them Job#/MaterialType/Qty and
have it so I can group it by date....I'm working on one now, but
havent been able to get it right yet.

Thanks

STeve



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 http://docs.yahoo.com/info/terms/
5
Job Management/Reports/Pick List

Rick

sbeals@... wrote:

> Just found out that we currently have a person who each week prints
> out the Job Traveler (Work Order) and manually goes through them to
> find out what materials we will need to make the product. I was
> wondering if anyone out there has a report that could do this for
> them so they do not have to keep doing this manually. Basically
> looking for a report that would give them Job#/MaterialType/Qty and
> have it so I can group it by date....I'm working on one now, but
> havent been able to get it right yet.
>
> Thanks
>
> STeve
>
>
> 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.


[Non-text portions of this message have been removed]
6
Now I think this is kind of what they are looking for, however I
think they were looking for a way to have all the materials needed
printed on one report for a given week.

--- In vantage@y..., Rick Gors <rgors@o...> wrote:
> Job Management/Reports/Pick List
>
> Rick
>
> sbeals@b... wrote:
>
> > Just found out that we currently have a person who each week
prints
> > out the Job Traveler (Work Order) and manually goes through them
to
> > find out what materials we will need to make the product. I was
> > wondering if anyone out there has a report that could do this for
> > them so they do not have to keep doing this manually. Basically
> > looking for a report that would give them Job#/MaterialType/Qty
and
> > have it so I can group it by date....I'm working on one now, but
> > havent been able to get it right yet.
> >
> > Thanks
> >
> > STeve
> >
> >
> > 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.
>
>
> [Non-text portions of this message have been removed]
7
Management needs yesterday!!! a report showing all employee's pay hours and
dollars and have it broke down for direct and indirect.

Anyone willing to share a report that has this or one that will get me on
the way to it quickly?

Thanks.

Jim Moore
GD-OTS
8
Jim,
I have a report that might help. The report works off of labor hours
and not out of the payroll tables. I'll send that group of reports to you
to try out.

Shirley Graver
Systems Administrator
Rubber Associates Inc.
Cleveland/Akron, OH

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Tuesday, July 09, 2002 9:46 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Help


Management needs yesterday!!! a report showing all employee's pay hours
and
dollars and have it broke down for direct and indirect.

Anyone willing to share a report that has this or one that will get me on
the way to it quickly?

Thanks.

Jim Moore
GD-OTS

Yahoo! Groups Sponsor


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.



[Non-text portions of this message have been removed]
9
Thanks to Shirley and Wayne for your help. I have been able to provide MGT
with the info they needed.

-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Tuesday, July 09, 2002 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Report Help


Jim,
I have a report that might help. The report works off of labor hours
and not out of the payroll tables. I'll send that group of reports to you
to try out.

Shirley Graver
Systems Administrator
Rubber Associates Inc.
Cleveland/Akron, OH

-----Original Message-----
From: Moore, Jim (Anniston) [mailto:jmoore@...-ots.com]
Sent: Tuesday, July 09, 2002 9:46 AM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Report Help


Management needs yesterday!!! a report showing all employee's pay hours
and
dollars and have it broke down for direct and indirect.

Anyone willing to share a report that has this or one that will get me on
the way to it quickly?

Thanks.

Jim Moore
GD-OTS

Yahoo! Groups Sponsor


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.



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



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 http://docs.yahoo.com/info/terms/
10
I am building some price lists in vantage and am encountering two
problems.

First, historically we have added a memo in the customer file that
stated that customers tier level pricing for a particular product group.
I have built price lists to replace the need for this memo. I do however
have to assign each customer, the appropriate price list. I cannot see
how memo text relates to the customer file. In other words, how can I
create a report that shows me customer name and the memo text that
applies to them?

Second, I am trying to create a report that can be pulled for a user
defined customer that shows their price list detail. When I Create a
report using the PriceListParts table, it will list the parts in the
price list, the Base Price for the part, but the break quantity and
break price show as zero, even though the price list is complete and
functioning properly in Vantage. Anyone know how to get the break price
to show?

Thanks
Todd Hofert
IT Director
Spartan Graphics, Inc.



This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

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