Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simphony CAPS Not Posting Sales to R&A

Status
Not open for further replies.

GeminiBoy

Programmer
Oct 28, 2016
29
NG
My Simphony CAPS is not posting sales to R&A.

I have attached the error as seen from the log file on CAPS.

Meanwhile, whenever any transaction is carried out, the DPS Log shows that a transaction is coming through but at the end nothing still get posted to R&A

 
 https://files.engineering.com/getfile.aspx?folder=9e5e772d-fc47-4973-8713-99fef5b46991&file=CAPS.JPG
You can check the transaction transfer to Dbcreate or not, and check the DPS log.
Or try to restart the DPS service. Could please upload the egatewaylog and DPS ?
 
Hi King
It seems your check is not send to decreate database.
You can use SMSS and connect to the dbcreate database ,
select * from checks where checknum= '***' to see the check posted to dbcreate or not.



 
Ki Niko,

Many thanks for your kind reponse.

Are you talking about CheckPostingDB?

Which database is dbcreate?
 
Hi King,
Which version do you use ?

Dbcreate is a schema in MCRSPOS.
 
Hi King

Connect your DB and use SQL developer to login the DB, then select dbcreate datebase.
 
What DB do you use? Oracle or MSSQL?

IF Oracle database is Dbcreate , MSSQL is dbo.check.

Please connect you APP server and find it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top