What-if Analysis

Yahoo Archive
#1
Gerry,
 Yeah, sure. Anything would be better than the nothing I have now. Can I drop you a line if I have any questions?

Thanks,
-Karl
email: kdash@...




________________________________
From: Gerry Loranger <gloranger@...>
To: vantage@yahoogroups.com
Sent: Fri, March 12, 2010 8:37:34 AM
Subject: [Vantage] What-if Analysis

Â
A few months ago, I was asked to provide a solution for "What If"
checks. I didn't have much luck with a BAQ because you cannot add
multiple instances of a table in Vantage 8. So I wussed out and created
a "What If" tool in MS Access. I can send you a copy if you like.

In Epicor 9, I am told that you can add multiple instances of a table
now.

Gerry Loranger

Systems Administrator

Preformed Line Products

1711 Bishop St. East

Cambridge, ON N1T 1N5

519-740-6666 Ext. 224

Email: gloranger@preformed .on.ca <mailto:gloranger@preformed .on.ca>

Visit our website at www.preformed. on.ca <http://www.preformed.on.ca>

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







[Non-text portions of this message have been removed]
#2
I have a Crystal report that is essentially an exploded BOM report that includes info for quantity on hand and allocations in order to tell whether we have a shortage on parts for an assembly requested by the customer. But it only works for one assembly at a time. Naturally a customer has come forward who wants several assemblies all of which have many common parts and wants to know what are the current shortages.

Have others met this challenge? I looked into the "What-if" capablities once but it seemed rather disappointing or badly explained. Is this a challenge you have been able to meet?

Thanks,
-Karl




[Non-text portions of this message have been removed]
#3
A few months ago, I was asked to provide a solution for "What If"
checks. I didn't have much luck with a BAQ because you cannot add
multiple instances of a table in Vantage 8. So I wussed out and created
a "What If" tool in MS Access. I can send you a copy if you like.



In Epicor 9, I am told that you can add multiple instances of a table
now.



Gerry Loranger

Systems Administrator

Preformed Line Products

1711 Bishop St. East

Cambridge, ON N1T 1N5

519-740-6666 Ext. 224

Email: gloranger@... <mailto:gloranger@...>

Visit our website at www.preformed.on.ca <http://www.preformed.on.ca>







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