QUEST4APPS

Create Payment Method for Supplier in R12

—

by

Arun Raj
in , , ,

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 that Payment Method can be defined at Supplier Level, Site Level or both. How do we differentiate in R12?

  • Supplier Level payment method will have ORG_ID field as NULL in IBY_EXTERNAL_PAYEES_ALL Table.
  • Site Level Payment Method will have ORG_ID field populated and will also have the Supplier_site_id and Party_site_id columns populated in IBY_EXTERNAL_PAYEES_ALL Table

Importing Suppliers using Open Interface

  • Populate the payment_method_lookup_code in AP_SUPPLIERS_INT table to create the payment method at Supplier Level
  • Populate the payment_method_lookup_code in AP_SUPPLIER_SITES_INT table to create the payment method at Supplier Site Level

Using API to create the Payment Method

  • IBY_DISBURSEMENT_SETUP_PUB.Create_External_Payee to create the Payment Method
  • IBY_DISBURSEMENT_SETUP_PUB.Update_External_Payee to update the Payment Method

I have attached a sample code to create the Payment Method using API. You can download the same below:

supplier_level

site_level

I will post another one on Update Payment method API. Hope this helps. Post your questions and I will try my best to answer those!!

Comments

5 responses to “Create Payment Method for Supplier in R12”

  1. Balaji Gopalakrishnan Avatar
    Balaji Gopalakrishnan

    Arun, your articles are always worth reading buddy, keep going…

    Reply
    1. sarunraj Avatar
      sarunraj

      Thank you for the kind words!! Trying my best..

      Reply
  2. sv Avatar
    sv

    Hi,
    While looking for details on this API, i came across your website. My case is that a Supplier with 2 sites are already there in the system but no default payment method is present. Data is present in the IBY_EXTERNAL_PAYEES_ALL table but not in the IBY_EXT_PARTY_PMT_MTHDS

    My goal is to populate the default payment method and have it displayed in the application,

    My questions are:
    1.Should i be using Create or the Update version of the External_Payee API to create the default payment method
    2. Once the default payment method is populated, will the
    IBY_EXT_PARTY_PMT_MTHDS table be populated.
    3. Do i need to use the API 3 times ( 1 for Supplier level, 1 for each of the 2 Vendor sites?)

    Reply
    1. ArunRaj Avatar
      ArunRaj

      Hi Savitha,

      1.Should i be using Create or the Update version of the External_Payee API to create the default payment method
      >> I had the same issue and Update API didnt work for me. I had to remove the records and then re-create the records using the Create Payment Method API.
      I will check this once more and let you know.

      2. Once the default payment method is populated, will the IBY_EXT_PARTY_PMT_MTHDS table be populated.
      >> Yes

      3. Do i need to use the API 3 times ( 1 for Supplier level, 1 for each of the 2 Vendor sites?)
      >> Yes, you need to call the API three times.

      If you have more questions, feel free to let me know in the comments section.

      Thanks,
      Arun

      Reply
  3. sv Avatar
    sv

    Thank you for your suggestion. I will try it and let you know.
    Regards,
    SV

    Reply

Questions? Comments? Suggestions? Let us know!! Like / Subscribe / Follow for more updates.

Latest Posts

Check out these latest posts that you may be interested in.