After creating an invoice, validating it, and registering part payment (say pay 500 out of 1000), I expected to see a balance of 500 on the invoice so I could track payments of that particular invoice but I see '0.00' on balance which shouldn't be the case

I managed to have it work perfectly on a different database I configured but I cannot figure out what made it work. Could any one be of help please?