I have been testing automatic application of prepayments for the imported invoices in the system. We are bringing in invoices in the system through power automate or excel data entities.
As per the relevant microsoft docs for this automatic application we can see that it supports multiple prepayments as well.
However, during testing these are the two scenarios we are facing an issue with. Please if you can guide will be a great help:
1. In the first scenario we created a prepayment for $2000/-. However changed the line amount to $1000/-. When we did that we were left with an additional invoice of $1000 that we kept in abeyance and did not submit to workflow or post in the system. The first prepayment (PRE-1) was posted in the system and Vendor payment was created. When the invoice was bought in the system, prepayment was applied. Now the process automations helped the invoice get submitted in the system and was subsequently posted. After the invoice was posted, the system is not allowing us to post the second preppayment invoice (PRE-2) and has greyed out the prepayment option from the invoice tab. Moreover further prepayments cannot be created. The surprising thing is that the prepayment option under the purchase action tab shows that the prepayment has been created for $2000/- but the amount left for application is $0.00.
2. in the second scenario we did the same as before, but over here we posted both the prepayments PRE-1 and PRE-2. However, we iniitially created the payment for PRE-1 only and that was applied to the invoice that was imported in the system. However, when the invoice was posted in the system, the entry of PRE-2 was completely reversed by the system on its own. We still could not do the second prepayment and its application.
Please guide as to why this is happening. Please note testing has been carried out on 10.0.24 update 48
