Material requirements without using MRP - Vantage 8.03

Brian, unfortunately the group does not allow attachments in emails, however, people have been able to send hyperlinks of what they are trying to show.  Go down that route.

Now how Miguel is able to see it is beyond me since I use outlook as well and cannot see your screen shot.  I guess Miguel is special!

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 24, 2015 6:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Material requirements without using MRP - Vantage 8.03

 

 

Well, I guess it won't allow me to insert the screenshot, but you should understand at what point I am stuck.

Thanks,

Brian

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

In 9.05 I have been able to create my own custom TimePhase using a BAQ to Dashboard Report.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:44
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

Manasa, I thought Time Phase Material Requirements were based on MRP running?  As stated, we do not have MRP…..Am I wrong?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

You know I have no idea if it changed between 8.03 and 9.05…we do not have MRP and we do use the report.

Try it out….couldn’t hurt….

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 11:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

Manasa, I thought Time Phase Material Requirements were based on MRP running?  As stated, we do not have MRP…..Am I wrong?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

Thanks Manasa, I think that will do the trick, looks like it’s find and doesn’t need MRP….

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 11:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You know I have no idea if it changed between 8.03 and 9.05…we do not have MRP and we do use the report.

Try it out….couldn’t hurt….

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 11:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

Manasa, I thought Time Phase Material Requirements were based on MRP running?  As stated, we do not have MRP…..Am I wrong?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

Good to hear! 

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 2:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

Thanks Manasa, I think that will do the trick, looks like it’s find and doesn’t need MRP….

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 11:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You know I have no idea if it changed between 8.03 and 9.05…we do not have MRP and we do use the report.

Try it out….couldn’t hurt….

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 11:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

Manasa, I thought Time Phase Material Requirements were based on MRP running?  As stated, we do not have MRP…..Am I wrong?

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

Why not  just  generate  po  suggestions?
Le vendredi 23 janvier 2015, Manasa Reddy mreddy@... [vantage] <vantage@yahoogroups.com> a écrit :

Â
<div>
  
  
  <p>

You don’t like Time Phase? Not the actual screen but there is a report. And it has filters.

Manasa

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

Â

Â

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders. We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out. Anyone else out there tried to do this before??

Â

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:Â Â Â 931.432.8408
Mobile:Â 615.418.3055
Â
email:Â MAbell@...

Â

</div>
 


<div style="color:#fff;min-height:0;"></div>


--

Amélie Pelletier

Analyste Programmeur /
Program analyst

Â

 Groupe Bertec

230, Boulevard Nilus-Leclerc

L'Islet, Québec (Canada)

G0R 2C0

Téléphone: 418-247-3986 ext.
2390

Fax: 418-247-7925

amelie.pelletier@…

P Est-ce
nécessaire d’imprimer ce message?

Please consider the environment before
printing this email
.



Amelie is right, you can run PO Suggestion without MRP….this will create the demand schedule and then you can run that report I mentioned.  Time Phased Matl Requirements.

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Sunday, January 25, 2015 8:41 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

Why not  just  generate  po  suggestions?
Le vendredi 23 janvier 2015, Manasa Reddy mreddy@... [vantage] <vantage@yahoogroups.com> a écrit :

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 



--

Amélie Pelletier

Analyste Programmeur / Program analyst

 

 Groupe Bertec

230, Boulevard Nilus-Leclerc

L'Islet, Québec (Canada)

G0R 2C0

Téléphone: 418-247-3986 ext. 2390

Fax: 418-247-7925

amelie.pelletier@...

P Est-ce nécessaire d’imprimer ce message?
Please consider the environment before printing this email.

 

Mike, I think you have your answer, but I will give my 2 cents anyway.


Everyone is correct, you don't need MRP for the system to generate PO Suggestions or to populate the Time Phase Material Requirements Report.  The system has simple base MRP functionality out of box.  I have run 8.03.409C and 8.03.408, both without MRP and had everything I needed.  You can even populate your Inventory Min/Max numbers, and Kan Ban Min/Max numbers, and the Time Phase Material Requirements Report will give you the projections you need based on Sales Orders, Jobs, and Purchase Demands.


From there you can obviously get fancy and write a nice report, as the out of box Progress Report isn't the prettiest...assuming you are still on 8.x.  As it was said you can also you the New PO Suggestions screen and the Change PO Suggestion screen to see your demands and changes.


Best of luck.  But, you really have what you need.


Jeff

Guys, I can never tell you how grateful I am to have this support board for people like myself who really need the help.  Thank you all for the answers as this was EXACTLY what I needed to hear.   Does anyone know what table(s) hold the information that the TimePhase Material requirement uses for its report?  I’m betting it is something that is generated “on the fly” in temp tables and programs that run but I can wish J.  I am a Crystal Reports guru here and if I had the information in Vantage somewhere, I know I could make a report that would give them exactly what they need as you are correct, the Vantage canned report is terrible.  Thanks again guys for all your help…

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, January 26, 2015 7:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Material requirements without using MRP - Vantage 8.03

 

 

