Is there a way to update the Match Approval Level from 3 way to 2 way in PO Schedule using FBDI?
Summary:
We have a requirement to mass update the Match Approval Level to 2-Way for existing Open purchase orders.
I have downloaded the POPurchaseOrderImportTemplate.xlsm and have populated the required fields.
I have read that Match Approval Level is not directly available as a field, but this value is derived from Receipt Required/Inspection Required values.
- Receipt Required = ‘N’ is equivalent to 2-Way match
- Receipt Close Tolerance Percent = ‘100’
- Invoice Match Option = ‘Order’
This is already done in PO_LINE_LOCATIONS_INTERFACE sheet.
I have also populated the required fields in PO_HEADERS_INTERFACE sheet.
However in PO_LINES_INTERFACE, there is no updating of PO line - it only accept ‘ADD’ as an action.
Tagged:
0