1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Bank details are not showing to the specific supplier in R12

Discussion in 'General' started by kartheekbk, Oct 8, 2014.

  1. kartheekbk

    kartheekbk Active Member

    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    80
    Hi,

    when I ran Supplier Bank Account Creation report in R12, I got error "The external bank account already exists-Bank Acct No- XXXXXXXXX for supplier XXXXX

    but when I checked it front end under supplier form, I don't find any bank accounts for the specific supplier.

    select * from IBY_EXT_BANK_ACCOUNTS where bank_account_num = ' XXXXXXXXX';​ --record found, and got the ext_bank_account_id value and gave in next query

    select * from IBY_PMT_INSTR_USES_ALL where instrument_id = 21639 -- record found and got ext_pmt_party_id value and gave in next query

    select * from IBY_EXTERNAL_PAYEES_ALL where payee_party_id = 94657
    for this, i don't find any records.

    it seems there are inconsistencies between IBY_PMT_INSTR_USES_ALL and IBY_EXTERNAL_PAYEES_ALL tables.
    if yes, can you explain me what details i need to update in front end for this bank ac/supplier ?

    or is any inconsistencies exists for this user ?

    Please advise.
     
  2. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    wordpress help cheshire

    website support cheshire
     
  3. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    website support cheshire

    website support cheshire
     
  4. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    wordpress help cheshire

    cheshire web design
     
  5. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    website support cheshire

    website support cheshire
     
  6. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    website support cheshire

    ecommerce crewe
     
  7. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    ecommerce crewe

    ecommerce crewe
     
  8. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    wordpress help cheshire

    wordpress help cheshire
     
  9. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    web design nantwich

    ecommerce crewe
     
  10. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    website support cheshire

    cheshire web design
     
  11. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    ecommerce crewe

    wordpress help cheshire
     
  12. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    cheshire web design

    cheshire web design
     
  13. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    wordpress help cheshire

    cheshire web design
     
  14. Georadekmek

    Georadekmek Starter

    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    USA
    ecommerce crewe

    cheshire web design