"any other suggestions to zero out my open balance showing up on A/R report?"

Let's review that a 0 balance on the report means things are not applied to each other.

The request to Zero Out a balance means you Do Not Already have the offset or something that needs to be applied to it. Having a balance means it is waiting for you to Deal with it. Having a Zero Balance, but showing on the report, means things did not get Linked to each other, so the Math of the balance for the name is Zero.

These are two completely different conditions.

If you have an AP balance that you want to Offset, a positive balance or Bill is offset with a Bill Payment or a Vendor Credit. A negative AP balance means you have no Bill entered.