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

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 Around : 

Kindly follow the below query to find the database from table " TrxTransactionAudit "

select * from TrxTransactionAudit where SourceDetailKey in (select TransactionItemKey from TrxTransactionSaleItem where TransactionKey in (select TransactionKey from TrxTransaction where TransactionId='Enter the transaction ID'))
--------------------------------------------------------------------------------------------------
select * from TrxTransactionAudit where SourceDetailKey in (select TransactionItemKey from TrxTransactionSaleItem where TransactionKey in (select TransactionKey from TrxTransaction where TransactionKey='Enter the transaction key'))

    • Related Articles

    • 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 ...

    • A/R Invoice see different discount between iVend and SAP B1

      Problem Reported : Customer notified to us about different A/R Invoices between iVend and SAP. they realize that they have a difference in the discount between SAP and iVend, it is showing discount negative and decimal less than one. Cause : ivend ...

    • 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, ...

    • Line and Sale Attribute

      Sale and Line Level Attributes Sales Attributes iVend Retail enables retailers the ability to set up additional analysis parameters at the POS to capture extra information while performing transactions, which are called Sales Attributes – this is in ...

    • How to find out that what product information used in line item through scan area over the POS.

      Query How to find out that what product information ( product ID / product barcode ) used in line item through scan area over the POS Environment iVend Version 6.6 with SAPB1 10 . Symptoms How to find out that what product information ( product ID / ...