WIP Reconciliation

Hi Greg,


I found out playing around with Epicor that the posting for the GL only consider PartTran and LaborDtl and thought also they should tie with the JobAmbl but alas they don't. I have started to look at the files you mentioned and trying to correctly link them so I hope this may help but it is a huge amount of data to either Link directly or off load to an external database.


Thanks for your help Greg, much appreciated.

Regards

--- In vantage@yahoogroups.com, "Chad Smith" <csmith@...> wrote:
>
>
>
> I'm tempted to say the TLA and LLA fields need to be added together to get the full cost if I recall correctly. Likewise with the TLE and LLE fields.
>
> If you didn't want to use the JobAsmbl cost information, the tables you'd need would be JobHead, JobAsmbl, JobOper, JobMtl, PartTran, LaborDtl, and maybe JobProd. In theory, if you summarized PartTran and LaborDtl, they should tie out to the TLA + LLA values in JobAsmbl I'd think.
>
> As to re-creating the entire Inventory WIP Reconciliation, I've not tried that but there would be lots of work there. I think TranGLC holds the posted transactions, but I don't think the unposted transactions are actually stored. I think they're calculated on the fly from PartTran and LaborDtl.
>
>
> --- In vantage@yahoogroups.com, "billybones705" <williams1178@> wrote:
> >
> > Hi Greg,
> >
> > I did but they don't appear to reconcile but I would have thought is would be the same?
> >
> > Regards
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, Greg Payne <gpayne@> wrote:
> > >
> > > I would look at the TLA fields in the JobAsmbl table.
> > >
> > > Greg
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of billybones705
> > > Sent: Friday, April 19, 2013 4:03 AM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] WIP Reconciliation
> > >
> > >
> > >
> > > Hello all,
> > >
> > > I'm trying to replicate a WIP report outside of Epicor which is proving difficult. The issue is the WIP reconciliation report does not reconcile and, looking at how this report is constructed it appears to use the Parts transaction file to reconcile back to Job files. Why isn't it using the GL audit files instead? Anyway we don't, for some reason, post all Part transactions to the GL, looking at the control files.
> > >
> > > So, What I'm after has anyone tried to just use Job files to provide an accurate WIP report or can guide me which tables and fields I should use. Thank you in advance.
> > >
> > > Regards
> > >
> > > Billy Bones
> > >
> > >
> > > ________________________________
> > > CONFIDENTIALITY NOTICE
> > >
> > > The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
> > >
> > > "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
I'm planning to update my hardware and I was wandering if anydody as had any success running Vantage 6.10.504 on Microsoft 2008 Server or 2003 Server.

Thank you
Jerry
According to our Epicor CAM 6.1 will not run on Windows 2008. Think would only be able to upgrade to Windows 2003. One of the reasons we are upgrading to Epicor 9.

--- In vantage@yahoogroups.com, "kapokia" <esposito@...> wrote:
>
> I'm planning to update my hardware and I was wandering if anydody as had any success running Vantage 6.10.504 on Microsoft 2008 Server or 2003 Server.
>
> Thank you
> Jerry
>
Good afternoon all,

When we complete a job and run the Inventory WIP Reconciliation Report, we are finding that there is no debit to WIB labor or credit to Applied Labour. In essence, it is leaving the WIP labour open, which is accumulating quite a large credit balance. We are fairly new Vantage users, so we are not quite sure where to look. Does anyone know what creates this entry? Resource Group? Employee set-up?

Any help would certainly be appreciated.

Thanks all,

Kerry Travis
Controller
International Name Plate Supplies Ltd.

[Non-text portions of this message have been removed]
Im not a finance guy but I thought a lot those costs were steered
through product group...that's where wip detail accounts are defined...



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kerry Travis
Sent: Wednesday, November 18, 2009 3:21 PM
To: vantage@yahoogroups.com
Cc: ktravis@...
Subject: [Vantage] WIP Reconciliation





Good afternoon all,

When we complete a job and run the Inventory WIP Reconciliation Report,
we are finding that there is no debit to WIB labor or credit to Applied
Labour. In essence, it is leaving the WIP labour open, which is
accumulating quite a large credit balance. We are fairly new Vantage
users, so we are not quite sure where to look. Does anyone know what
creates this entry? Resource Group? Employee set-up?