Mike, I think you have your answer, but I will give my 2 cents anyway.

 

Everyone is correct, you don't need MRP for the system to generate PO Suggestions or to populate the Time Phase Material Requirements Report.  The system has simple base MRP functionality out of box.  I have run 8.03.409C and 8.03.408, both without MRP and had everything I needed.  You can even populate your Inventory Min/Max numbers, and Kan Ban Min/Max numbers, and the Time Phase Material Requirements Report will give you the projections you need based on Sales Orders, Jobs, and Purchase Demands.

 

From there you can obviously get fancy and write a nice report, as the out of box Progress Report isn't the prettiest...assuming you are still on 8.x.  As it was said you can also you the New PO Suggestions screen and the Change PO Suggestion screen to see your demands and changes.

 

Best of luck.  But, you really have what you need.

 

Jeff

Take a look at PartDtl

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, January 26, 2015 9:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Material requirements without using MRP - Vantage 8.03


Guys, I can never tell you how grateful I am to have this support board for people like myself who really need the help. Thank you all for the answers as this was EXACTLY what I needed to hear. Does anyone know what table(s) hold the information that the TimePhase Material requirement uses for its report? I’m betting it is something that is generated “on the fly” in temp tables and programs that run but I can wish J. I am a Crystal Reports guru here and if I had the information in Vantage somewhere, I know I could make a report that would give them exactly what they need as you are correct, the Vantage canned report is terrible. Thanks again guys for all your help…

Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...<mailto:MAbell@...>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, January 26, 2015 7:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Material requirements without using MRP - Vantage 8.03



Mike, I think you have your answer, but I will give my 2 cents anyway.



Everyone is correct, you don't need MRP for the system to generate PO Suggestions or to populate the Time Phase Material Requirements Report. The system has simple base MRP functionality out of box. I have run 8.03.409C and 8.03.408, both without MRP and had everything I needed. You can even populate your Inventory Min/Max numbers, and Kan Ban Min/Max numbers, and the Time Phase Material Requirements Report will give you the projections you need based on Sales Orders, Jobs, and Purchase Demands.



From there you can obviously get fancy and write a nice report, as the out of box Progress Report isn't the prettiest...assuming you are still on 8.x. As it was said you can also you the New PO Suggestions screen and the Change PO Suggestion screen to see your demands and changes.



Best of luck. But, you really have what you need.



Jeff



[Non-text portions of this message have been removed]
Patrick, I have been struggling trying to create a custom timephase in 9.05.702a.  Can you please explain how you created your custom timephase?  What tables are you using?  Would you be able to share/upload your actual dashboard?

I appreciate any help you can send my way on this topic.

Thank you in advance.

Brian

---In vantage@yahoogroups.com, <pjw@...> wrote :

#ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:"Lucida Bright";panose-1:2 4 6 2 5 5 5 2 3 4;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Signature;panose-1:0 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817MsoNormal, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817MsoNormal, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 a:link, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817MsoHyperlink {color:blue;text-decoration:underline;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 a:visited, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 code {font-family:"Courier New";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 pre {margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:"Courier New";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 tt {font-family:"Courier New";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817MsoAcetate, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817MsoAcetate, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817MsoAcetate {margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma", "sans-serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817HTMLPreformattedChar {font-family:Consolas;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817attach, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817attach, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817attach {margin-right:0in;margin-left:0in;font-size:9.0pt;font-family:"Arial", "sans-serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817bold, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817bold, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817bold {margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:"Arial", "sans-serif";font-weight:bold;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817green, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817green, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817green {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";color:#628C2A;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817replbq, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817replbq, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817replbq {margin:3.0pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817ad, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817ad, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817ad {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817underline, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817underline, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817underline {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817yshortcuts {} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817ad1, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817ad1, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817ad1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817ad2, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817ad2, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817ad2 {margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 p.ygrps-yiv-1674268133ygrps-yiv-68513817underline1, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 li.ygrps-yiv-1674268133ygrps-yiv-68513817underline1, #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817underline1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:"Times New Roman", "serif";text-decoration:underline;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817yshortcuts1 {font-family:"Verdana", "sans-serif";font-weight:bold;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817yshortcuts2 {font-family:"Verdana", "sans-serif";font-weight:normal;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817BalloonTextChar {font-family:"Tahoma", "sans-serif";} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 span.ygrps-yiv-1674268133ygrps-yiv-68513817EmailStyle36 {font-family:"Calibri", "sans-serif";color:#1F497D;font-weight:normal;font-style:normal;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 .ygrps-yiv-1674268133ygrps-yiv-68513817MsoChpDefault {font-size:10.0pt;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {margin:1.0in 1.0in 1.0in 1.0in;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 div.ygrps-yiv-1674268133ygrps-yiv-68513817WordSection1 {} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Symbol;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:"Courier New";} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;} #ygrps-yiv-1674268133 filtered #ygrps-yiv-1674268133ygrps-yiv-68513817 {font-family:Wingdings;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 ol {margin-bottom:0in;} #ygrps-yiv-1674268133 #ygrps-yiv-1674268133ygrps-yiv-68513817 ul {margin-bottom:0in;}

