Need to hold a AP invoice based on comparison between Matched amount and Invoice amount
We have requirement where we need to have a mechanism in place when a there is an invoice with a different matched amount and invoice the AP invoice should be Hold.
AP invoice amount 5000
AP invoice line # 1 amount - 4500 matched amount - 4500
AP invoice line#2 amount - 500 matched amount - 0
This invoice will get validated as the invoice amount matches the invoice line amount , but our requirement here is to compare the total matched amount with invoice header amount if this comparison is not equal then this invoice should go on a hold.
Can we do such validation using Sandbox (Page composer/Application Composer) ?