-
goal: How is the price variance account populated when matching invoice to
PO?
-
fact: Oracle Payables 11.0
-
fact: Oracle Payables 10.7
-
fact: AP - Invoice Workbench
fix:
The price variance account for the invoice is determined
after matching to PO according to the following rules:
1) If the Destination Type is other than EXPENSE, the price variance account
will be PO distribution variance account.
if the po_distributions_all.destination_type_code != 'EXPENSE'
then ap_invoice_distributions_all.price_var_code_combination_id =
po_distributions_all.variance_account_id.
2) If Destination Type is EXPENSE and accrue on receipt is Y, the price
variance account will be the PO distribution Expense Account.
if po_distributions_all.destination_type_code = 'EXPENSE' and
po_distributions_all.accrue_on_receipt_flag = 'Y'
then ap_invoice_distributions_all.price_var_code_combination_id =
po_distributions_all.code_combination_id.
3) If Destination Type is EXPENSE and accrue on receipt is N, the price
variance account will be the invoice distribution expense account.
if po_distributions_all.destination_type_code = 'EXPENSE' and
po_distributions_all.accrue_on_receipt_flag = 'N'
then ap_invoice_distributions_all.price_var_code_combination_id =
ap_invoice_distributions_all.dist_code_combination_id
|