Any help would certainly be appreciated.

Thanks all,

Kerry Travis
Controller
International Name Plate Supplies Ltd.

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





[Non-text portions of this message have been removed]
Couple questions:
What version?
Make to order or make to stock?
Are you using MES?

When using MES and for make to order jobs:
You should see a Debit to WIP Labor everytime there is a labor transaction recorded against a job and a Credit to Applied Labor. This labor cost should appear on your WIP Reconciliation report, Production Detail Report and Work in Process report. When the order is shipped, the system will Credit WIP and Debit AR - Clearing. The cost of the labor is calculated using the labor hours recorded against the job and the employee labor rate, which is in shop employee set-up in Job Management.

Not sure about make to stock jobs since everything we do is make to order.



Virginia Joseph

Deep Hole Specialists, LLC, 440-543-8157






--- In vantage@yahoogroups.com, Kerry Travis <kerrytravis@...> wrote:
>
> Good afternoon all,
>
> When we complete a job and run the Inventory WIP Reconciliation Report, we are finding that there is no debit to WIB labor or credit to Applied Labour. In essence, it is leaving the WIP labour open, which is accumulating quite a large credit balance. We are fairly new Vantage users, so we are not quite sure where to look. Does anyone know what creates this entry? Resource Group? Employee set-up?
>
> Any help would certainly be appreciated.
>
> Thanks all,
>
> Kerry Travis
> Controller
> International Name Plate Supplies Ltd.
>
> [Non-text portions of this message have been removed]
>
We are on Version 8.03.408B

We are making these items to stock. The labor and material is backflushed. We have now discovered this only happens when we enter quantities in the MES. If we enter it in the main Vantage, it works fine.

We are wondering if it is a bug.

Thanks again,

Kerry




________________________________
From: Virginia <vjoseph@...>
To: vantage@yahoogroups.com
Sent: Wed, November 18, 2009 5:39:12 PM
Subject: [Vantage] Re: WIP Reconciliation

Â

Couple questions:
What version?
Make to order or make to stock?
Are you using MES?

When using MES and for make to order jobs:
You should see a Debit to WIP Labor everytime there is a labor transaction recorded against a job and a Credit to Applied Labor. This labor cost should appear on your WIP Reconciliation report, Production Detail Report and Work in Process report. When the order is shipped, the system will Credit WIP and Debit AR - Clearing. The cost of the labor is calculated using the labor hours recorded against the job and the employee labor rate, which is in shop employee set-up in Job Management.

Not sure about make to stock jobs since everything we do is make to order.

Virginia Joseph

Deep Hole Specialists, LLC, 440-543-8157

--- In vantage@yahoogroups .com, Kerry Travis <kerrytravis@ ...> wrote:
>
> Good afternoon all,
>
> When we complete a job and run the Inventory WIP Reconciliation Report, we are finding that there is no debit to WIB labor or credit to Applied Labour. In essence, it is leaving the WIP labour open, which is accumulating quite a large credit balance. We are fairly new Vantage users, so we are not quite sure where to look. Does anyone know what creates this entry? Resource Group? Employee set-up?
>
> Any help would certainly be appreciated.
>
> Thanks all,
>
> Kerry Travis
> Controller
> International Name Plate Supplies Ltd.
>
> [Non-text portions of this message have been removed]
>




[Non-text portions of this message have been removed]
Kerry:
I suspect you have run into something that we recently did which happens with back flushing in Vantage. Very very goofy, but possibly will shed light into your problem.

We found the exact same problem on some jobs. Materials and labor were backflushed. This was initiated through MES with an operation as Quantity Only and the previous operations backflushed. We had found in only certain circumstances that although the transactions were initiated and job tracker showed the transactions, neither the WIP report nor the WIP Reconciliation report showed the dollars actually moving. It was sporadic and not repeatable at first. then we ran across something I call a Vantage..ism.

What really happens is that although you think you backflushed and the job tracker makes you think you backflushed, you have backflushed quantities but the system has not yet backflushed the dollars.

