Update Supplier Payment Method

Hey all.. This is in continuation to my blog on “Create Payment Method API“. Let us take a look at how to update payment method using APIs. API => iby_disbursement_setup_pub.update_external_payee My requirement was to update the payment method for all the supplier sites that has payment method as “EFT” but no Bank Information. You may download […]

Remittance Advice Email ID for Supplier

Remittance Advice Remittance Advice provides information about the invoices that are being paid as part of a payment. It is very common to deliver the document to the supplier’s email id. You can retrieve the email id to which the Remittance Advice will be delivered from IBY_EXTERNAL_PAYEES_ALL Table. You can use the below query to find the […]

Create Payment Method for Supplier in R12

You are going looking for the Payment Method and Payment Method changes in AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL Tables and you don’t find any. You are disappointed and frustrated. Well don’t you worry, I possibly have the cure for that. Payment Method for suppliers in R12 can be seen in the below tables: IBY_EXTERNAL_PAYEES_ALL IBY_EXT_PARTY_PMT_MTHDS We know […]

Generate Positive Pay or ACH output in a Specified Directory

Let us look at how we can generate the Positive Pay File / ACH Output in a particular directory on your server. As always, this will be mostly screenshots so that it makes it easier for you to understand. Navigate to Payables Manager > Setup > Payment > Payment Administrator Click on the Payment Process […]

Make City, State, Postal Code mandatory for Supplier / Supplier Site Address

Requirement is to make the City, State and Post Code fields on the address (Supplier / Supplier Site) as mandatory. As you know, out of the box, these fields are non-mandatory. How do we achieve this? Well, personalization is not the way to get this done. 1. Get the values of the below Profile Options […]