Posts

Posts

  • Sathya Kannan
    Assign pay group for customer refunds1
    Topic posted December 4, 2019 by Sathya KannanBronze Medal: 1,250+ Points, tagged Configuration, Financials, Receivables in Core Financials > Payables & Cash Management public
    Title:
    Assign pay group for customer refunds
    Summary:
    How to assign a pay group for customer refunds
    Content:

    Hi,

    Payment request option in Manage invoice Options is set to have pay group called 'Employee' , and so all the employee expenses and customer refunds are being created with a pay group called 'Employee' and paid under a single pay group. However, we want to pay the customer refunds under a different pay group. Is it possible to achieve? If yes, please advise the steps.

     

    Regards,

    Sathya Kannan

  • Ravi Upadhyayulla
    Cash Advances - Refund of unused cash adavnce1
    Topic posted December 4, 2019 by Ravi UpadhyayullaBlue Ribbon: 750+ Points, tagged Expenses, Financials, Payables, Receivables in Core Financials > Expenses public
    Title:
    Cash Advances - Refund of unused cash adavnce
    Summary:
    Refund of unused cash advance
    Content:

    Hi,

    Employee requests cash advance $500.

    Submits expenses worth of $350. Cash advance gets applied to the payment request in AP.

    $150 still available for any future expense. 

    Employee has no further travel or left the company. (actual reimbursement can be done several ways, employee giving cheque, or deduct from final payroll).

    How to close the loop in AP for that $150.

    Any ideas would be appreciated.

    Thanks

    Ravi

  • mohammed qurram
    Gift card Business process in Oracle Fusion ReceivablesAnswered2
    Topic last edited January 30, 2019 by mohammed qurramRed Ribbon: 250+ Points, tagged Collections, Financials, Receivables, Revenue Management in Core Financials > Receivables & Collections public
    Title:
    Gift card Business process in Oracle Fusion Receivables
    Content:

    Hello,

     

     

    We have a requirement to manage gift card/voucher in fusion receivables

     

    ABC Inc. who is planning to sell it's own gift card to customers, there will be two business transaction.

     

    1. Gift card purchase by customer A

    2. Redeem the Gift card (by customer A or B) in one go or multiple transaction while taking service from ABC Inc.

     

    Since Gift card is not actual revenue until it is redeemed, it would hit Deferred Revenue account and then redemmed, the revenue must be realized.

     

    Is there any standard process or a workaround solution for Oracle Fusion R 12/13

     

    Regards

    Qurram

  • Matt Nease
    Data Access by Legal Entity instead of Business UnitAnswered55.0
    Topic posted November 7, 2019 by Matt NeaseGreen Ribbon: 100+ Points, tagged Financials, Receivables, Security, Setup / Administration in Core Financials > Financials – General public
    Title:
    Data Access by Legal Entity instead of Business Unit
    Summary:
    How to assign data access to users by Legal Entity using custom Database Resource
    Content:

    A client has a requirement for billing managers to manage receivables activities by Legal Entity. Currently we have set up custom job roles that use Data Security Policies driven by Business Unit. However their are multiple LEs per BU, and the customer wants to restrict by LE, not BU. 

    I know under 'Security Console > Administration > General > Manage Database Resources' you can create a custom Database Resource, which is clear. However, FUN_USER_ROLE_DATA_ASGNMNTS does not have a Legal Entity column, so you seemingly cannot assign Legal Entities to users via 'Manage Data Access for Users', so I don't know what to do with the custom Database Resource . Is there another way to assign potentially multiple Legal Entities to a user other than 'Manage Data Access for Users' (or derive it somehow), that I could then use as a Condition SQL Predicate in a custom Database Resource? A billing clerk could handle 2 or more LEs, so I don't think it can be derived from their HR record.

  • Brandon Sell
    Unable to automatically calculate taxes on an AR InvoiceAnswered5
    Topic posted November 19, 2019 by Brandon SellBlue Ribbon: 750+ Points, tagged Configuration, Financials, Receivables in Core Financials > Receivables & Collections public
    Title:
    Unable to automatically calculate taxes on an AR Invoice
    Content:

    We are trying to calculate taxes automatically on invoices in Receivables for Canada with no luck. I believe everything is configured correctly because the calculation of taxes in AP for invoices is working perfectly.

    Can AR calculate taxes with no tax determinants filled in on the line level? When we select a tax classification code for the line, it will sometimes calculate correctly. For example, If we have a bill-to/ship-to in Ontario and select the ON HST tax classification, taxes will calculate correctly. However this doesn't work for non-HST provinces. Like for British Columbia, if we choose the BC GST it will calculate the GST, and if we choose the BC PST it will calculate that, but it will not calculate both. 

    Is there a way for us to set up a tax determinant on the line level that will calculate for any of GST, PST, HST, and QST all at once?

    Image:
  • Yash Rohra
    AutoInvoice import issue with OIC
    Topic posted December 2, 2019 by Yash Rohra, tagged Receivables in Core Financials > Receivables & Collections public
    Title:
    AutoInvoice import issue with OIC
    Summary:
    AutoInvoice import submitted by OIC integration does not pick any records
    Content:

    AutoInvoice import submitted by OIC integration does not pick any records

     

     

    I am having an odd problem integrating with Oracle Cloud ERP... I am submitting a job using the Cloud ERP connector.. with the property file... it submits Import AutoInvoice perfectly... but it does not pick any records... and I submit the same job in the integration user... records which were in the interface submitted by OIC are picked... any clue why ?

  • Aly Yassin
    How to change the revenue account imported from sales order...1
    Topic last edited November 27, 2019 by Aly Yassin, tagged Receivables, Subledger Accounting in Core Financials > Financials – General public
    Title:
    How to change the revenue account imported from sales order by SLA
    Content:

    How to change the revenue account line with discount imported from sales order by SLA

    when I import the sales order with discount line after autoinvoice process and create AR transaction

    DR/ Receivables   100

      CR /Revenue  110

      CR/ Revenue - 10 ( discount from SO ) 

    Customer need to use another GL account for discount line other than the revenue account

    How can i use SLA for this requirement?

  • Mark Adams
    If logic in RTF template has stopped working.
    Topic posted December 2, 2019 by Mark AdamsRed Ribbon: 250+ Points, tagged Receivables in Core Financials > Receivables & Collections public
    Title:
    If logic in RTF template has stopped working.
    Content:

    Hi there,

    Within our Billing RTF template we have some IF logic which pulls through certain data depending on certain data being pulled through the data model.

    This has been working fine up until recently. All of a sudden the IF logic has stopped working and when the template generates the invoice it completely leaves out the IF logic element of the template.

    We haven't touched the template since Oracle was implemented. We also have it seeded as the default invoice template.

    Anyone had any issues like this before ? Any tips or troubleshooting would be gratefully received.

    Thanks

    Mark

     

     

     

     

     

  • brightstar
    Fusion Receivables: Short Term and Long Term Deferred...2
    Topic posted September 5, 2019 by brightstarRed Ribbon: 250+ Points, tagged Receivables, Revenue Management in Core Financials > Receivables & Collections public
    Title:
    Fusion Receivables: Short Term and Long Term Deferred Revenue Accounting
    Summary:
    Fusion Receivables: Short Term and Long Term Deferred Revenue Accounting
    Content:

    Client sells a service contract for 2 years.

    AR need to book their short term (within 12 months) deferred revenue to a specific account 'X', and book their long term deferred revenue in a different account 'Y'. Below Example in Sep-19.

    Service Contract - 2 years = $12000
    Year 1   Year 2  
    Sep-19 500 Sep-20 500
    Oct-19 500 Oct-20 500
    Nov-19 500 Nov-20 500
    Dec-19 500 Dec-20 500
    Jan-20 500 Jan-21 500
    Feb-20 500 Feb-21 500
    Mar-20 500 Mar-21 500
    Apr-20 500 Apr-21 500
    May-20 500 May-21 500
    Jun-20 500 Jun-21 500
    Jul-20 500 Jul-21 500
    Aug-20 500 Aug-21 500
      6000   6000
    Account X   Y

    After a month, Oct-19, 12 months deferred revenue needs to get re-calculated, which means, 

    Oct-19  Deferred Revenue moves into Recognized Revenue

    Sep-20 Deferred Revenue moves from Account 'Y' into Account 'X' as Sep-20 in Oct-19 falls within the 12 month window.

    This should get repeated automatically every month.

    Can any of the member help to achieve this functionality in Oracle Fusion Receivables?

    Version:
    Fusion Receivables 19C
  • E
    Approval for Customer Bank Details Changes25.0
    Topic posted November 28, 2019 by EGreen Ribbon: 100+ Points, tagged Configuration, Financials, Receivables, Security, Setup / Administration in Core Financials > Receivables & Collections public
    Title:
    Approval for Customer Bank Details Changes
    Summary:
    Is there an approval flow for Customers
    Content:

    There is a request to have an Approval flow for Customer Bank Details changes (add/modify/set inactive). Is there any configuration similar to Approval of the Supplier Profile changes. Thank you in advance.

    Version:
    R13