Cash Day Summary is randomly being sent with Monies to be deposited when a shift comes in after finalize day

Scenario - When a shift comes over after Finalize Day, we should re-export Cash Day Summary with Monies to Be Deposited value (which will now be >$0)

Steps to reproduce :

1) Finalized the Day on Store 00096 in testing for May 17

2) waited some time, opened a new cashier, created sales and settled. The Shift came across and caused the export to be triggered again. See tbAudit for entityid 62 and audit ID between '6153772' & '6153889'

• Start Work Flow  Settle Cashier Shift and Authorize Finalize Day WorkFlow 
  • tbAudit.auditID '6153772' to '6153814'
• CDS is sent to CFA
  • tbAudit.auditID displays export is processed and archived  '6153819' to '6153823'
    • CFA Cash Day Summary Export processed Successfully
      \\ATL2CFANPV002\CFATesting\DataExports\CashDayExport\Ready\CashDaySummary_00096_20220517.xml file has been deleted to be overwritten.
    • \\ATL2CFANPV002\CFATesting\CachedReports\2022\05\17\CFA Cash Day Summary_20220517-20_49_23_118$E5516F60.xml outputfile has been moved to CashDaySummary_00096_20220517.xml file successfully.
    • CFA Cash Day Summary export for destination Cash Day Summary of type Webservice was successful.
    • Archived file CashDaySummary_00096_20220517.xml for export CFA Cash Day Summary.
• likewise Product Mix updated 
• Open Second Shift and settle. Shift displays in MXC( this will cause Monies to Be Deposited to be >$0 and will trigger Sales after Finalize Day email  
  • tbAudit.auditID '6153847'
• CDS is processed a 2nd time
  • tbAudit.auditID '6153848'
• CDS is deleted from Ready folder 
  • tbAudit.auditID '6153849'
    • \\ATL2CFANPV002\CFATesting\DataExports\CashDayExport\Ready\CashDaySummary_00096_20220517.xml file has been deleted to be overwritten.
• CDS moved to CachedReports
  • tbAudit.auditID '6153850'
    • \\ATL2CFANPV002\CFATesting\CachedReports\2022\05\17\CFA Cash Day Summary_20220517-21_08_23_370$E5A446CA.xml outputfile has been moved to CashDaySummary_00096_20220517.xml file successfully.
• CDS Webservice is triggered the 2nd time
  • tbAudit.auditID '6153851'

3)tbExportQUEMessage table reveals that the CDS is exported again and passed

Select * from tbExportQueueMessage
where EntityID = 1041
and XSLTExportTaskID = 95
order by businessday desc

3)If You look at the Cached Reports --> \\ATL2CFANPV002\CFATesting\CachedReports\2022\05\17

We see the data like the logs displays and the Cash Day Summary has the Monies to Be Deposited value. See this record (CFA Cash Day Summary_20220517-21_23_15_184$DDB781EA.xml) #3 in the image posted below

However, the CDS sent to CFA appears to be this one --> CFA Cash Day Summary_20220517-21_08_23_370$E5A446CA.xml  NOTE: This one has the 2nd Cashier Shift but does not have the Monies to be deposited value. #2 in the image posted below

Expected results: 

Monies to be deposited should be $670 and sent to CFA

Defect: 

Monies to be deposited $0 and this is what is being sent to CFA