Questions Python Script Ignoring Report Global Sorting in Acumatica // Returning Incorrect Values from Endpoints

Here’s some more color:

• Using three separate reports that are based off of GIs. These reports in Acumatica are being called to via endpoint to get the correct values (called via python script)
• In of the reports, there is global sorting applied in the report. This is being ignored sporadically across the report.
• When comparing the python generated excel report to the exports from the GIs and the Acumatica reports, the Acumatica reports are returning the correct values.
• The generated report is not honoring the sorting logic from the Acumatica report in some cases for each SKU, for some but not others and it seems when there are multiple lots with different values, that it's not picking the lowest value (as it does in Acunmatica report). 
• It’s not for every SKU, just sporadic SKUs when there are multiple lots with different test results/THC values

Is anyone familiar with why the python script would sporadically ignore the applied global sort in the generated excel file? Does anyone have any familiarlity with this? Asking or a friend or a life line here. Mycoworker has put a lot of energy and time into this report, and this was found in the final stages of QA.