- check the concern received from sir Jowel, there is a Lacoste brand showing in the viewing of the total quantity, but it should be no Lacoste and it is not showing in the reports
- check if what is the error, if it is the total quantity or the reports, and as per checking, the error is in the total qty module
- the cause of the concern is the main table used in brand no and brand name is the invmst which should be table4, the count table
- modify the query and change the main table from invmst into table4
- test the modified application and as per checking it is now showing the correct data in the total quantity
- send the exe into the user for their checking tomorrow