Thanks anyways and thanks for all you help!
Jasper
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, February 25, 2004 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
I did not overcome this issue in report builder. Fortunately in my case we
have just one warehouse.
Patrick Winter
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, February 25, 2004 7:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
Patrick,
In your report, how did you calculate the beginning On-hand Quantity if you
have a single part in multiply warehouses? If I just use the
Partwhse.onhandqty, my report will be all wrong because sometimes we have a
part in different warehouses. How did you add up the on-hand qty from each
warehouse?
Thanks,
Jasper
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, February 18, 2004 4:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
Jasper,
I cut and pasted these for you.
A2 = IIF(PREVIOUS(PartDtl.JobNum) = PartDtl.JobNum,0, ProdQty - ReceivedQty
- ShippedQty)
B2 = IIF(PREVIOUS(PartDtl.OrderNum) = PartDtl.OrderNum AND
PREVIOUS(PartDtl.OrderLine) = PartDtl.OrderLine AND
PREVIOUS(PartDtl.OrderRelNum) = PartDtl.OrderRelNum,0,OurReqQty -
OurStockShippedQty - OurJobShippedQty)
C2 = IIF(SourceFile = 'JH' and RecordCount = 1,C2 + A2 + InventoryOnHand,
IIF(SourceFile = 'OR' and RecordCount = 1,C2 - B2 + InventoryOnHand,
IIF(SourceFile = 'JH', C2 + A2, IIF(SourceFile = 'OR',C2 - B2,C2))))
Patrick Winter
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, February 18, 2004 3:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
In your calculation, what does the A2, B2, C2 stand for?
Thanks,
Jasper
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Tuesday, February 17, 2004 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
You can create the Time Phase Report in Report Builder but it's not easy.
Manufactured Parts Version of TimePhase.
I used the PartDtl and joined to the Part Table.
Then did outer joins to the JobHead, OrderRel, and PartWhse.
PartWhse gives you the onhand starting quantity for the part.
Sort and Group on Part.Description and PartDtl.DueDate Filter for
PartDtl.Source INLIST 'JH','OR'
I came up with this calculated field to calculate the running balance.
RunBalance =
IIF(SourceFile = 'JH' and RecordCount = 1,C2 + A2 + InventoryOnHand,
IIF(SourceFile = 'OR' and RecordCount = 1,C2 - B2 + InventoryOnHand,
IIF(SourceFile = 'JH', C2 + A2, IIF(SourceFile = 'OR',C2 - B2,C2))))
The trick was adding in the starting onhand quantity.
The way this is designed will only run for one manufactured part, it would
need to have more logic added to run multiple parts or purchased parts.
Good Luck.
Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.20.322, Progress 9.1D, Windows 2003 Server
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, February 16, 2004 2:09 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Time Phase Material report
Can anybody explain to me what information the Time Phase material report
gives you. What criteria does it use to calculate a projected balance?
Does it take into account manufacturing lead time and vendor lead time? Can
it tell you when to order materials? Any information would help.
Also, any ideas on how to recreate this report in report builder?
Thanks,
Jasper
[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
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
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
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
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
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
Jasper
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, February 25, 2004 9:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
I did not overcome this issue in report builder. Fortunately in my case we
have just one warehouse.
Patrick Winter
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, February 25, 2004 7:27 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
Patrick,
In your report, how did you calculate the beginning On-hand Quantity if you
have a single part in multiply warehouses? If I just use the
Partwhse.onhandqty, my report will be all wrong because sometimes we have a
part in different warehouses. How did you add up the on-hand qty from each
warehouse?
Thanks,
Jasper
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, February 18, 2004 4:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
Jasper,
I cut and pasted these for you.
A2 = IIF(PREVIOUS(PartDtl.JobNum) = PartDtl.JobNum,0, ProdQty - ReceivedQty
- ShippedQty)
B2 = IIF(PREVIOUS(PartDtl.OrderNum) = PartDtl.OrderNum AND
PREVIOUS(PartDtl.OrderLine) = PartDtl.OrderLine AND
PREVIOUS(PartDtl.OrderRelNum) = PartDtl.OrderRelNum,0,OurReqQty -
OurStockShippedQty - OurJobShippedQty)
C2 = IIF(SourceFile = 'JH' and RecordCount = 1,C2 + A2 + InventoryOnHand,
IIF(SourceFile = 'OR' and RecordCount = 1,C2 - B2 + InventoryOnHand,
IIF(SourceFile = 'JH', C2 + A2, IIF(SourceFile = 'OR',C2 - B2,C2))))
Patrick Winter
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, February 18, 2004 3:44 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
In your calculation, what does the A2, B2, C2 stand for?
Thanks,
Jasper
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Tuesday, February 17, 2004 9:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Time Phase Material report
You can create the Time Phase Report in Report Builder but it's not easy.
Manufactured Parts Version of TimePhase.
I used the PartDtl and joined to the Part Table.
Then did outer joins to the JobHead, OrderRel, and PartWhse.
PartWhse gives you the onhand starting quantity for the part.
Sort and Group on Part.Description and PartDtl.DueDate Filter for
PartDtl.Source INLIST 'JH','OR'
I came up with this calculated field to calculate the running balance.
RunBalance =
IIF(SourceFile = 'JH' and RecordCount = 1,C2 + A2 + InventoryOnHand,
IIF(SourceFile = 'OR' and RecordCount = 1,C2 - B2 + InventoryOnHand,
IIF(SourceFile = 'JH', C2 + A2, IIF(SourceFile = 'OR',C2 - B2,C2))))
The trick was adding in the starting onhand quantity.
The way this is designed will only run for one manufactured part, it would
need to have more logic added to run multiple parts or purchased parts.
Good Luck.
Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.20.322, Progress 9.1D, Windows 2003 Server
-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, February 16, 2004 2:09 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Time Phase Material report
Can anybody explain to me what information the Time Phase material report
gives you. What criteria does it use to calculate a projected balance?
Does it take into account manufacturing lead time and vendor lead time? Can
it tell you when to order materials? Any information would help.
Also, any ideas on how to recreate this report in report builder?
Thanks,
Jasper
[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
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
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
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
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
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