-
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
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
May need new query to pull refunds
Staten Putnal please attached the query that you have
4 dev / 3 QA
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.