Getting erroneous results when running resource loading report to a .csv file

Running P6 Professional 8.4.7

When I run a .csv version of a resource loading report - set to return two codes and remaining units of a material resource, spread over time( so it can be imported into another program) P6 is returning remaining units prior to the data date for resources that do not have any units assigned. A signature of the erroneous entries are the first code is missing in the data. I have checked all the resources in the resource assignments tab and the missing code is assigned to every resource with budgeted units. Has anyone ever had issues with csv report