Description |
+ *Background* +
When unposted settement is deleted, we cant find in the UI the unposted/deleted settement but the Maintain History Storage screen.
*Steps:*
Run DPR for 1/14/2019, location = Grass Valley
!pastedImage_d113410_0.png|height=456,width=710!
Note that the DPR shows 6,213.47 for Open Storage
!pastedImage_d113410_1.png!
Note that a filtered Storage screen from Ticket Management shows 3,725.73 for the Grass Valley location:
!pastedImage_d113410_2.png|height=319,width=842!
The DPR drilldown for Open Storage is showing two tickets that we can't find in the UI.
!pastedImage_d113410_3.png|height=312,width=815!
We had to run SQL queries to discover that STR-128/1 was REVERSED.
SELECT dblUnits, strType, strSettleTicket FROM tblGRStorageHistory WHERE strSettleTicket = 'STR-128/1'
!pastedImage_d113410_4.png!
Obviously reversed settlement tickets shouldn't be included but where did it get the 5,058.60 and 8,387.15?
+ *Acceptance:* +
-If it was reversed prior to the DPR as-of date then don't show it. If it was reversed after the as-of date then show it.
|