Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-267002 - i21 BI Parallel - If Mix N Match is Odd Qty|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-267002]
*STEPS:*
*Generate Vendor Rebate File*
1. Go to Store > Maintenance > Generate Vendor Rebate File
2. Enter details on Generate Vendor Rebate File screen
3. Click Generate
4. On Local machine, locate the generated csv file and verify
*Checkout Transaction Journal*
1. Go to Store > Reports > Checkout Transaction Journal
2. In Search screen select any Transaction
3. Click Open selected button
4. In Checkout Transaction Journal, take note the details
5. Open SSMS and run the query
SELECT intTermMsgSN,
intStoreNo,
strCashier,
dtmDateTime,
strTransType,
strTrlDept,
strTrlNetwCode,
strTrlUPC,
strTrlDesc,
dblTrlQty,
dblTrlUnitPrice,
dblTrlLineTot
FROM vyuSTTranslogDetails
WHERE intTermMsgSN = __
*Basket Analysis*
1. Go to Store > Reports > Basket Analysis
2. Enter details on Basket Analysis screen
3. Verify the details
*ISSUE:*
Match Cig rebates query with mix and match changes in trans log view.
Dean and Lassus have done some changes on trans log view in order to resolve BI conditions.
We need to study those changes and see how we can incorporate those changes on the SPs or views pulling data from trans log table. eg. Cigarette Rebates.
*ACCEPTANCE:*
Add the WHERE clause from vyuSTTranslogDetails on generating of report
|