Problem with WIP Report using conveted data (Epicor 9.04)

system · September 18, 2011, 9:09pm

Would you mind sharing it with us?

I'm looking for a better output than the default wip report that is very hard to read.

Ephraim
Ephraim Feldman

-----Original Message-----
From: Jim Chance <jim_chance@...>
Sender: vantage@yahoogroups.com
Date: Sat, 17 Sep 2011 12:24:35
To: vantage@yahoogroups.com<vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Problem with WIP Report using conveted data (Epicor 9.04)

I just completed writing a Crystal reports version of the Work In Process report - plus additional fields from the Production Detail and Inventory Recon report combined.
Â
If you'd like you can contact me directly and I can give you additional information.

---------------
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 1200 application solutions to-date. PMP, Project Management Professional credential by PMI. Strong development, analysis and integration skills. Sarbanes Oxley knowledge. Single handedly converted legacy systems to MS SQL multiple times. Broad understanding of capital projects. Experienced hands-on analyst who has also managed budgets, work plans, schedules, deliverables and responsibility matrices. Additionally, set objectives, build, track and monitor project plans using MS Project with PMBOK methodologies. 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@...>

>To: vantage@yahoogroups.com
>Sent: Saturday, September 17, 2011 10:39 AM
>Subject: [Vantage] Re: Problem with WIP Report using conveted data (Epicor 9.04)
>
>
> Â
>
>Hi Jim,
>
>> I really would like to know what tables / fields the E9.04.507A WIP
>> report is pulling against.
>I'm not sure how to identify them, the report uses its own custom data tables, Recap, Recon...
>
>>we are having problems seeing the cost data in the
>But, I usually look at PartTran when I have cost questions.
>
>One thing - did you Capture COS/WIP Activity or Commit Job Costs before the upgrade?
>I seem to remember this as one of the steps in the upgrade process.
>
>--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)" <james.moore@...> wrote:
>>
>> For the Export / Import, I am using some custom tools that were written
>> by a consultant company.
>>
>>
>>
>> I really would like to know what tables / fields the E9.04.507A WIP
>> report is pulling against.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
>> Of cooner_55421
>> Sent: Friday, September 16, 2011 10:56 AM
>> To: vantage@yahoogroups.com
>> Subject: [Vantage] Re: Problem with WIP Report using conveted data
>> (Epicor 9.04)
>>
>>
>>
>>
>>
>> Hi Jim,
>>
>> Just wondering what process/tools you are using to export/import?
>>
>> When I have an issue, I run a trace when entering manually to see what
>> tables were being hit. Then make sure the imported records are
>> populating all the same tables/fields.
>>
>> > section but not in the WIP report.
>> One thing I'd check is the PartTran table.
>>
>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
>> "Moore, Jim (Anniston)" <james.moore@> wrote:
>> >
>> > We are exporting our Vantage 6.1 data and then importing this same
>> data
>> > into Epicor 9.04.
>> >
>> > Once we do, we are having problems seeing the cost data in the E9.04
>> > standard WIP report.
>> >
>> > The data appears in the Job Tracker > Job Details> Assemblies > Costs
>> > section but not in the WIP report.
>> >
>> >
>> >
>> > Any jobs entered manually in E9 show properly.
>> >
>> >
>> >
>> > Any idea what may be wrong?
>> >
>> >
>> >
>> > Jim Moore
>> >
>> > MIS System Administrator III
>> >
>> >
>> >
>> > General Dynamics
>> >
>> > Ordnance and Tactical Systems
>> >
>> > 1425 Commerce Blvd.
>> >
>> > Anniston, AL. 36207
>> >
>> > 256-835-1660 x373
>> >
>> > James.moore@
>> >
>> >
>> >
>> > This e-mail message is for the sole use of the intended recipient(s)
>> and
>> > may contain confidential and privileged information.
>> >
>> > Any unauthorized review, use, disclosure, or distribution is
>> prohibited.
>> >
>> >
>> > If you are not the intended recipient, please contact the sender by
>> > reply e-mail and destroy all copies of the original e-mail.
>> >
>> >
>> >
>> >
>> >
>> > [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]