I know, you are thinking....I must be talking to a finance person...all I get is crazy talk! :) Well, what we actually found out is that the dollars have not yet moved. So what kicks off the dollars moving.....well hang, buckle in, this is where the ism in Vantageism comes in. Open the job in the Job Closing function, the system will backflush and move the dollars. Run a production Detail report, the system will backflush the dollars.

So is there an easier way? Sure, batch the Backflush Labor Server Process to run like we do now, every minute. If you need it quicker, run it every 5 seconds. Funny thing about it is our implementation consultant never told us about what that process does or what we should do with it, so we were not running it at all.

Go ahead and test what I outlined above. Watch a job on backflush, see the quantities move, parts move, but not the dollars. I would be interested if you find the same thing. Then when the dollars have not moved run a production detail report on that job, then go check and see if the dollars moved. Or go into Job Close (you don't actually have to close the job, you just have to input the job number into the screen) and then see if the dollars moved.

Please let me know if this is what you found also.

Sincerely,
Chris Berger
Controller
Dorner Mfg. Corp.

--- In vantage@yahoogroups.com, Kerry Travis <kerrytravis@...> wrote:
>
> We are on Version 8.03.408B
>
> We are making these items to stock. The labor and material is backflushed. We have now discovered this only happens when we enter quantities in the MES. If we enter it in the main Vantage, it works fine.
>
> We are wondering if it is a bug.
>
> Thanks again,
>
> Kerry
>
>
>
>
> ________________________________
> From: Virginia <vjoseph@...>
> To: vantage@yahoogroups.com
> Sent: Wed, November 18, 2009 5:39:12 PM
> Subject: [Vantage] Re: WIP Reconciliation
>
> ÂÂ
>
> Couple questions:
> What version?
> Make to order or make to stock?
> Are you using MES?
>
> When using MES and for make to order jobs:
> You should see a Debit to WIP Labor everytime there is a labor transaction recorded against a job and a Credit to Applied Labor. This labor cost should appear on your WIP Reconciliation report, Production Detail Report and Work in Process report. When the order is shipped, the system will Credit WIP and Debit AR - Clearing. The cost of the labor is calculated using the labor hours recorded against the job and the employee labor rate, which is in shop employee set-up in Job Management.
>
> Not sure about make to stock jobs since everything we do is make to order.
>
> Virginia Joseph
>
> Deep Hole Specialists, LLC, 440-543-8157
>
> --- In vantage@yahoogroups .com, Kerry Travis <kerrytravis@ ...> wrote:
> >
> > Good afternoon all,
> >
> > When we complete a job and run the Inventory WIP Reconciliation Report, we are finding that there is no debit to WIB labor or credit to Applied Labour. In essence, it is leaving the WIP labour open, which is accumulating quite a large credit balance. We are fairly new Vantage users, so we are not quite sure where to look. Does anyone know what creates this entry? Resource Group? Employee set-up?
> >
> > Any help would certainly be appreciated.
> >
> > Thanks all,
> >
> > Kerry Travis
> > Controller
> > International Name Plate Supplies Ltd.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
Hello all,

I'm trying to replicate a WIP report outside of Epicor which is proving difficult. The issue is the WIP reconciliation report does not reconcile and, looking at how this report is constructed it appears to use the Parts transaction file to reconcile back to Job files. Why isn't it using the GL audit files instead? Anyway we don't, for some reason, post all Part transactions to the GL, looking at the control files.

So, What I'm after has anyone tried to just use Job files to provide an accurate WIP report or can guide me which tables and fields I should use. Thank you in advance.

Regards

Billy Bones
I would look at the TLA fields in the JobAsmbl table.

Greg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of billybones705
Sent: Friday, April 19, 2013 4:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] WIP Reconciliation



Hello all,

I'm trying to replicate a WIP report outside of Epicor which is proving difficult. The issue is the WIP reconciliation report does not reconcile and, looking at how this report is constructed it appears to use the Parts transaction file to reconcile back to Job files. Why isn't it using the GL audit files instead? Anyway we don't, for some reason, post all Part transactions to the GL, looking at the control files.

