8.03.305H Crystal Report Question

You answered your own question when you said "there seems to be a disconnect".

There are no simple useful data relationships between the Make To Stock supply orders and the orders (or jobs) generating the requirements - because the supply orders are Make To Stock.

Unless you are a 100% engineer (from scratch) to order environment, it probably isn't practical to manually link your requirements (as they arise) to MTS supply orders.

If it is practical/manageable - that is your answer.

If it is not, it is possible (but probably would result in achingly slow report performance that might bog the whole system down) that, if you run Pegging (with MRP or standalone) daily, you might have an outside shot of using the resulting Supply and Requirement table data to essentially do an on-the-fly MRP run on every unlinked open requirement. The goal would be to attempt to determine which pending supply order (at that instant in time) will likely fulfill it.

...Makes me shiver just thinking what a CPU cycle & memory eating monster a report like that would be.

Rob Brown


melissa hietala <kevmel822@...> wrote:
I'm looking at tying information between jobs, orders, and quotes. Jobs that are directly tied to an order (made-to-order) seem to tie in with the corresponding orders and quotes relatively well. However, jobs that are indirectly tied to an order (made-to-stock) are creating problems when trying to tie in the corresponding orders and quotes. There seems to be a disconnect. Wondering if there are any suggestions on how to tie made-to-stock jobs with the appropriate orders and quote tables without creating duplications?

Thanks,

Melissa Hietala
UMC, Inc.
melissah@...

__________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

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






---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

[Non-text portions of this message have been removed]
I'm looking at tying information between jobs, orders, and quotes. Jobs that are directly tied to an order (made-to-order) seem to tie in with the corresponding orders and quotes relatively well. However, jobs that are indirectly tied to an order (made-to-stock) are creating problems when trying to tie in the corresponding orders and quotes. There seems to be a disconnect. Wondering if there are any suggestions on how to tie made-to-stock jobs with the appropriate orders and quote tables without creating duplications?

Thanks,

Melissa Hietala
UMC, Inc.
melissah@...


____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


[Non-text portions of this message have been removed]
How can a Make to Stock Job be tied to an Order?

The Make to Stock Job fills Inventory, the Order pulls from Inventory.

An Order may cause a reduction in Inventory level where MRP is triggering a
Suggestion for a Job to fill Stock. But there is no direct relationship
between a Make to Stock Job and an Order.

Unless I am missing something.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
melissa hietala
Sent: Tuesday, January 15, 2008 4:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 8.03.305H Crystal Report Question

I'm looking at tying information between jobs, orders, and quotes. Jobs
that are directly tied to an order (made-to-order) seem to tie in with the
corresponding orders and quotes relatively well. However, jobs that are
indirectly tied to an order (made-to-stock) are creating problems when
trying to tie in the corresponding orders and quotes. There seems to be a
disconnect. Wondering if there are any suggestions on how to tie
made-to-stock jobs with the appropriate orders and quote tables without
creating duplications?

Thanks,

Melissa Hietala
UMC, Inc.
melissah@...



____________________________________________________________________________
________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ


[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 Links
Melissa,

Just like Scott said you can't do this...we went through this process
and there is no "linking" in the system for Make to stock jobs and
orders.

I can do a combo where a make to order will do a partial on the order
and then pull the rest from stock....but that doesn't help you as well.

What we did before was just label our make to stock jobs with the order
number, line, and release, but it still does not link in anyway.



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Tuesday, January 15, 2008 4:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03.305H Crystal Report Question



How can a Make to Stock Job be tied to an Order?

The Make to Stock Job fills Inventory, the Order pulls from Inventory.

An Order may cause a reduction in Inventory level where MRP is
triggering a
Suggestion for a Job to fill Stock. But there is no direct relationship
between a Make to Stock Job and an Order.

Unless I am missing something.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
melissa hietala
Sent: Tuesday, January 15, 2008 4:31 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 8.03.305H Crystal Report Question

I'm looking at tying information between jobs, orders, and quotes. Jobs
that are directly tied to an order (made-to-order) seem to tie in with
the
corresponding orders and quotes relatively well. However, jobs that are
indirectly tied to an order (made-to-stock) are creating problems when
trying to tie in the corresponding orders and quotes. There seems to be
a
disconnect. Wondering if there are any suggestions on how to tie
made-to-stock jobs with the appropriate orders and quote tables without
creating duplications?

Thanks,

Melissa Hietala
UMC, Inc.
melissah@... <mailto:melissah%40ultramc.com>

__________________________________________________________
________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
<http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>

[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links






[Non-text portions of this message have been removed]
If you want to look at it by Part Number you could pull what Order have a
Demand for that Part Number and what Jobs are Supplying that Part Number to
an Order or Stock.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Tuesday, January 15, 2008 4:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03.305H Crystal Report Question

Melissa,

Just like Scott said you can't do this...we went through this process
and there is no "linking" in the system for Make to stock jobs and
orders.

I can do a combo where a make to order will do a partial on the order
and then pull the rest from stock....but that doesn't help you as well.

What we did before was just label our make to stock jobs with the order
number, line, and release, but it still does not link in anyway.



M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Scott Litzau
Sent: Tuesday, January 15, 2008 4:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 8.03.305H Crystal Report Question



How can a Make to Stock Job be tied to an Order?

The Make to Stock Job fills Inventory, the Order pulls from Inventory.

An Order may cause a reduction in Inventory level where MRP is
triggering a
Suggestion for a Job to fill Stock. But there is no direct relationship
between a Make to Stock Job and an Order.

Unless I am missing something.

Scott

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
melissa hietala
Sent: Tuesday, January 15, 2008 4:31 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] 8.03.305H Crystal Report Question

I'm looking at tying information between jobs, orders, and quotes. Jobs
that are directly tied to an order (made-to-order) seem to tie in with
the
corresponding orders and quotes relatively well. However, jobs that are
indirectly tied to an order (made-to-stock) are creating problems when
trying to tie in the corresponding orders and quotes. There seems to be
a
disconnect. Wondering if there are any suggestions on how to tie
made-to-stock jobs with the appropriate orders and quote tables without
creating duplications?

Thanks,

Melissa Hietala
UMC, Inc.
melissah@... <mailto:melissah%40ultramc.com>

__________________________________________________________
________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
<http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>

[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links






[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 Links