| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-250273 - Scan Data not reporting correctly|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-250273]
* Issue
** Final Price is incorrect when mix and match is sold.
*** Invalid when two quantity is sold on 1 line
*** Invalid when 1 quantity is sold on 2 lines
* Requirements
** Update Final Price to net out multipack discounts
From Altria:
I was able to speak directly with someone concerning the transactional data for the scan files you are reporting on the USSTC MultiCan Offer. While you verified the consumer is getting the discount thru the register, there appears to be an issue with how the transactions are being reported across all stores in the file that we are receiving. The stores passing maybe a result of how they are scanning (ie when 2 cans purchased, they scan once and qty 2 vs scanning a single can 2 separate times).
Below are a few of the examples to demonstrate how the reporting file is capturing the transactions. Column L is where we need to focus. The file does show the correct discount (column X), but the price point (column L) is not reflective of what the consumer paid (either 3.77 is single can if scanned 2 separate times, or if quantity of 2, then 7.54 would show column L as the column K formula would give the 3.77 that we are looking for…..
Please review and let me know if this makes sense on your end. If this is something you can correct, and resubmit files for past weeks then payments should be good. If you can only change for future files, then we will need to pursue an exception payment request.
_Here are a few examples to outline what we discussed for you to follow up with the retailer on in regards to accurately reporting the transactions total to ensure reporting and scoring is accurate for the account. Please reference the reporting requirements with your account to help them make necessary updates._
_Row 5014 – shows an example where 2 cans were purchased and the discount was applied but the incorrect total was listed in column L making it look as if the unit price was 1.885._
_Row 5257 & 5384 – denote the same transaction where 2 cans were purchased each listed on their own line (that is an acceptable way to report), but the discount does not come through in the price listed in column L making it look as if it did not meet the validation price of 3.77 for pass through._
|