Information on the tables which has captured the reason code for Return and void sales

Information on the tables which has captured the reason code for Return and void sales

Version

6.5 and not the version-specific

Requirement

Need the information on the tables which has captured the reason code for Return and void sales.

Resolution

 Suggested customer to consider below tables:

Table name TrxTransctionAudit, wherein field (Columns):
1. "AuditType" will identify the activity on the POS
2.  "ReasonCodeKey": identifies Reason and references reason code.

The reason codes could be found in the table "cfgReasonCode".

These tables can be used to capture the return and void sales.




    • Related Articles

    • Find reason Code captured for line discount in table " TrxTransactionAudit "

      Environment : iVend Version 6.6 with SAPB1 10 Query: How to find reason Code captured for line discount in table " TrxTransactionAudit " Symptoms : How to find reason Code captured for line discount in table " TrxTransactionAudit " Resolution/Work ...

    • iVend POS - Reason Codes transactions at the MC

      What are Reason Codes? Reason Codes are defined for capturing additional information on some of the pre-defined activities at the Management Console and the POS. The user has the option to define Reason Codes for activities such as Purchase Orders, ...

    • Void Sales report isn't showing any result.

      Problem Statement Void Sales report isn't showing any result. Cause Void sales logging might not be enabled in the Retail Profile that is being used. Solution Please open retail profile and look for checkbox "Log Voided Transaction". If this option ...

    • UPC Code

      UPC Codes What is a Universal Product Code (UPC)? Simply put, a UPC, short for universal product code, is a type of barcode printed on retail product packaging to aid in item identification of a particular item. It is most widely and commonly used in ...

    • What can be the reason that NONE of the Merchandise sales dashboards are pulling any data?

      Product version: iVend 6.6 Problem statement: What can be the reason that NONE of the Merchandise sales dashboards are pulling any data? Proposed Solution/Workaround: As per attached screenshot, Merchandise Hierarchy is not configured in the ...