Dynamics NAV - LS Retail - Calculate Statement - Multiple safe entry lines are duplicated

This happens when the [Trans_ Safe Entry] table has duplicates for whatever reason.

To resolve it, delete the duplicated records out of the [Trans_ Safe Entry] table





 
 SELECT * FROM [Safe Statement Line] where [Statement No_] ='000099'

SELECT * FROM [Trans_ Safe Entry] where [Store No_] = 'SS' and [Statement Code] = 'MYSTMT' and [Tender Type] in (13,14) order by timestamp

select * FROM [Trans_ Safe Entry] where [Transaction No_] >= 16943 and [Transaction No_] < 16951 and [POS Terminal No_] = 'SS02'

delete FROM [Trans_ Safe Entry] where [Transaction No_] >= 16943 and [Transaction No_] < 16951 and [POS Terminal No_] = 'SS02'