Altair Monarch Exercise 6 - Classic Journal Entry

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited May 28 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Data Prep Studio
  • Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
  • Skills/Features Tested: Report Trapping, Group By, Join, Append, Formula Fields
  • Systems of Record: Not Applicable
  • Estimated Time to Solve: 15 mins
  • Exercise files required are attached
    • Classic.txt
    • Classic GL Lookup.xlsx

Exercise Overview

You are an Accountant and you need to create a Journal Entry/Journal Voucher to post detail entries to several General Ledgers for detail activity on the 'Classic' report. You have to post the detail transactions to the General Ledgers in the "Classic GL Lookup.xlsx", based on Debits and Credits, for the various Media types (CD, BLU, DVD, LP). Your Controller has asked you to use the Altair Monarch Data Prep Studio to create a workspace that will streamline the creation of the Journal Entry. Below is a screenshot of the "Classic GL Lookup.xlsx", that has the General Ledgers you need to map the values to.

Hints:

  • Create a Constant Value Column for Debit.
  • Duplicate and Create a Constant Value Credit.
  • Ensure that the Values for Credit and Debit are Opposites (+/-).
  • Leverage Append the Tables, and Combine it with the GL Lookup.

Answer

  • Please upload your answers below in the comment section for the exercise
  • A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.
Tagged:

Categories