Monarch Learning Series 2023 Exercise 13 - MEDITECH Detail Trial Balance vs AP Transactions

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited September 2023 in Altair RapidMiner

Exercise Info

  • Application (Classic vs Data Prep Studio): Classic & Data Prep Studio
  • Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
  • Skills/Features Tested: Detail, Append, & Group Footer Templates, Join (Lookup Join)
  • Systems of Record: MEDITECH Expanse
  • Estimated Time to Solve: 15 mins
  • Exercise files required are attached in the Zip File Below;
    • Meditech Expanse Detail Trial Balance Sample.txt
    • Meditech AP Transactions for SQL.csv

Exercise Overview

You are an Accountant at a Critical Access Hospital and the Controller has asked you to compare Accounts Payable activity between the GL and the Data Repository to identify and differences between them.

Classic

Create a Monarch Classic Model to Capture just the Vendor Debits and Credits activity within the Meditech Expanse Detail Trial Balance Sample.txt Report to answer these questions;

  1. Create a calculated field for Net Amount (Debit - Credit), What is the total Net Amount?
  2. Create a summary to identify the Top 1 Vendor had the largest Debit Amount. Who is that vendor?

Data Prep Studio

Create a Monarch Data Prep Studio Workspace that Joins (Lookup Join) the Meditech Expanse Detail Trial Balance Sample.txt to the Meditech AP Transactions for SQL.csv, to answer the following question;

  1. Which Vendors are on the Detail Trial Balance, that are not in the AP Transactions SQL table?

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