Magmedia Fixed pulling wrong transaction set.

Issue No: CF-2472
Created 1/17/2020 3:36:26 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 19.1
Description This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.   [HDTN-228548 - Purchase Summary Report|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-228548] Issue:   Magmedia Fixed pulling wrong transaction set     Requirement:   This Magnetic Media file should reflect the transaction in the daily invoice. It does not.     Steps:   Copied company 02 to company 98, changed email address to My email for emailing Magnetic Media file. Ran CF>INVOICE with parameters below.   PDF of Invoice atached, only 4 transactions in Invoice. Magmedia file has 96. It has all the uninvoiced tansaction for customer 1040 in the file. Transactions date 01/01/20 to 01/13/20 which is all the transactions imported and posted to this point.   Mag media is not using the staging table or parameters to select data. Mag file should mirror the Invoice   Further checking also revealed duplication of some transaction records. Stripping out the non 01/01/2020 records left 8 transactions 4 original and then their duplicates. Unclear where the selection is coming from for the records in the Magmedia file.   [~bonn.ponce] [~brian.kay]