system · September 16, 2011, 11:30am

We are exporting our Vantage 6.1 data and then importing this same data
into Epicor 9.04.

Once we do, we are having problems seeing the cost data in the E9.04
standard WIP report.

The data appears in the Job Tracker > Job Details> Assemblies > Costs
section but not in the WIP report.

Any jobs entered manually in E9 show properly.

Any idea what may be wrong?

Jim Moore

MIS System Administrator III

General Dynamics

Ordnance and Tactical Systems

1425 Commerce Blvd.

Anniston, AL. 36207

256-835-1660 x373

James.moore@...

This e-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information.

Any unauthorized review, use, disclosure, or distribution is prohibited.

If you are not the intended recipient, please contact the sender by
reply e-mail and destroy all copies of the original e-mail.

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

system · September 16, 2011, 11:56am

Hi Jim,

Just wondering what process/tools you are using to export/import?

When I have an issue, I run a trace when entering manually to see what tables were being hit. Then make sure the imported records are populating all the same tables/fields.

> section but not in the WIP report.

One thing I'd check is the PartTran table.

--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)" <james.moore@...> wrote:
>
> We are exporting our Vantage 6.1 data and then importing this same data
> into Epicor 9.04.
>
> Once we do, we are having problems seeing the cost data in the E9.04
> standard WIP report.
>
> The data appears in the Job Tracker > Job Details> Assemblies > Costs
> section but not in the WIP report.
>
>
>
> Any jobs entered manually in E9 show properly.
>
>
>
> Any idea what may be wrong?
>
>
>
> Jim Moore
>
> MIS System Administrator III
>
>
>
> General Dynamics
>
> Ordnance and Tactical Systems
>
> 1425 Commerce Blvd.
>
> Anniston, AL. 36207
>
> 256-835-1660 x373
>
> James.moore@...
>
>
>
> This e-mail message is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information.
>
> Any unauthorized review, use, disclosure, or distribution is prohibited.
>
>
> If you are not the intended recipient, please contact the sender by
> reply e-mail and destroy all copies of the original e-mail.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · September 16, 2011, 12:36pm

We just had this problem. Went from 8.0 to 9.05. Support had me run
conversion program 10080. May want to ask them about that.

Everything seems to be fine for me now.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cooner_55421
Sent: Friday, September 16, 2011 11:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Problem with WIP Report using conveted data (Epicor
9.04)

Hi Jim,

Just wondering what process/tools you are using to export/import?

When I have an issue, I run a trace when entering manually to see what
tables were being hit. Then make sure the imported records are populating
all the same tables/fields.

> section but not in the WIP report.

One thing I'd check is the PartTran table.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Moore,
Jim (Anniston)" <james.moore@...> wrote:

>
> We are exporting our Vantage 6.1 data and then importing this same data
> into Epicor 9.04.
>
> Once we do, we are having problems seeing the cost data in the E9.04
> standard WIP report.
>
> The data appears in the Job Tracker > Job Details> Assemblies > Costs
> section but not in the WIP report.
>
>
>
> Any jobs entered manually in E9 show properly.
>
>
>
> Any idea what may be wrong?
>
>
>
> Jim Moore
>
> MIS System Administrator III
>
>
>
> General Dynamics
>
> Ordnance and Tactical Systems
>
> 1425 Commerce Blvd.
>
> Anniston, AL. 36207
>
> 256-835-1660 x373
>
> James.moore@...
>
>
>
> This e-mail message is for the sole use of the intended recipient(s) and
> may contain confidential and privileged information.
>
> Any unauthorized review, use, disclosure, or distribution is prohibited.
>
>
> If you are not the intended recipient, please contact the sender by
> reply e-mail and destroy all copies of the original e-mail.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · September 16, 2011, 12:38pm

