- Get the script used in extracting of data in MySQL table in franchise reporting web app
- execute the script in MySQL to check if the total on-hand quantity extracted in the XML file is tally with the data in MySQL, as per checking XML total and MySQL total is tally.
- create a script and execute in Qtado to get the total on hand in JDA
- compare the total from JDA into MySQL total on hand, as per checking the total on hand from SQL is not tally to JDA
- copy the script used in JDA, change the field and table and execute in MySQL, the total extracted still not tally with JDA
- report the findings to Mark to refresh the inventory
- after the inventory is refreshed, I check the inventory total on hand but still get the incorrect total, reported this back to Mark
- He reported that there is a some missing items in product dim table in Masterfile, He runs a refresh for Masterfile
- after Masterfile refresh is finished, I check the total again, the SQL return bigger value
- Modify the script, remove the filter of "ibdept = 950 and isdept = 15" and execute the script
- the total for the modified script is now tally with the total in JDA
- applied the script used in MySQL in the extraction of data in PHP
- deploy the modify web app and test
- the extracted data in XML is now tally with the data in JDA