Exit 1Z0-1060-20 Oracle Accounting Hub Cloud 2020 Implementation Essentials
Question 1 of 5
0% complete
Q1 Single choice

'Insurances for Homes' company provide home insurance service. They have in-house built system that processes home insurance payments received from customers. The end result of the process consists of a listing of individual journal entries in a spreadsheet. They have requirements for getting all journal entries in a secure and auditable repository. Access will be limited to selective staff members. Additionally, be able to report and view the entries using an advanced reporting and analytical tools for slicing and dicing the Journal entries.

Which is a correct example for a formula to prorate amounts evenly across each period? Note that the NumberofGLPeriod is a predefined function that returns the number of non adjustment accounting periods between two dates.

  • A

    "Amount" *( NumberofGLPeriod ("Effective Date", "Last Day of Current Accounting Period") + 1)/
    (NumberofGLPeriod ("Effective Date", "Expiiy Date") + 1)

  • B

    "Amount" - ("Last Day of Current Accounting Period" - "Effective Date" ) / ("Expiry Date" -"Effective Date")

  • C

    "Amount" * ("Last Day ol Current Accounting Period" - "Effective Date" + 1) / (("Expiry Date" "Effective
    Date") + 1)

  • D

    "Amount" * NumberofGLPeriod ("Effective Date", "Last Day of Current Accounting Period") /
    NumberofGLPeriod ("Effective Date", 'Expiry Date")

Previous Next