tnzabo
13th October 2008, 18:16
Anybody know what happens in the session Transfer Planned PRP Purchase orders. I know - seems like a simple session however, the buyer field - does it transfer directly to tdpur040.ccon? Reason I'm asking is because I've made that field Mandatory on the tdpur040 table and when this session runs - it blows up because of a reference not existing on the ttccom001 table - employees - even though there is a buyer in the tipcs520.buyr field that is valid - not 0 which is what the reference error says.

Any ideas??:confused:

sukesh75
14th October 2008, 10:19
Hi,
Have you tried running SQL Profiler to see what tables this session accesses or checks and what values are passed at the time of transferring the PRP order to a Purchase Order table(s)?

sk

ARijke
14th October 2008, 16:33
Yes it should bring the buyer value from tipcs520 into tdpur040.ccon. I do not know what happens if there is also an applicable purchase contract. In that case it might take the buyer from the contract.