For the Export / Import, I am using some custom tools that were written
by a consultant company.

I really would like to know what tables / fields the E9.04.507A WIP
report is pulling against.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of cooner_55421
Sent: Friday, September 16, 2011 10:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Problem with WIP Report using conveted data
(Epicor 9.04)

Hi Jim,

Just wondering what process/tools you are using to export/import?

When I have an issue, I run a trace when entering manually to see what
tables were being hit. Then make sure the imported records are
populating all the same tables/fields.

> section but not in the WIP report.

One thing I'd check is the PartTran table.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Moore, Jim (Anniston)" <james.moore@...> wrote:

>
> We are exporting our Vantage 6.1 data and then importing this same

data

> into Epicor 9.04.
>
> Once we do, we are having problems seeing the cost data in the E9.04
> standard WIP report.
>
> The data appears in the Job Tracker > Job Details> Assemblies > Costs
> section but not in the WIP report.
>
>
>
> Any jobs entered manually in E9 show properly.
>
>
>
> Any idea what may be wrong?
>
>
>
> Jim Moore
>
> MIS System Administrator III
>
>
>
> General Dynamics
>
> Ordnance and Tactical Systems
>
> 1425 Commerce Blvd.
>
> Anniston, AL. 36207
>
> 256-835-1660 x373
>
> James.moore@...
>
>
>
> This e-mail message is for the sole use of the intended recipient(s)

and

> may contain confidential and privileged information.
>
> Any unauthorized review, use, disclosure, or distribution is

prohibited.

>
>
> If you are not the intended recipient, please contact the sender by
> reply e-mail and destroy all copies of the original e-mail.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · September 17, 2011, 10:39am

Hi Jim,

> I really would like to know what tables / fields the E9.04.507A WIP
> report is pulling against.

I'm not sure how to identify them, the report uses its own custom data tables, Recap, Recon...

>we are having problems seeing the cost data in the

But, I usually look at PartTran when I have cost questions.

One thing - did you Capture COS/WIP Activity or Commit Job Costs before the upgrade?
I seem to remember this as one of the steps in the upgrade process.

--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)" <james.moore@...> wrote:
>
> For the Export / Import, I am using some custom tools that were written
> by a consultant company.
>
>
>
> I really would like to know what tables / fields the E9.04.507A WIP
> report is pulling against.
>
>
>
>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of cooner_55421
> Sent: Friday, September 16, 2011 10:56 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Problem with WIP Report using conveted data
> (Epicor 9.04)
>
>
>
>
>
> Hi Jim,
>
> Just wondering what process/tools you are using to export/import?
>
> When I have an issue, I run a trace when entering manually to see what
> tables were being hit. Then make sure the imported records are
> populating all the same tables/fields.
>
> > section but not in the WIP report.
> One thing I'd check is the PartTran table.
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Moore, Jim (Anniston)" <james.moore@> wrote:
> >
> > We are exporting our Vantage 6.1 data and then importing this same
> data
> > into Epicor 9.04.
> >
> > Once we do, we are having problems seeing the cost data in the E9.04
> > standard WIP report.
> >
> > The data appears in the Job Tracker > Job Details> Assemblies > Costs
> > section but not in the WIP report.
> >
> >
> >
> > Any jobs entered manually in E9 show properly.
> >
> >
> >
> > Any idea what may be wrong?
> >
> >
> >
> > Jim Moore
> >
> > MIS System Administrator III
> >
> >
> >
> > General Dynamics
> >
> > Ordnance and Tactical Systems
> >
> > 1425 Commerce Blvd.
> >
> > Anniston, AL. 36207
> >
> > 256-835-1660 x373
> >
> > James.moore@
> >
> >
> >
> > This e-mail message is for the sole use of the intended recipient(s)
> and
> > may contain confidential and privileged information.
> >
> > Any unauthorized review, use, disclosure, or distribution is
> prohibited.
> >
> >
> > If you are not the intended recipient, please contact the sender by
> > reply e-mail and destroy all copies of the original e-mail.
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · September 17, 2011, 3:24pm

