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
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]
> > >
> >
>