Outstanding purchase orders related to jobs

Bobby, I have a material status report showing linked po, linked job, due
dates, etc if you are interested. This would be for 5.2. Contact me at
ssims@... if you are interested.

-----Original Message-----
From: bobby_ssandhu [mailto:bss@...]
Sent: Tuesday, August 24, 2004 8:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] outstanding purchase orders related to jobs


Hi
Could someone please tell me how I can link records in the PORel
table to the JobMtl records. I need to write a report on all
purchase orders outstanding related to particular jobs (including
mtl seq and assembly seq). Something like the Job Material Status
Report. If it should not be written with the JobMtl table then which
tables can I use?
Thanks a lot!
Bobby




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
Hi
Could someone please tell me how I can link records in the PORel
table to the JobMtl records. I need to write a report on all
purchase orders outstanding related to particular jobs (including
mtl seq and assembly seq). Something like the Job Material Status
Report. If it should not be written with the JobMtl table then which
tables can I use?
Thanks a lot!
Bobby
I think all of the information you need is in the PORel table. Just filter your report to only include open releases, and JobNo >0.

We have a Crystal Report we use for PO Expediting if you'd like to see it.

Gail

-----Original Message-----
From: bobby_ssandhu [mailto:bss@...]
Sent: Tuesday, August 24, 2004 9:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] outstanding purchase orders related to jobs


Hi
Could someone please tell me how I can link records in the PORel
table to the JobMtl records. I need to write a report on all
purchase orders outstanding related to particular jobs (including
mtl seq and assembly seq). Something like the Job Material Status
Report. If it should not be written with the JobMtl table then which
tables can I use?
Thanks a lot!
Bobby



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=129qk11a8/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1093483749/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=330329061>


_____

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]
I am almost finished writing a similar report. I used the Jobmtl and POrel tables. Please contact me offline if you want a copy of my report.


Abe,



----- Original Message -----
From: bobby_ssandhu
To: vantage@yahoogroups.com
Sent: Tuesday, August 24, 2004 9:28 PM
Subject: [Vantage] outstanding purchase orders related to jobs


Hi
Could someone please tell me how I can link records in the PORel
table to the JobMtl records. I need to write a report on all
purchase orders outstanding related to particular jobs (including
mtl seq and assembly seq). Something like the Job Material Status
Report. If it should not be written with the JobMtl table then which
tables can I use?
Thanks a lot!
Bobby



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





------------------------------------------------------------------------------
Yahoo! Groups Links

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

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



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