Relation Between Sale Transaction and Refund Transaction (database level)

Environment: 

iVend 6.5 Update 6 , 6.6 with SAP B1 9.2

Problem statement:

Relation Between Sale Transaction and Refund Transaction (database level)

Symptoms:

Relation Between Sale Transaction and Refund Transaction (database level)

Resolution/Work Around:

There are two tables, one contains the data regarding sale transactions and the other contains data regarding it's items.

TrxTransaction and Trxtransactionsaleitem

Both tables have few common columns that are listed below and can be used to establish an understanding regarding the Refund transaction:

(column) =value (detail)

Type = 1 (type 1 means refund)

RefundedQuantity = (The quantity which has been refunded)

OriginalDocumentKey = (References to the original transaction key, used in case of refund, deliveries )

OriginalDetailKey = (References to the original detail key, used in case of refund, deliveries )

Other values may be : 

The sale item type of transaction made in the transaction.

Valid values are:

Sale = 0

Exchange = 2

Recommendations/Suggestion:

From TrxTransactionsaleitem , one can find out the details about individual items and the refund quantities etc

• Related Articles

• Customer unable to do refund invoices in one site due to API Url not working at this showroom

  Environment: iVend 6.6 Problem Statement: Customer unable to do refund invoices in one site and getting the error attached at below Error Screenshot: Issue steps : 1. Open POS and press transaction search 2. Search with transaction SA0222000468 3. ...

• Discount On Total of Sale Transaction: Header level discount

  Environment : iVend 6.6 with SAPB1 Problem Statement : Customer wants to apply header level discount for the sale transaction without any pre fix discount for the sale items. Scenario : customer walked in to store, he purchase items and total bill is ...

• Query to verify Sales Transaction by Store report (Refund included)

  ************************************Internal to Citixsys**************************************** Problem Statement SQL Query to verify results of default iVend report "Sales Transaction by Store report (Refund included) " Solution Below query can be ...

• Need Refund Sale Transaction from other store as the Transaction belongs to a Deleted/Closed Store

  iVend version : 6.6 Problem Statement : A Sale Transaction is done in Store A but the Store A is now removed/ deleted from iVend, as the store is physically closed Now when trying to search for the same sale transaction from any other store, with the ...

• Refund Transaction and Suspend both flag true in Single Transaction

  Environment iVend 6.6 Product Query: Sales refund ,Suspended both parameter are activated for an single transaction and created an difference in the report, Could you please verify how both parameters are activated for the transaction ? ...