Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Sathya Kannan
    Bank Account changes AuditAnswered
    Topic posted October 22, 2019 by Sathya KannanBronze Medal: 1,250+ Points, tagged Cash Management, Configuration, Financials, Payables, Reports, User Interface 
    36 Views, 2 Comments
    Title:
    Bank Account changes Audit
    Summary:
    Bank Account Number and Bank Branch changes need to be audited
    Content:

    Hi,

    We have enabled the external and internal bank account auditing last year and we would like to know only the changed bank account number and bank branch details from the account audit tables.

    I'm currently referring this table - IBY_EXT_BANK_ACCOUNTS_ , but I see some rows with bank account numbers with NULL bank branch ID and some rows with branch IDs and null account numbers displayed with Audit action type as 'Update' along with AUDIT_CHANGE_BIT_MAP_ as 0. 

     

    Could you help me understand this audit table and guide how to extract the bank account number and bank branch changes alone, please?

     

     

    Regards,

    Sathya Kannan

    Best Comment

    Phil Nibert

    You may also want to see if you can use the following Audit Report showing changes to the Supplier Master:

    Path is Tools / Audit Reports

    Enter a date range

    Enter a Product of "Supplier Model".

    Report shows who made the change and what the change was.

    We have been using the report to help our audits - the report seems accurate so far.

    Phil

    Comment

     

    • Phil Nibert

      You may also want to see if you can use the following Audit Report showing changes to the Supplier Master:

      Path is Tools / Audit Reports

      Enter a date range

      Enter a Product of "Supplier Model".

      Report shows who made the change and what the change was.

      We have been using the report to help our audits - the report seems accurate so far.

      Phil

    • Sathya Kannan

      Thanks Phil, We haven't enabled the Supplier model audit policy for Supplier bank accounts.