Im Business Central, we're trying to estalish a process that allows users to create a 2/3-Way match in purchasing but it seems like there is no validation that checks that what is being invoiced matches with what was in the PO.
Example:
A PO is created for an item with Quantity 1 and Unit Cost set to 500.00
The PO as approved and is posted as Received (not invoiced)
A Purchase Invoice is created and used the functionality to Get Receipt Lines (As expected, this creates a line in the invoice for the item received, quantity1 and unit cost set to 500)
The user changes the Unit Cost to 600.00 and posts the invoice.
Is there a way for BC to check that there is a mismatch between the cost in the PO (500) and the one being invoiced (600)? Can we restrict the users from making such changes?
(We have already looked at the feature Check Doc. Total Amount in the Purch. & Payables setup but it does not cater for the scenario above)
Any insight on the above is appreciated - thankyou!