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'

All responses (1)

Answers (0)

Suggested answer

nunomaia 10,684 Super User 2024 Season 1 on at

Like (1)

Report

RE: Linking PurchLine and SalesLine -D365 F&O

Yes, those table are linked by those fields.

relationship is only valid if Item Reference in PO is Sales