So, What I'm after has anyone tried to just use Job files to provide an accurate WIP report or can guide me which tables and fields I should use. Thank you in advance.

Regards

Billy Bones


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
We were able to prove that it does not balance if you are using indirect activity. After you run the capture, the transaction no longer show up visible on the report to balance. We were able to reconcile because we have our indirect activity pointing to a different GL account and we found that was our difference.

Deirdre

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
Sent: Friday, April 19, 2013 8:29 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] WIP Reconciliation



I would look at the TLA fields in the JobAsmbl table.

Greg

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of billybones705
Sent: Friday, April 19, 2013 4:03 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] WIP Reconciliation

Hello all,

I'm trying to replicate a WIP report outside of Epicor which is proving difficult. The issue is the WIP reconciliation report does not reconcile and, looking at how this report is constructed it appears to use the Parts transaction file to reconcile back to Job files. Why isn't it using the GL audit files instead? Anyway we don't, for some reason, post all Part transactions to the GL, looking at the control files.

So, What I'm after has anyone tried to just use Job files to provide an accurate WIP report or can guide me which tables and fields I should use. Thank you in advance.

Regards

Billy Bones

________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

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


CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.


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

I did but they don't appear to reconcile but I would have thought is would be the same?

Regards




--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> I would look at the TLA fields in the JobAsmbl table.
>
> Greg
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of billybones705
> Sent: Friday, April 19, 2013 4:03 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] WIP Reconciliation
>
>
>
> Hello all,
>
> I'm trying to replicate a WIP report outside of Epicor which is proving difficult. The issue is the WIP reconciliation report does not reconcile and, looking at how this report is constructed it appears to use the Parts transaction file to reconcile back to Job files. Why isn't it using the GL audit files instead? Anyway we don't, for some reason, post all Part transactions to the GL, looking at the control files.
>
> So, What I'm after has anyone tried to just use Job files to provide an accurate WIP report or can guide me which tables and fields I should use. Thank you in advance.
>
> Regards
>
> Billy Bones
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>
Hi Deirdre,

That's interesting and I will check but I don't think it still give me the full picture as I would have thought following a simple WIP type process would give me the answers?

Regards


--- In vantage@yahoogroups.com, Deirdre Sykes <dsykes@...> wrote:
>
> We were able to prove that it does not balance if you are using indirect activity. After you run the capture, the transaction no longer show up visible on the report to balance. We were able to reconcile because we have our indirect activity pointing to a different GL account and we found that was our difference.
>
> Deirdre
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Payne
> Sent: Friday, April 19, 2013 8:29 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] WIP Reconciliation
>
>
>
> I would look at the TLA fields in the JobAsmbl table.
>
> Greg
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of billybones705
> Sent: Friday, April 19, 2013 4:03 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] WIP Reconciliation
>
> Hello all,
>
> I'm trying to replicate a WIP report outside of Epicor which is proving difficult. The issue is the WIP reconciliation report does not reconcile and, looking at how this report is constructed it appears to use the Parts transaction file to reconcile back to Job files. Why isn't it using the GL audit files instead? Anyway we don't, for some reason, post all Part transactions to the GL, looking at the control files.
>
> So, What I'm after has anyone tried to just use Job files to provide an accurate WIP report or can guide me which tables and fields I should use. Thank you in advance.
>
> Regards
>
> Billy Bones
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
> [Non-text portions of this message have been removed]
>
>
> CONFIDENTIALITY: The information contained in this email message, including any attachment(s), may be privileged and confidential and protected from disclosure. The email is not intended for transmission to, or receipt by, any unauthorized persons. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication or use of the information contained herein is strictly prohibited. If you have received this electronic mail transmission in error, please delete it from your system without copying or disseminating, and notify the sender by Reply email, so that our address record can be corrected.
>
>
> [Non-text portions of this message have been removed]
>
Hi:

