roysouvik
17th September 2018, 08:58
Hi,

Someone please help me to handle error code 606.

I had created a update session to insert data in Purchase order(tdpur400) Table.

But it returning a error code 606.

with error message "Recore ['PDNO00001'] cannot be saved in table Purchase Orders in companey 100

Thank You in advance.

bdittmar
17th September 2018, 09:52
Hello,
This error indicates that the reference does not exist. For more information, see the log files.

Regards

roysouvik
17th September 2018, 10:48
How to see log file? I'm creating it through script, using dal script.

Ajesh
17th September 2018, 11:14
Why dont you repeat the dal.get.error.message? First time you will get the message which you got? And next time it will show the more accurate one.

roysouvik
17th September 2018, 12:49
Why dont you repeat the dal.get.error.message? First time you will get the message which you got? And next time it will show the more accurate one.

dal.set.field("tdpur400.odat",utc.num())
dal.set.field("tdpur400.ratd",utc.num())

dal.set.field("tdpur400.ddat",utc.num())
dal.set.field("tdpur400.ccur","INR")
dal.set.field("tdpur400.ratt","IMP")
dal.set.field("tdpur400.ratp(1)", 1.00000)
dal.set.field("tdpur400.cotp", "SUB")
dal.set.field("tdpur400.cofc", "PPO")
dal.set.field("tdpur400.cpay", 030)



| dal.set.field("tdpur400.ratf",1)
| dal.set.field("tdpur400.pric",0)
ret_val = dal.save.object("tdpur400", err.msg)
if ret_val = 0 then
commit.transaction()
message("Purchase Order " & tdpur400.orno & " is Created.....")
else
ret_val = dal.get.error.message(err.msg)
message("Error.....!%s",err.msg)
endif

where to do so?

Ajesh
17th September 2018, 13:18
dal.set.field("tdpur400.odat",utc.num())
dal.set.field("tdpur400.ratd",utc.num())

dal.set.field("tdpur400.ddat",utc.num())
dal.set.field("tdpur400.ccur","INR")
dal.set.field("tdpur400.ratt","IMP")
dal.set.field("tdpur400.ratp(1)", 1.00000)
dal.set.field("tdpur400.cotp", "SUB")
dal.set.field("tdpur400.cofc", "PPO")
dal.set.field("tdpur400.cpay", 030)



| dal.set.field("tdpur400.ratf",1)
| dal.set.field("tdpur400.pric",0)
ret_val = dal.save.object("tdpur400", err.msg)
if ret_val = 0 then
commit.transaction()
message("Purchase Order " & tdpur400.orno & " is Created.....")
else
ret_val = dal.get.error.message(err.msg)
message("Error.....!%s",err.msg)
endif

where to do so?

dal.set.field("tdpur400.odat",utc.num())
dal.set.field("tdpur400.ratd",utc.num())

dal.set.field("tdpur400.ddat",utc.num())
dal.set.field("tdpur400.ccur","INR")
dal.set.field("tdpur400.ratt","IMP")
dal.set.field("tdpur400.ratp(1)", 1.00000)
dal.set.field("tdpur400.cotp", "SUB")
dal.set.field("tdpur400.cofc", "PPO")
dal.set.field("tdpur400.cpay", 030)



| dal.set.field("tdpur400.ratf",1)
| dal.set.field("tdpur400.pric",0)
ret_val = dal.save.object("tdpur400", err.msg)
if ret_val = 0 then
commit.transaction()
message("Purchase Order " & tdpur400.orno & " is Created.....")
else
ret_val = dal.get.error.message(err.msg)
ret_val = dal.get.error.message(err.msg)
message("Error.....!%s",err.msg)
endif

Just for Test Purpose


Another option is to check in the Event Viewer Section in Application Server..

roysouvik
17th September 2018, 13:25
Thank You, finally I found solution. Few extra field data i'm inserting thats why the error is showing up.