Automatic Payment Program (F110) S4 Hana 1809

I am facing an issue while payment to vendor through F110.

Scenario is that I gave vendor Advance Let say 10 USD. Then Vendor send me Invoice Let say 100 USD. The total Liability to vendor is 90 USD. That means i have to pay 90 USD to my vendor. When i pay through F110. It is paying Invoice amount of 100 USD. It is not taking into consideration advance that i have paid. The APP should pay 90 USD. There is an option debit balance check, when i run that option it is showing not items exist.

What is the solution for that?

Thanking in Advance