Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Need clarification on customer Business Rule (allocation rent expenses ) is not executed — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need clarification on customer Business Rule (allocation rent expenses ) is not executed

Received Response
19
Views
2
Comments
edited Aug 13, 2021 8:20AM in Financial Consolidation and Close 2 comments

Content

customer has created a business rule to allocate rent expenses across departments based on the square feet. An example is attached for your reference and the rule is written as follows,

Example:

Rent 420,000 need to be allocated based on the square feet of departments.

Allocation amounts

Loan department Sq ft 100 20,000 (420,000*100/2100)

Deposit department Sq ft 200 40,000

Pawning 60,000 sq ft 300 60,000

front office 80,000 sq ft 400 80,000

Admin 100,000 sq ft 500 100,000

Marketing 120,000 sq ft 600 120,000



/* Start Template:Allocation*/
FIX ("Jan", "BaseData", "FY22", "Current", "BU Version_1", "LKR", "Borella", "No Product")
FIX (@RELATIVE("Department All", 0))
SET CREATENONMISSINGBLK ON;
"Rent" = @ALLOCATE(("Rent"->"No Department" * (100 / 100)), @remove(@Relative(&quot

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!