Posts

Posts

  • Krishna Thotapalli
    Import Daily exchange rates2
    Topic posted December 6, 2019 by Krishna Thotapalli, tagged Receivables in Core Financials > Financials – General public
    Title:
    Import Daily exchange rates
    Summary:
    Import Daily rates
    Content:

    How can we default daily rate instead of corporate rate for EUR to USD  while entering sales order?can we automate process to import daily rates from external system?

  • Sathya Kannan
    Assign pay group for customer refunds3
    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

  • Yash Rohra
    AutoInvoice import issue with OIC1
    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 ?

  • 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

     

     

     

     

     

  • Argishti Zakharyan
    Intercompany Invoices imported from FOS are coming with...5.0
    Topic posted November 28, 2019 by Argishti ZakharyanBlue Ribbon: 750+ Points, tagged Financials, Intercompany, Receivables in Core Financials > Receivables & Collections public
    Title:
    Intercompany Invoices imported from FOS are coming with trxdate
    Content:

    Gurus, 

    I need your help figuring out how to make that the intercompany invoices that are coming from the Supply Chain Financial Orchestration module don't inherit the trxdate.

    For example in the invoices that are from DOO (Distributed Order Orchestration), the trxdate in null and is taking the sysdate.

    In conclusion, I need a way to get the TRXDATE as NULL in the AR Interface. 

    Thanks for your help

  • 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
  • Aly Yassin
    How to change the revenue account imported from sales order...1
    Topic posted 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?

  • Stephen Stovell
    Post non standard Tax Rate on FBDI AR Invoice Upload
    Topic posted November 26, 2019 by Stephen Stovell, tagged Financials, Receivables, User Interface in Core Financials > Receivables & Collections public
    Title:
    Post non standard Tax Rate on FBDI AR Invoice Upload
    Content:

    We have a requirement to upload invoices with non standard VAT rate percentages, but against a single VAT Code. i.e. against STD 20% VAT code, but a variable rate like 16.6%.

    The only way to achieve this appears to be adding the tax line separately, rather than Fusion calculating the VAT from the tax classification. We'd prefer to enter the same line as the invoice line as its less complex, but the process fails. 

    Anyone had to deal with something similar?

  • Sigrid Buitelaar
    Sales credits as percentage of revenue15.0
    Topic posted November 26, 2019 by Sigrid BuitelaarGold Medal: 3,500+ Points, tagged Receivables in Core Financials > Receivables & Collections public
    Title:
    Sales credits as percentage of revenue
    Summary:
    Sales credits as percentage of revenue
    Content:

    Hi there

    Customer has a requirement to allocate a certain percentage of the revenue for certain customers to a salesperson. First of all I found this bug: Bug 25337539 : DEFAULT SALES CREDIT SALESPERSON BASED ON CUSTOMER SITE

    The bug status is 'suggestion implemented' however this does not seem to be available in our 19C instance. 

    Furthermore, this link mentions that the total % of revenue sales credits should be 100%: https://docs.oracle.com/en/cloud/saas/financials/18c/faofc/manage-customer-billing.html#FAOFC81347

    Is there any way to set aside only a percentage of the total revenue instead of allocating all to different sales person? Actually, customer is looking to generate an accrual based on all receivables invoices issued and reverse the accrual when the receivables invoices are paid. 

    Based on my research this does not seem possible out-of-the-box, however I can imagine other customers having the same requirement. Is there anyone who can advise for a workaround (apart from a custom report?)

    Thanks for your kind consideration!

    Sigrid