The Invoice Header form derives the invoice validation Status based on the following:
- Validated: If all of the invoice distributions have a MATCH_STATUS_FLAG = 'A'
- Never Validated: If all of the invoice distributions have a MATCH_STATUS_FLAG = null or 'N'
- Needs Revalidation:
- If there are any rows in AP_HOLDS that do not have a release code.
- If any of the invoice distributions have a MATCH_STATUS_FLAG = 'T'.
- If the invoice distributions have MATCH_STATUS_FLAG values = 'N', null and 'A'.
Use AP_INVOICES_PKG.GET_APPROVAL_STATUS to find the approval status.
No comments:
Post a Comment