Monarch Exercise 34 - Infor CloudSuite Distribution Order Entry Cash Drawer Analysis

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Classic & Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate
• Skills/Features Tested:  Standard Trap, Join, Analyze
  
• Systems of Record: Infor CloudSuite Distribution (formerly Sx.e, TREND)
  
• Estimated Time to Solve: 15 mins
• Exercise files required are attached Below;
  
  • Infor CSD - Order Entry Cash Drawer Balance Report Sample.txt
  • Warehouses.xlsx

Exercise Overview

You are a Sales Operations Analyst at a Manufacturing & Distribution Company and your Manager has asked you to answer the following questions based on data from the Order Entry Cash Drawer Balance Report in your Infor CloudSuite Distribution ERP systems:

1. Which Warehouse had the most sales (Amount Tendered)?
2. Which Customer has the largest amount Due?
3. Which Region had the most sales? (Hint: requires joining with the Excel File)

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.

Altair_CommunityBlog_Default-17.jpg

Infor CSD - Order Entry Cash Drawer Balance Report Sample.txt

Warehouses.xlsx