Link from Part-Tran to Labor-Dtl tables

Yahoo Archive
1
As mentioned, the LaborDtl does not directly link to the Part-Tran. And that's because it wasn't the LaborDtl transaction that directly created part transaction. Labor transaction will only directly change the WIP related tables. The only thing I can think of is if it was the final operation and you have auto receive to inventory turned on. That's the only way for the quantity reported in labor entry to trigger a inventory receipt. But it was the Job Receipt to Inventory transaction (automatic or not) that creates the Part-Tran record. Automatic receive to inventory can make a mess when mistakes are made, especially with average costing.



--- In vantage@yahoogroups.com, "Babette Welch" <bwelch@...> wrote:
> Does anyone know the fields which link the
>
> Labor-Dtl table to the Part-Tran table?
>
> (Vantage 8.3)

> When a Labor-Detail is entered it creates a Part-Tran record.

> A worker entered a Labor-Detail (through Labor Entry)
>
> with a LaborQty =2.
>
> That created a Part-Tran record of MFG-STK for the 2 parts.

> The Labor-Detail was later deleted but the Part-Tran record was NOT
> deleted.

> I am trying to find out the link between the two tables.

> All assistance is appreciated.
>
>
>
> Babette Welch
2
Does anyone know the fields which link the

Labor-Dtl table to the Part-Tran table?

(Vantage 8.3)





When a Labor-Detail is entered it creates a Part-Tran record.







A worker entered a Labor-Detail (through Labor Entry)

with a LaborQty =2.

That created a Part-Tran record of MFG-STK for the 2 parts.



The Labor-Detail was later deleted but the Part-Tran record was NOT
deleted.



I am trying to find out the link between the two tables.



All assistance is appreciated.



Babette Welch



[Non-text portions of this message have been removed]
3
JobOper might work



Thanks~



Kathleen

360/ 453-3445

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Babette Welch
Sent: Thursday, April 23, 2009 1:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Link from Part-Tran to Labor-Dtl tables








Does anyone know the fields which link the

Labor-Dtl table to the Part-Tran table?

(Vantage 8.3)

When a Labor-Detail is entered it creates a Part-Tran record.

A worker entered a Labor-Detail (through Labor Entry)

with a LaborQty =2.

That created a Part-Tran record of MFG-STK for the 2 parts.

The Labor-Detail was later deleted but the Part-Tran record was NOT
deleted.

I am trying to find out the link between the two tables.

All assistance is appreciated.

Babette Welch

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




NOTICE OF CONFIDENTIALITY: This e-mail message, including attachments, is for the sole use of the intended recipients and may contain confidential and privileged information. If you are not an intended recipient, please contact the sender by reply e-mail and destroy all copies of this message, including attachments. Any unauthorized review, use, disclosure or distribution is prohibited.


[Non-text portions of this message have been removed]
4
It's not a direct link. You'll need to star with JobHead (& maybe JobProd for make directs), link that to joboper and jobmtl and then link joboper to labordtl & jobmtl to parttran.

The fact that you keyed in on labordtl makes me think you are only interested in jobs. If you want part-trans to include more than just job material issues/returns, you have to tie in the corresponding source tables (orders, POs, TOs).

One problem with BAQs (on 8.03.40X) is that you can only have a table in the BAQ once. That prohibits you from tying parttrans to job receipts AND job material issue activity. (You have topcik the one you're interested in and link appropriately).

Apparently v9 overcomes this single table instance per BAQ limit.

Rob

--- On Thu, 4/23/09, Babette Welch <bwelch@...> wrote:
From: Babette Welch <bwelch@...>
Subject: [Vantage] Link from Part-Tran to Labor-Dtl tables
To: vantage@yahoogroups.com
Date: Thursday, April 23, 2009, 4:08 PM

















Does anyone know the fields which link the



Labor-Dtl table to the Part-Tran table?



(Vantage 8.3)



When a Labor-Detail is entered it creates a Part-Tran record.



A worker entered a Labor-Detail (through Labor Entry)



with a LaborQty =2.



That created a Part-Tran record of MFG-STK for the 2 parts.



The Labor-Detail was later deleted but the Part-Tran record was NOT

deleted.



I am trying to find out the link between the two tables.



All assistance is appreciated.



Babette Welch



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