[CFAMX-507] Refund count added to Product Mix Export - HotSchedules JIRA

Details

Type: Story
Status: Closed (View Workflow)
Resolution: Completed
Affects Version/s: None
Fix Version/s: CFA 2019R1
Component/s: Exports
Labels:
None

Sprint:
CFAMX 2019R1 Sprint 1, CFAMX 2019R1 Sprint 2
SOW (Time Tracking) Project:
tbd
Work Type Classification:
Sustaining

Description

Summary
Story 1: As a user of InFORM, I would like the Product Mix Export to contain a count for sales items refunded.

HotSchedules will add a node to the existing Product Mix Export called “RefundCount” that will contain a record count for items refunded. This count will be by sales item.

Acceptance Criteria

• Confirm the Product Mix Export contains a new node called “RefundCount”.
• Confirm when a sales item is refunded in the system, the record count in the xml displays the correct count.
• Confirm any new refunds increase the record count for the node called “RefundCount”.
• Confirm the values in the export match the value in the database for refunded items.

Notes
Tables that will probably be used
tbtransactionsalesitem
tbcontrolinfo (control info like refund)

the stored procedure might be qryMMSTransactionSalesItem_ProductMixForExport

LOE

May need new query to pull refunds
Staten Putnal please attached the query that you have
4 dev / 3 QA

Questions/Answers - 9/7/18

No Refund Amount needed
Refund Count is not currently visible and therefore does not need to match an existing export/UI/report

Story Reviewed by entire dev team on 9/7/18 and A/C accepted as presented.