Product Version : 

iVend 6.6

Problem Statement : 

Till count Standard report (Drawer Count) is showing wrong results.

Proposed Solution : 

We have used sql profiler and found in the report query where clause(rownumber=1) is mentioned wrong that why report is not picking multiple payments count for tender type including 0 count. This is the report issue if we remove the where clause for row number =1 and import updated .irt report for drawer count found report is generated correctly and showing all tender types.

Steps to reproduce the issue :

The steps are:

Go to Till management, remove and close the till.

Verify counting screen will prompt

Do the payment count for custom tender type.

Verify other tender types in the list as well like Cash, Credit Card.

Once payment count is done for custom tender type check the drawer count report in A4.

Verify the drawer count report and find only one random payment count.

The payment count which we have done for the custom tender type is not shown.

Please run the profiler and do the same steps, which are mentioned above.

Fetch the related query and execute in the database.

Please check and verify only one row is returning in the result.

Please execute the query without where clause rownumber=1 and verify the result.

We can see the above result set and find all tender types are shown.