Linking PurchLine and SalesLine

(0) Share

Report

Posted on by PhillyNJ

I am working on a Mod, where I need to capture addition information on a SalesLine at time of order. I am writing out this data to a table. The table will have a reference to the SalesLine. When the PO is created, I am updating this table with a reference to the PurchLine.

Is it safe to link these 2 tables using SalesLine.INVENTTRANSID to PurchLine.INVENTREFTRANSID?

Or is it safer to use RecIds to link these tables?

SELECT  sl.SALESID,  
		sl.INVENTREFID, 
		sl.INVENTTRANSID, 
		sl.INVENTREFTRANSID, 
		p.INVENTREFID, 
		p.PURCHID, 
		p.INVENTREFTRANSID, 
		p.INVENTTRANSID FROM SALESLINE sl
	INNER JOIN PURCHLINE p ON p.INVENTREFTRANSID = sl.INVENTTRANSID
WHERE sl.INVENTTRANSID = 'LOT000386'

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

nunomaia 25 Moderator on at

Like (1)

Report

Yes, those table are linked by those fields.

relationship is only valid if Item Reference in PO is Sales

Was this reply helpful? Yes No