Summary:
Posting tickets fails for validated return tickets which have been entered using a default return reason code in the store setup which has been deleted from Setup/Point of Sale/Reason Codes.
Error message:
Processing was aborted due to the following system error: No record found to get column value. [SQL: Select VAL_SCRAP_INV, SCRAP_REASON_COD from PS_REAS_COD WHERE REAS_COD = ’XXXXXX’] (’XXXXXX’ is the name of the deleted reason code, ie, "DAMAGED").
Cause:
In Setup / Point of Sale / Stores - Tickets-1 tab, under the section for Validated Returns, a default return reason code can be entered but is not required. If this reason code is subsequently deleted from Setup / Point of Sale / Reason Codes and the store is not updated, this posting failure will occur for validated returns subsequently entered with the no longer on file return reason code.
Solution:
A point of sale reason code can be deleted even if it is defined as a default validated return reason code for store(s). Since this results in validated return ticket documents which include a no longer valid reason code, the preventative action would be to change the default validated return reason code in the store(s) setup to a new default before deleting the old reason code.
If this error is encountered after a reason code has already been deleted, the workaround would be to add back the missing Point of Sale Reason code in Setup/Point of Sale/Reason Codes that is referenced in the posting error, post all tickets that previously failed due to this error, then change the store(s) default validated return reason code to a valid, on file reason code. After this is done, the old reason code can then be deleted from the software.
Article ID: 938
Created: April 1, 2016
Last Updated: April 4, 2016
Online URL: https://counterpoint.knowledgebase.co/article.php?id=938