You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!