Payables & Cash Management

Get Involved. Join the Conversation.

Posts

  • Brandon Sell
    SLA account rule for tax that takes segments from the AP...1
    Topic posted November 19, 2019 by Brandon SellBlue Ribbon: 750+ Points, tagged Accounting Hub Cloud Service, Configuration, Payables, Subledger Accounting 
    Title:
    SLA account rule for tax that takes segments from the AP invoice distribution
    Content:

    We have a requirement for accounting on the recoverable and nonrecoverable tax lines. The cost center and location segments need to be the same as the AP invoice distribution line that the tax comes from. Is this possible?

    I tried creating 2 account rules that use the Source: "Invoice Distribution Account" and I selected the 2 segments that I needed. I applied these 2 rules to the invoice journal rule set in AP for both recoverable tax and nonrecoverable tax. However, when testing by creating the accounting, the tax lines still used the account string setup on the tax.

    I found a MOS document ( Doc ID 1914253.1 ) that says this is not currently possible in E-Business Suite for EBTax. Could the same true for taxes in Cloud for payables?

  • Akarsh Arun
    Multiperiod Accounting completes with warning3
    Topic posted November 6, 2019 by Akarsh Arun, tagged Financials, Payables, Subledger Accounting 
    Title:
    Multiperiod Accounting completes with warning
    Summary:
    Multiperiod Accounting completes with warning
    Content:

    Hi All,

    I have come across an issue. Create MultiPeriod Accounting for Payables completes with warning and execution report has the error - "Journal entry was not created because no data could be found. Details: Multiperiod transaction data must be available in subledger transaction objects until the last multiperiod journal entry has been accounted."

    If I look at the log of the program, it has the information that there are no lines of the transactions. Also, these transactions are seen in xla_errors and we see the error message as "There are no eligible transactions to be processed. Cause: The accounting program cannot find any eligible transactions for processing. Action: Change the parameters or submit the request at a later time when there are transactions requiring accounting."

    Please help me in identifying the issue and a resolution for this.

    Thanks,

    Akarsh Arun

     

    Version:
    19c
  • Sachin Mistry
    Custom Validation on AP Invoice line based on account...3
    Topic posted October 24, 2019 by Sachin MistryGold Medal: 3,500+ Points, tagged Payables, Subledger Accounting, User Interface 
    Title:
    Custom Validation on AP Invoice line based on account segment value
    Summary:
    Custom Validation on AP Invoice line based on account segment value
    Content:

    Is it possible to write an expression that will prevent the invoice from getting saved or give a validation error to enter project number when ap specialist uses project clearing account?

    We have a requirement where for invoices related to projects, we have our AP team use project clearing account. But whenever they use project clearing account, they must enter project number, task number, expenditure category. Lot of times, they use project clearing account but do not enter project details.

    How can we go about doing it?

    Sachin

  • Tousif Azam
    Invoice Accounting Issue15.0
    Topic posted October 24, 2019 by Tousif AzamGreen Ribbon: 100+ Points, tagged Payables, Subledger Accounting 
    Title:
    Invoice Accounting Issue
    Summary:
    Invoice not getting accounted due to non-recoverable tax lines
    Content:

    Hello,

    I have an intercompany invoice in AP which isn't getting accounted. The distributions on the invoice do not have the non-recoverable tax entries. But, according to the create execution report, the application is creating non-rec tax lines which violate the CVR rules and hence the invoice isn't getting accounted. Can someone please explain how additional lines are being generated while the invoice is trying to get accounted? 

    PS: We have used self assessed tax in this invoice.

    Version:
    19C
  • Leyla Ören
    Balance Account
    Topic posted October 24, 2019 by Leyla ÖrenRed Ribbon: 250+ Points, tagged Financials, Payables, Setup / Administration, Subledger Accounting 
    Title:
    Balance Account
    Summary:
    Balance Account
    Content:

    Hello,

    We've entered the EUR invoice, but payment currency is RON. When we paid the invoice and accounted the payment, there is 689 account on payment accounting although there is 900 account on the Entered Currency Balancing Account on the specify ledger options. 

    Thanks

    Version:
    19C (11.13.19.07.0)
    Image:
  • ALEXANDER JOSEPH
    Default the distribution combination based on Project...Answered4
    Topic posted October 10, 2019 by ALEXANDER JOSEPHRed Ribbon: 250+ Points, tagged Payables, Setup / Administration, Subledger Accounting 
    Title:
    Default the distribution combination based on Project details
    Summary:
    Default the distribution combination based on Project details
    Content:

    Requirement is to default the distribution combination based on Project details.

    Setup done:

    We have setup project accounting rules for the various segments and linked it to the Subledger Journal Entry Rule Sets for payables for invoice event class and different journal lines for item expense , tax etc

    Created a distribution set to default a distribution combination and then based on the above rules , the new distribution combination would be derived.

    Issues/Clarifications:

    1. Is it necessary to create a distribution set to default a distribution combination. We are unable to derive the distribution combination from the Subledger Journal Entry Rule Set unless there is a distribution set?

    2. In Procurement , when the user enters the Project details , the distribution combination are populated immediately. In the case of AP , this happens only when we run Create Accounting.Is this the functionality?

    3.The distribution combination is created correctly when Create accounting is doen and posted to ledger , however the new combination doesnt get updated on the invoice

    4.Account coding workflow functionality cannot be used since the user now has to enter both the project details and distribution combination which doesnt make sense

    5.Is there an option to disable the distribution combination field on the invoice

    Please point me to any documentation if available

    Thanks

    Alex

     

     

  • Dev Thota
    Can we transmit a single payment which was created through...15.0
    Topic posted September 24, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Accounting Hub Cloud Service, Allocations, Assets, Budgetary Control, Cash Management, Collections, Compliance, Configuration, Core HR, Expenses, Financials, General Ledger, Help Center, Intercompany, Invoice Imaging, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Sample Reports, Search, Security, Setup / Administration, Subledger Accounting, Subscriptions, Tip, Update, User Interface 
    Title:
    Can we transmit a single payment which was created through " Create Payment" option?
    Summary:
    Can we transmit a single payment which was created through " Create Payment" option?
    Content:

    Hi all,

    Can we transmit a single payment which was created through the " Create Payment" option?

     

    Thanks,

    Dev Thota.

    Version:
    19C
  • Amy Chan
    Manage Bank Account1
    Topic posted September 9, 2019 by Amy ChanSilver Medal: 2,000+ Points, tagged Cash Management, Subledger Accounting 
    Title:
    Manage Bank Account
    Summary:
    Manage Bank Account
    Content:

    Hi all,

    This is new feature of 19c - Segregate the Privilege to Manage Bank Account Security.

    Use the Segregate the Privilege to Manage Bank Account Security feature to restrict the users who can modify the bank account security. 

    The Security tab of the Bank Accounts page allows you to further secure the bank account so that it can only be used by certain users and roles.

    This tab is now secured by the new privilege 'Manage Bank Account Security', allowing you to segregate the security administration of bank accounts.

    • If you have a role with the assigned Manage Bank Account Security privilege, you will be able to modify the bank account security access, and manage the users and roles that can access the bank account.
    • If you don't have a role with the assigned Manage Bank Account Security privilege, you will only be able to review the users and roles that can access the bank account.

    Bank Accounts page

    I have a question for this new feature. Let say's I have assigned myself with access right to inquiry bank account information. What if I put my name in the "Security" tab too? I don't understand how does it work?

    Please share.

     

     

     

  • BALA RAYUDU
    Custom Role to run Subledger Create Accounting as Business...4
    Topic posted September 4, 2019 by BALA RAYUDU, tagged Financials, General Ledger, Payables, Security, Subledger Accounting 
    Title:
    Custom Role to run Subledger Create Accounting as Business Unit specific
    Summary:
    How to create a Custom Role to run BU specific Create Accounting
    Content:

    Have a requirement to run BU specific Create Accounting Custom Role, when user runs Create Accounting should not pic other BUs Events in the Same Ledger. 

    Example roles Custom Accounts Payable Manager assigned one BU Data Access. 

    Any options and help would be appreciated.

    Thanks,

    Bala.

     

  • Thomas Paul
    AP transfer to GL in Detail11
    Topic posted August 26, 2019 by Thomas PaulBronze Medal: 1,250+ Points, tagged Financials, General Ledger, Payables, Setup / Administration, Subledger Accounting 
    Title:
    AP transfer to GL in Detail
    Summary:
    AP Transfer in Summary-Planning to move to Detail
    Content:

    Hi,

    Currently we are transferring AP subledger details to GL in summary mode. Because of reporting needs(and other business reasons), we are looking at transferring the subledger details in Detail mode. However, in my experience, most of the clients do this in summary mode. Can someone provide any info on the following:

    - Any impact on performance(we are not high volume user) if we change from Summary to Detail. 

    - Pros and Cons of summary vs detailed

    - Any setup document listing the steps needed to achieve the detailed transfer(I believe new SLA rules need to be defined).

    Thanks!

    Thomas