In 9.05 I have been able to create my own custom TimePhase using a BAQ to Dashboard Report.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:44
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

Remember I said Dashboard Report and Not Dashboard. You can’t calculate the running cum in Time Phase on a Dashboard you will have to insert a Crystal Report in your Dashboard making it a Dashboard Report.

Well mine is kind of crazy and very custom to how we use Epicor but here goes.

Dashboard Report Using Crystal.

I have created 2, one for Manufactured Parts, one for Purchased Parts.

I have added both to the Epicor Menu and then to the Context menu for part numbers so on any part number you can right click and select it to run.

It is now more of a worksheet in the TimePhase format showing WIP status, Shipping Locations, Open DMRs, Open RMAs, flagged for expediting, etc….

 

Manufactured Parts Example:

PartDtl is the starting table.

I then Joined the following tables to PartDTL:  JobHead, OrderHed, OrderDtl, OrderRel, PartPlant, PartWhse, RMADtl, DMRHead all as outer joins marked as Query First record only.

Yes my time phase will show if there is at least one open dmr or return.

I only have one PartWhse (I only have one so this join works for me, if you have more than one warehouse you could Left-Outer Alias Join to each one using selection criteria.)

 

I do a bunch of other look ups for example:

From OrderHed and OrderRel I link to ShipTo and also display the shipping locations on my time phase.

 

From JobHead I read the first 10 Operations on the job and display the WIP status of the job on the report also.

Many puzzle pieces, menus, context menu’s, BAQ’s, Dashboards, Crystal Report inserted into your Dashboard.

Also if you understand Left-Outer Joins, Finding First Record instead of Each, and joining more than once to the same table using Alias joins you will see how I used those concepts over and over in this BAQ.

 

Is there any particular area you are hung up on?

 

Patrick Winter

Epicor 9.05.702

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Sunday, July 12, 2015 07:43
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

Patrick, I have been struggling trying to create a custom timephase in 9.05.702a.  Can you please explain how you created your custom timephase?  What tables are you using?  Would you be able to share/upload your actual dashboard?


I appreciate any help you can send my way on this topic.

 

Thank you in advance.

 

Brian


---In vantage@yahoogroups.com, <pjw@...> wrote :

In 9.05 I have been able to create my own custom TimePhase using a BAQ to Dashboard Report.

 

Patrick

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:44
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Material requirements without using MRP - Vantage 8.03

 

 

You don’t like Time Phase?  Not the actual screen but there is a report.  And it has filters.

Manasa

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, January 23, 2015 10:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Material requirements without using MRP - Vantage 8.03

 

 

I’m trying to come up with a way to develop a custom reports for our purchasing folks that would give them a list of material demand based on scheduled jobs AND forecasted orders.  We are not licensed for MRP but I was hoping I could get fancy with some custom reporting and figure it out.  Anyone else out there tried to do this before??

 

Mike Abell

Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office:   931.432.8408
Mobile:  615.418.3055
 
email:  MAbell@...

 

This e-mail and any attachments may contain confidential and privileged information. If you are not the intended and/or named recipient or recipients, 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 or recipients is unauthorized and may be illegal. Any views or opinions expressed in this email are those of the author and do not necessarily represent those of the Specialty Screw Corporation. Warning: Although precautions have been taken to make sure no viruses are present in this email, Specialty Screw Corporation cannot accept responsibility for any loss or damage that may arise from the use of this email or attachments.
  ­­  

Patrick, thank you for your response.  I apologize for the delay in responding.


There is a lot to this post, and please know that I am not trying to take advantage of your knowledge, but I am so frustrated with Epicor support and not getting anywhere myself, I have cried myself to sleep many times than I care to count...(not really, but you get my point).  I am asking for a little extra guidance to get me where I want to be.

I have tried creating your "Manufactured Parts Example" with a few minor tweaks that shouldn't affect the results...but maybe I am wrong.  I selected a particular part in the PartDtl table, instead of selecting none and having to wait forever to get any results in the BAQ Designer.  Also, we do not use the PartPlant (we only have 1 plant), RMA and DMR tables at all, so I left them out....which I wouldn't think affects getting the results.  However, I could not get it to work with a part that has more than 1 open job (job to make that part).

I have PartDtl as the first table and then all other tables point to PartDtl as outer joins and Query First Records Only.  I will say that I tried using the "each" record and "first" record.  I have also tried changing the outer joins (or not).  I tried these different way in all possible combinations.  I must be doing something different than you are.  I am not able to get it to work.  Please see screenshot below of the BAQ Designer.

Well, I guess it won't allow me to insert the screenshot, but you should understand at what point I am stuck.

Thanks,

Brian

I see the BAQ that you put in.  Well at least in outlook.  Asked to open it in a browser and I see your BAQ. 

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, August 24, 2015 3:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Material requirements without using MRP - Vantage 8.03

 

 

Well, I guess it won't allow me to insert the screenshot, but you should understand at what point I am stuck.

Thanks,

Brian