WIP Transactions report

b_ordway is spot on whenpointing you to PartTran.TranType. In addition, if you are referring to financial transactions. You may want to look at these TranTypes as well

ADJ-SUB - Adjustment to Job Cost Subcontract.
DMR-SUB - DMR to subcontract.
INS-SUB - Inspection to Job Subcontract.
PUR-SUB - Purchased receipt to Subcontract.

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> I would start by looking at the the PartTran table - TranType field.
>
> xxx-MFG (adding to WIP)
> MFG-yyy (coming out of WIP)
> WIP-MFG (job to job)
> MFG-WIP (job to job)
>
>
>
> --- In vantage@yahoogroups.com, "flexial_ma" <mike.abell@> wrote:
> >
> > I need to write a report that details the last time any transactions were produced for WIP parts. Can anyone give me a starting point for tables/fields where this information might be located? Thanks in advance!
> >
> > Mike..
> >
>
I need to write a report that details the last time any transactions were produced for WIP parts. Can anyone give me a starting point for tables/fields where this information might be located? Thanks in advance!

Mike..
I would start by looking at the the PartTran table - TranType field.

xxx-MFG (adding to WIP)
MFG-yyy (coming out of WIP)
WIP-MFG (job to job)
MFG-WIP (job to job)



--- In vantage@yahoogroups.com, "flexial_ma" <mike.abell@...> wrote:
>
> I need to write a report that details the last time any transactions were produced for WIP parts. Can anyone give me a starting point for tables/fields where this information might be located? Thanks in advance!
>
> Mike..
>