- check the query for extracting data for the old grand total and total transaction count for checking the cause of the concern form SM admin, that the mall sending return zero for the two fields
- as per checking, the grand total extracted from MySQL is not saving into MDB due to the incorrect condition, this causes the application to extract zero value as the extracted data into textfile is from MDB
- modify the code and remove the condition in extracting previous gross sale to save in MDB and modify the query to correct the extracted data from the database
- test the modified application, generate a text file, and check the generated file
- as per checking the field for old grand total has value now in the textfile
- check if the extracted data is tally in the database, and as per checking, is tally to the database