Error entering amount received in Rapid Service Entry

Modified on Mon, 05 Dec 2011 09:37 by CAREWare Help Desk — Categorized as: FAQ

When entering and saving amount received in Rapid Service Entry an error message is produced on saving the record:

Source: jProgBusiness - The INSERT statement conflicted with the FOREIGN KEY constraint "rlt_srv_rcp". 
The conflict occurred in database "CW_Data", table "dbo.cw_service", column 'srv_pk'.
The statement has been terminated. INSERT INTO cw_receipt ( rcp_pk , rcp_srv_fk , rcp_date , rcp_amount, 
rcp_source , rcp_last_updated) VALUES (@rcp_pk , @rcp_srv_fk , @rcp_date , @rcp_amount , @rcp_source , @rcp_last_updated)
cw_receipt.rcp_pk=122354a2-7335-430a-ae5f-6d1bd6c68f3e
cw_receipt.rcp_srv_fk=440d375d-353a-45e6-876c-b17ba40a5c11
cw_receipt.rcp_date=04/28/2011
cw_receipt.rcp_amount=492.95
cw_receipt.rcp_source=l
   at jProgBusiness.jBusiness.ServiceAdministration.AddReceipt(String loginToken, jAmountReceived rcp)
   at jProgBusiness.jBusiness.jBusinessRemote.SRV_Add_Receipt(String SessionToken, jAmountReceived rcp)
An error occurred in SRV_Add_Receipt.
If the problem persists, please contact technical support.
 Amount received can be added in client record but not in rapid entry system.

This bug was found in build554
This bug was fixed in build580
TTP #1801

Back to Bugs

Back to Frequently Asked Questions