Skip to main content

Posts

Change Liability Account with Personalization

The supplier has currency defined as EURO but a different one is used when entering the invoice.As you are on R12, some field/block names may be different: Condition -------------------------------------------------------------------------------- Trigger Event->WHEN-NEW-ITEM-INSTANCE Trigger Object->INV_SUM_FOLDER.INVOICE_AMOUNT_DSP Condition->:INV_SUM_FOLDER.INVOICE_CURRENCY_CODE = 'EUR' AND :SYSTEM.RECORD_STATUS = 'INSERT' Actions -------------------------------------------------------------------------------- Type->Property Object Type->Item Target Object->INV_SUM_FOLDER.LIABILITY_ACCOUNT Property Name->VALUE Value-> The Liabilty Account you want to use

How To Use Personalization To Set Bank Account Name As Required For Employee Suppliers?

1.Login Payables responsibility. 2.Navigate : Invoices =>Entry=> Invoice Batches or Invoice ( Depends on Invoice Batches enabled or not) 3.Navigate Tool Bar: Help=> Diagnostics =>Custom Code=>Personalize 4.Enter the below fields as examples Seq: 10 Description: Bank account is requested for Employee Suppliers Level:Function Enabled: Checked Condition Tab: Trigger Event:WHEN-VALIDATE-RECORD Trigger Object:PAYMENT_SCHEDULE Condition: ${item.payment_schedule.bank_account_name.value} is null and ${item.inv_sum_folder.pay_group_lookup_code.value}='Employee' Processing Mode:Both Press "Validate" and it shows "The Condition evaluates to true" Actions Tab: Seq:10 Type:Property Language:All Enabled:Checked Object Type:Item Target Object:PAYMENT_SCHEDULE.BANK_ACCOUNT_NAME Property Name:REQUIRED Value:TRUE Seq:20 Type:Message Language:All Enabled:Checked Message Type:Warn Message Text:Please enter the bank account name.

AP Invoices

Sections: Basic Invoice Details Basic Invoice Details With Lines Invoices Including Distributions And Projects Invoices Matched To Purchase Orders Invoice Details - Extra Info Invoice Details - Matching Holds AP Invoices - with Payment Numbers Basic Invoice Details -- ############################################################################## --      BASIC INVOICE DETAILS -- ############################################################################*/   SELECT aia.invoice_id id       , aia.invoice_num num       , aia.doc_sequence_value voucher       , aia.source       , aia.creation_date       , aia.last_update_date                , aia.invoice_date inv_date       , aia.invoice_type_lookup_code inv_type       , ...