I am working creating a custom version of the Work In Process report also. I am very close now, but when running against the live system it appears my filter is off. Do you know what the correct filter should be? Right now I am filtering on
jh.Company = 'MyCompany'
and wipcleared = 0
and (
jh.JobNum in (Select JobNum from labordtl (nolock) where company = 'MyCompany')
or
jh.JobNum in (Select JobNum from parttran (nolock) where company = 'MyCompany')
)
The detail seems to be fine and my job Production, Completed, Shipped, and To Inventory quantities seem to be correct. It just seems to be my filter that is an issue.
Thanks.
jh.Company = 'MyCompany'
and wipcleared = 0
and (
jh.JobNum in (Select JobNum from labordtl (nolock) where company = 'MyCompany')
or
jh.JobNum in (Select JobNum from parttran (nolock) where company = 'MyCompany')
)
The detail seems to be fine and my job Production, Completed, Shipped, and To Inventory quantities seem to be correct. It just seems to be my filter that is an issue.
Thanks.
--- In vantage@yahoogroups.com, Jim Chance <jim_chance@...> wrote:
>
> My version is a combination of 3 reports...
> the Production Detail report plus the Work In Process report and the Inventory WIP reconciliation report.ÂÂ
>
> 81 formulas, run parm by cut off date allowing the selection of 1 job or multiple or against all.ÂÂ
>
> Screen shot attached.ÂÂ
>
> This report will run on MS SQL or Progress in 8 or 9.ÂÂ
>
>
> ÂÂ
> ---------------
> Jim Chance, PMP - IT consultant/contractor
> DBA Practical Technology Solutions
> 1485 County Road 1575
> Ashland, Ohio, 44805
> Office/Home: 419-557-2225
> Cell: 419-651-6704
> Fax: 732-601-6704
> Email: jim_chance@...
>
>
> PMP Certified, IT purveyor since 1985. SQL Server, Crystal, Project Management, HP3000, UNIX, Migrations/Conversions, ERP expert.
> Primary strengths: 1) IT in manufacturing 2) Analyst 3) ERP 4) MS SQL 5) Crystal reports. Robust SDLC experience. Completed the development & implementation of over 1500 application solutions to-date. Strong analysis and integration skills. Sarbanes Oxley knowledge. Single handedly converted legacy systems to MS SQL multiple times. Broad understanding of capital projects. Used integration, technical and negotiation skills to achieve successful project outcomes around issues, scope, schedule, costs and resources.
>
>
> Rent our condo in sunny warm Estero, Florida:
> http://www.vacationrentals.com/vacation-rentals/23683.html
>
>
> >________________________________
> >From: Tonya Koopman <tonya.koopman@...>
> >To: vantage@yahoogroups.com
> >Sent: Tuesday, October 11, 2011 4:55 PM
> >Subject: RE: [Vantage] Re: Detailed WIP Report
> >
> >
> >ÂÂ
> >Sorry didn't see this sooner, my IT person was able to create crystal report with the detail in the production detail that ties to the WIP report. I needed this for my Year-end to allow me to calculate the impact of a Standard Labor rate and Burden rate change.
> >
> >-----Original Message-----
> >From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kevin Simon
> >Sent: Tuesday, October 11, 2011 3:06 PM
> >To: vantage@yahoogroups.com
> >Subject: RE: [Vantage] Re: Detailed WIP Report
> >
> >Now it's time to upgrade Epicor, find out they made a schema change, and you're report won't work anymore.
> >
> >Kevin
> >
> >From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jim Chance
> >Sent: Tuesday, October 11, 2011 2:09 PM
> >To: vantage@yahoogroups.com
> >Subject: Re: [Vantage] Re: Detailed WIP Report
> >
> >After about 9 subreports, 8 tables and about 80 hours I was able to finish this report.
> >
> >---------------
> >Jim Chance, PMP - IT consultant/contractor
> >DBA Practical Technology Solutions
> >1485 County Road 1575
> >Ashland, Ohio, 44805
> >Office/Home: 419-557-2225
> >Cell: 419-651-6704
> >Fax: 732-601-6704
> >Email: jim_chance@... <mailto:jim_chance%40yahoo.com>
> >
> >PMP Certified, IT purveyor since 1985. SQL Server, Crystal, Project Management, HP3000, UNIX, Migrations/Conversions, ERP expert.
> >Primary strengths: 1) IT in manufacturing 2) Analyst 3) ERP 4) MS SQL 5) Crystal reports. Robust SDLC experience. Completed the development & implementation of over 1500 application solutions to-date. Strong analysis and integration skills. Sarbanes Oxley knowledge. Single handedly converted legacy systems to MS SQL multiple times. Broad understanding of capital projects. Used integration, technical and negotiation skills to achieve successful project outcomes around issues, scope, schedule, costs and resources.
> >
> >Rent our condo in sunny warm Estero, Florida:
> >http://www.vacationrentals.com/vacation-rentals/23683.html
> >
> >>________________________________
> >>From: cooner_55421 <cooner_55421@... <mailto:cooner_55421%40yahoo.com> >
> >>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> >>Sent: Monday, October 10, 2011 2:01 PM
> >>Subject: [Vantage] Re: Detailed WIP Report
> >>
> >>
> >>
> >>>section of the report they want is the operation
> >>>details with a total for each employee by sequence for the job
> >>Then you might want to check JobOper & JobOpDtl too.
> >>
> >>--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "jamesd" <jdaniel1127@> wrote:
> >>>
> >>> I will check those. I was trying to figure out how to look at the report in developer mode and didn't have any luck. Opened rpt file in Crystal and the section of the report they want is the operation details with a total for each employee by sequence for the job...
> >>>
> >>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "cooner_55421" <cooner_55421@> wrote:
> >>> >
> >>> > Have you looked at the labor tables?
> >>> > LaborHed, LaborDtl & LaborPart.
> >>> > I've use them mostly to keep track of shop employee hours.
> >>> > But, LaborDtl has the job numbers too.
> >>> >
> >>> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "jamesd" <jdaniel1127@> wrote:
> >>> > >
> >>> > > Looked at the production detail report output and it has some of the info we would like to put into a report. Basically, would like to get user labor data that they enter into MES by job # so we can determine
> >>> > > jobs the user is working on and eventually use this to adjust job time so we can get costs inline. What do I use to see what the detail of the report is (i.e. what tables and fields are used and how the are joined?
> >>> > >
> >>> > > Thanks,
> >>> > >
> >>> > > James
> >>> > >
> >>> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jim Chance <jim_chance@> wrote:
> >>> > > >
> >>> > > > Yeah....I checked that out. Nothing stood out.
> >>> > > >
> >>> > > > Thanks.
> >>> > > >
> >>> > > > ---------------
> >>> > > > Jim Chance, PMP - IT consultant/contractor
> >>> > > > DBA Practical Technology Solutions
> >>> > > > From: Manasa Reddy <manasa@>
> >>> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> >>> > > > Sent: Friday, July 29, 2011 4:50 PM
> >>> > > > Subject: RE: [Vantage] Re: Detailed WIP Report
> >>> > > >
> >>> > > >
> >>> > > > Â
> >>> > > > >
> >>> > > > >Did you check the archives/files under our yahoo group?
> >>> > > > >
> >>> > > > >They may have posted something there...maybe?
> >>> > > > >
> >>> > > > >M. Manasa Reddy
> >>> > > > >
> >>> > > > >manasa@
> >>> > > > >
> >>> > > > >630.806.2000 x1515
> >>> > > > >
> >>> > > > >________________________________
> >>> > > > >
> >>> > > > >From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf
> >>> > > > >Of Jim Chance
> >>> > > > >Sent: Friday, July 29, 2011 3:43 PM
> >>> > > > >To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> >>> > > > >Subject: Re: [Vantage] Re: Detailed WIP Report
> >>> > > > >
> >>> > > > >That's correct.
> >>> > > > >
> >>> > > > >I'm hoping someone in this forum has possibly already done this without
> >>> > > > >reinventing the wheel.
> >>> > > > >Especially for Vantage 8.03 w/ Crystal against Progress.
> >>> > > > >From: Manasa Reddy <manasa@ <mailto:manasa%40weldcoa.com> >
> >>> > > > >To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > >Sent: Friday, July 29, 2011 4:09 PM
> >>> > > > >Subject: RE: [Vantage] Re: Detailed WIP Report
> >>> > > > >
> >>> > > > >>
> >>> > > > >>Then thinking out loud, you could create a detailed WIP report based on
> >>> > > > >>transactions from the part tran table.
> >>> > > > >>
> >>> > > > >>If you have the INV transaction hierarchy report you will know the
> >>> > > > >exact
> >>> > > > >>transactions to create this.
> >>> > > > >>
> >>> > > > >>Good luck....
> >>> > > > >>
> >>> > > > >>M. Manasa Reddy
> >>> > > > >>
> >>> > > > >>manasa@ <mailto:manasa%40weldcoa.com>
> >>> > > > >>
> >>> > > > >>630.806.2000 x1515
> >>> > > > >>
> >>> > > > >>________________________________
> >>> > > > >>
> >>> > > > >>From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > >[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
> >>> > > > >Behalf
> >>> > > > >>Of Jim Chance
> >>> > > > >>Sent: Friday, July 29, 2011 3:00 PM
> >>> > > > >>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > >>Subject: Re: [Vantage] Re: Detailed WIP Report
> >>> > > > >>
> >>> > > > >>The production detail report is helpful - but its on a per job analsis
> >>> > > > >>basis. We have 48 pages of jobs that list on our WIP report.
> >>> > > > >>
> >>> > > > >>Granted seeing the detail will be a long report, but
> >>> > > > >>finance/auditors/banks are asking for WIP detail. It would be too time
> >>> > > > >>consuming to query each job #; so if we had a WIP Detail report by date
> >>> > > > >>range showing production detail then we'd be in great shape.
> >>> > > > >>
> >>> > > > >>---------------
> >>> > > > >>Jim Chance, PMP - IT consultant/contractor
> >>> > > > >>DBA Practical Technology Solutions
> >>> > > > >>1485 County Road 1575
> >>> > > > >>Ashland, Ohio, 44805
> >>> > > > >>Office/Home: 419-557-2225
> >>> > > > >>Cell: 419-651-6704
> >>> > > > >>Fax: 732-601-6704
> >>> > > > >>Email: jim_chance@ <mailto:jim_chance%40yahoo.com>
> >>> > > > ><mailto:jim_chance%40yahoo.com>
> >>> > > > >>From: "Edward F. Fox, Jr." <efox@
> >>> > > > ><mailto:efox%40maxsonautomatic.com>
> >>> > > > >><mailto:efox%40maxsonautomatic.com> >
> >>> > > > >>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com>
> >>> > > > >>Sent: Friday, July 29, 2011 3:01 PM
> >>> > > > >>Subject: RE: [Vantage] Re: Detailed WIP Report
> >>> > > > >>
> >>> > > > >>>
> >>> > > > >>>We just use the Production detail report. The cut-off isn't clean, but
> >>> > > > >>it's
> >>> > > > >>>close enough. I agree it would be nice if there was a detail WIP
> >>> > > > >report
> >>> > > > >>>that tied to the WIP report.
> >>> > > > >>>
> >>> > > > >>>Edward F. Fox, Jr., CPA
> >>> > > > >>>Controller
> >>> > > > >>>Maxson Automatic Machinery Company
> >>> > > > >>>Phone 401-596-0162 . Fax 401-596-1050
> >>> > > > >>><http://www.maxsonautomatic.com> www.maxsonautomatic.com
> >>> > > > >>>
> >>> > > > >>>_____
> >>> > > > >>>
> >>> > > > >>>From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com>
> >>> > > > >>[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com> ] On
> >>> > > > >>Behalf Of
> >>> > > > >>>Manasa Reddy
> >>> > > > >>>Sent: Friday, July 29, 2011 2:56 PM
> >>> > > > >>>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com>
> >>> > > > >>>Subject: RE: [Vantage] Re: Detailed WIP Report
> >>> > > > >>>
> >>> > > > >>>Wouldn't the Production Detail report give you that information?
> >>> > > > >>>
> >>> > > > >>>Or is there something else you need on a report like the Production
> >>> > > > >>>Detail? Maybe I'm missing something...
> >>> > > > >>>
> >>> > > > >>>M. Manasa Reddy
> >>> > > > >>>
> >>> > > > >>>manasa@ <mailto:manasa%40weldcoa.com>
> >>> > > > ><mailto:manasa%40weldcoa.com>
> >>> > > > >><mailto:manasa%40weldcoa.com>
> >>> > > > >>>
> >>> > > > >>>630.806.2000 x1515
> >>> > > > >>>
> >>> > > > >>>________________________________
> >>> > > > >>>
> >>> > > > >>>From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com>
> >>> > > > >><mailto:vantage%40yahoogroups.com>
> >>> > > > >>>[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com>
> >>> > > > >><mailto:vantage%40yahoogroups.com> ] On
> >>> > > > >>>Behalf
> >>> > > > >>>Of jim_chance
> >>> > > > >>>Sent: Friday, July 29, 2011 10:31 AM
> >>> > > > >>>To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com>
> >>> > > > >><mailto:vantage%40yahoogroups.com>
> >>> > > > >>>Subject: [Vantage] Re: Detailed WIP Report
> >>> > > > >>>
> >>> > > > >>>We have the same issue. Our accountants would also like to see
> >>> > > > >details.
> >>> > > > >>
> >>> > > > >>>
> >>> > > > >>>We are on progress 8.03 -
> >>> > > > >>>
> >>> > > > >>>Does anyone out there have ANY solutions for this? Perhaps a Crystal
> >>> > > > >>>report showing detals for progress version 8?
> >>> > > > >>>
> >>> > > > >>>--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
> >>> > > > ><mailto:vantage%40yahoogroups.com>
> >>> > > > >><mailto:vantage%40yahoogroups.com>
> >>> > > > >>><mailto:vantage%40yahoogroups.com> ,
> >>> > > > >>>"nweining@" <nweining@> wrote:
> >>> > > > >>>>
> >>> > > > >>>> We are on version 8.03.408B and are looking for a way to get a WIP
> >>> > > > >>>report with more detail. We would like to know if anyone has had any
> >>> > > > >>>luck modifying the current report or may have created a new one. Our
> >>> > > > >>>accounts would like to see the material cost breakdown and would like
> >>> > > > >>to
> >>> > > > >>>see the burden and labor broken out by resource group. Any help would
> >>> > > > >>be
> >>> > > > >>>greatly appreciated.
> >>> > > > >>>>
> >>> > > > >>>
> >>> > > > >>>[Non-text portions of this message have been removed]
> >>> > > > >>>
> >>> > > > >>>__________ Information from ESET NOD32 Antivirus, version of virus
> >>> > > > >>signature
> >>> > > > >>>database 6335 (20110729) __________
> >>> > > > >>>
> >>> > > > >>>The message was checked by ESET NOD32 Antivirus.
> >>> > > > >>>
> >>> > > > >>>http://www.eset.com
> >>> > > > >>>
> >>> > > > >>>[Non-text portions of this message have been removed]
> >>> > > > >>>
> >>> > > > >>>
> >>> > > > >>>
> >>> > > > >>>
> >>> > > > >>>
> >>> > > > >>
> >>> > > > >>[Non-text portions of this message have been removed]
> >>> > > > >>
> >>> > > > >>[Non-text portions of this message have been removed]
> >>> > > > >>
> >>> > > > >>
> >>> > > > >>
> >>> > > > >>
> >>> > > > >>
> >>> > > > >
> >>> > > > >[Non-text portions of this message have been removed]
> >>> > > > >
> >>> > > > >[Non-text portions of this message have been removed]
> >>> > > > >
> >>> > > > >
> >>> > > > >
> >>> > > > >
> >>> > > > >
> >>> > > >
> >>> > > > [Non-text portions of this message have been removed]
> >>> > > >
> >>> > >
> >>> >
> >>>
> >>
> >>
> >>
> >>
> >>
> >
> >[Non-text portions of this message have been removed]
> >
> >[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/linksYahoo! Groups Links
> >
> >
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>