I just completed writing a Crystal reports version of the Work In Process report - plus additional fields from the Production Detail and Inventory Recon report combined.
Â
If you'd like you can contact me directly and I can give you additional information.

---------------
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 1200 application solutions to-date. PMP, Project Management Professional credential by PMI. Strong development, analysis and integration skills. Sarbanes Oxley knowledge. Single handedly converted legacy systems to MS SQL multiple times. Broad understanding of capital projects. Experienced hands-on analyst who has also managed budgets, work plans, schedules, deliverables and responsibility matrices. Additionally, set objectives, build, track and monitor project plans using MS Project with PMBOK methodologies. 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@...>

>To: vantage@yahoogroups.com
>Sent: Saturday, September 17, 2011 10:39 AM
>Subject: [Vantage] Re: Problem with WIP Report using conveted data (Epicor 9.04)
>
>
> Â
>
>Hi Jim,
>
>> I really would like to know what tables / fields the E9.04.507A WIP
>> report is pulling against.
>I'm not sure how to identify them, the report uses its own custom data tables, Recap, Recon...
>
>>we are having problems seeing the cost data in the
>But, I usually look at PartTran when I have cost questions.
>
>One thing - did you Capture COS/WIP Activity or Commit Job Costs before the upgrade?
>I seem to remember this as one of the steps in the upgrade process.
>
>--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)" <james.moore@...> wrote:
>>
>> For the Export / Import, I am using some custom tools that were written
>> by a consultant company.
>>
>>
>>
>> I really would like to know what tables / fields the E9.04.507A WIP
>> report is pulling against.
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
>> Of cooner_55421
>> Sent: Friday, September 16, 2011 10:56 AM
>> To: vantage@yahoogroups.com
>> Subject: [Vantage] Re: Problem with WIP Report using conveted data
>> (Epicor 9.04)
>>
>>
>>
>>
>>
>> Hi Jim,
>>
>> Just wondering what process/tools you are using to export/import?
>>
>> When I have an issue, I run a trace when entering manually to see what
>> tables were being hit. Then make sure the imported records are
>> populating all the same tables/fields.
>>
>> > section but not in the WIP report.
>> One thing I'd check is the PartTran table.
>>
>> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
>> "Moore, Jim (Anniston)" <james.moore@> wrote:
>> >
>> > We are exporting our Vantage 6.1 data and then importing this same
>> data
>> > into Epicor 9.04.
>> >
>> > Once we do, we are having problems seeing the cost data in the E9.04
>> > standard WIP report.
>> >
>> > The data appears in the Job Tracker > Job Details> Assemblies > Costs
>> > section but not in the WIP report.
>> >
>> >
>> >
>> > Any jobs entered manually in E9 show properly.
>> >
>> >
>> >
>> > Any idea what may be wrong?
>> >
>> >
>> >
>> > Jim Moore
>> >
>> > MIS System Administrator III
>> >
>> >
>> >
>> > General Dynamics
>> >
>> > Ordnance and Tactical Systems
>> >
>> > 1425 Commerce Blvd.
>> >
>> > Anniston, AL. 36207
>> >
>> > 256-835-1660 x373
>> >
>> > James.moore@
>> >
>> >
>> >
>> > This e-mail message is for the sole use of the intended recipient(s)
>> and
>> > may contain confidential and privileged information.
>> >
>> > Any unauthorized review, use, disclosure, or distribution is
>> prohibited.
>> >
>> >
>> > If you are not the intended recipient, please contact the sender by
>> > reply e-mail and destroy all copies of the original e-mail.
>> >
>> >
>> >
>> >
>> >
>> > [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]