The subject line caught my attention because I am struggling to reconcile
January 2013 WIP (our first month on E9 - previously on Vantage 6.1).
Multiple issues have been encountered so far including accounts not
balancing; unable to reconcile WIP, (specifically indirect labor accounts).
Although in January, I started with E9.05.700C; in March I applied patch 701
(bad idea!) Among several other problems from that patch, we discovered
that suddenly the WIP recon report was not working properly. Epicor
provided an .r program for a fix and at that point we were able to use the
report. But wasn't long until we encountered the issues described above.
Still working with Epicor on this, but getting nowhere fast! I would be
very interested in any advice or info on the subject from anyone who may
have experienced the same or similar problems.



Thanks!



Stan



This communication is intended only for use by the addressee(s) named herein
and may contain technical data as defined in the International Traffic In
Arms Regulations (ITAR) 22 CFR 120.10. or the Export Administration
Regulations. Export of this material is restricted cannot be exported to
foreign persons or foreign destination without prior written approval from
the U. S. Department of State or the US Department of Commerce.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
billybones705
Sent: Tuesday, April 23, 2013 6:56 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: WIP Reconciliation





Hi Greg,

I did but they don't appear to reconcile but I would have thought is would
be the same?

Regards

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Greg
Payne <gpayne@...> wrote:
>
> I would look at the TLA fields in the JobAsmbl table.
>
> Greg
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of billybones705
> Sent: Friday, April 19, 2013 4:03 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] WIP Reconciliation
>
>
>
> Hello all,
>
> I'm trying to replicate a WIP report outside of Epicor which is proving
difficult. The issue is the WIP reconciliation report does not reconcile
and, looking at how this report is constructed it appears to use the Parts
transaction file to reconcile back to Job files. Why isn't it using the GL
audit files instead? Anyway we don't, for some reason, post all Part
transactions to the GL, looking at the control files.
>
> So, What I'm after has anyone tried to just use Job files to provide an
accurate WIP report or can guide me which tables and fields I should use.
Thank you in advance.
>
> Regards
>
> Billy Bones
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is
privileged and confidential. It is intended only for the exclusive use of
the addressee. If the reader of this message is not the intended recipient,
or the employee or agent responsible for delivering it to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received
this communication in error, please notify us at 727-578-6280 and
immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the
International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of
this material is restricted by the Arms Export Control Act (22 U.S.C. 2751
et seq.) and may not be exported to foreign persons without prior approval
form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I'm tempted to say the TLA and LLA fields need to be added together to get the full cost if I recall correctly. Likewise with the TLE and LLE fields.

If you didn't want to use the JobAsmbl cost information, the tables you'd need would be JobHead, JobAsmbl, JobOper, JobMtl, PartTran, LaborDtl, and maybe JobProd. In theory, if you summarized PartTran and LaborDtl, they should tie out to the TLA + LLA values in JobAsmbl I'd think.

As to re-creating the entire Inventory WIP Reconciliation, I've not tried that but there would be lots of work there. I think TranGLC holds the posted transactions, but I don't think the unposted transactions are actually stored. I think they're calculated on the fly from PartTran and LaborDtl.


--- In vantage@yahoogroups.com, "billybones705" <williams1178@...> wrote:
>
> Hi Greg,
>
> I did but they don't appear to reconcile but I would have thought is would be the same?
>
> Regards
>
>
>
>
> --- In vantage@yahoogroups.com, Greg Payne <gpayne@> wrote:
> >
> > I would look at the TLA fields in the JobAsmbl table.
> >
> > Greg
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of billybones705
> > Sent: Friday, April 19, 2013 4:03 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] WIP Reconciliation
> >
> >
> >
> > Hello all,
> >
> > I'm trying to replicate a WIP report outside of Epicor which is proving difficult. The issue is the WIP reconciliation report does not reconcile and, looking at how this report is constructed it appears to use the Parts transaction file to reconcile back to Job files. Why isn't it using the GL audit files instead? Anyway we don't, for some reason, post all Part transactions to the GL, looking at the control files.
> >
> > So, What I'm after has anyone tried to just use Job files to provide an accurate WIP report or can guide me which tables and fields I should use. Thank you in advance.
> >
> > Regards
> >
> > Billy Bones
> >
> >
> > ________________________________
> > CONFIDENTIALITY NOTICE
> >
> > The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
> >
> > "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
> >
> >
> > [Non-text portions of this message have been removed]
> >
>