Till count Standard report (Drawer Count) is showing wrong results.
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.
Related Articles
Reprint Drawer Count Report
Product Version: iVend 6.6 with SAPB1 9.2 Problem statement: Is there any way to reprint the Drawer Count report for the past few days. Symptoms: NA Resolution/Work Around: Drawer count report is printed while assigning, removing, closing or ...Drawer Count Window Not Appearing in POS
Environment: iVend Retail 6.6 7989 & SAP Business One 9.3 Problem statement: Drawer Count window not showing after login in POS. Symptoms: “Count Required on Assign” Resolution/Work Around: Follow below steps to solve the issue. 1: Login in ...Till is not showing in POS
Till is not showing in POS This article will demonstrate to resolve the till issue, where till is not showing in POS, however, till has been created into the management console and it is displaying in Master till and till has been assigned. Case ...Till Mgmt and End of Day Processes in iVend Retail
Master Till The first step is to create the Master Tills. Each till requires a unique master record to be defined and then from this the user can set up the reusable tills. Each master till is used to generate the tills for use at the POS each ...iVend POS - Standard Report
iVend Retail POS – Creating a Standard Report using the Wizard This article provides the basic steps for creating a Standard Report through the use of the Report Wizard. When creating a report using the Standard Report Wizard, the report will contain ...