Useful Microsoft MB-800 Exam Updated Material

1. notifications, if any, that customer service needs to provide to the customer

- Items sold at a discount must show the original price, discount, and net amount on each line of the invoice. Invoices must be posted at the cash and carry desk at the time of sale. For orders, accounting must post invoices and send them to customers.

- Warehouse employees must be able to indicate what has been shipped on an order. They will use the G/L account for shipping charges. They need to use the correct G/L account for sales versus cost through proper assignment of sales and purchase accounts in the general posting setup.

- Some of the brokered customers require one invoice per week regardless of the number of orders or shipments.



Accounts

- Payment terms vary by customer.

- The amount paid to brokers must be calculated from sales after invoice discounts.

- Broker vendors must be easily identifiable from other vendors in lists

- Commission paid on sales not collected within 120 days must be deducted from brokers’ next compensation payment.



Reporting

Wide World Importers requires reporting on the following:

- the overall profitability of each line of business at any time for any given period

- the cost of outbound shipping in the overall profitability of sales by business line in all related reports

- freight sales and cost by account in the trial balance

- the cost of brokers’ compensation in reporting the overall profitability of sales by business line

- the effect of item discount promotions in financial statements.



Issues

Pricing

- Spreadsheets are used to maintain special item pricing and discounts. The only source of product line discount information is a whiteboard in the warehouse. The price charged is frequently incorrect.

- Customers complain when they think they think they have not received the best price available. Promotions are sometimes applied in error after a special pricing event ends, for example, when discounts are offered temporarily to reduce overstock.



Management cannot see original versus actual price on all sales. Discounts given by brokers requires spreadsheets and comparison between price list and price on sales invoice. Management needs to be able to quickly see the discount given on each sale.



Payment terms

- Agreed-upon payment terms are frequently entered incorrectly on orders, causing cashflow issues.

- Invoices already paid in full exist on the sales aging reports. The frequent cause of this issue is that sales from the cash and carry desk are not indicated as cash sales and are not posted as paid in full.

Some buying groups require that all invoices sent during a month be due on the 20 th of the following month.



Invoicing

- Paperwork is frequently misplaced between the warehouse, customer service, and accounting.

- Invoices that are posted in the accounting system based on shipments and invoices that are sent to customers weekly do not match due to errors transferring the data from one document to another.

- Users are selecting the incorrect freight type (expense versus sales) on purchase and sales transactions, making it difficult to reconcile freight costs.

- Sales placed from the cash and carry desk by customers originally acquired through a broker are not being recognized with the correct customer source. Reporting by business line is inaccurate.



Accounts

- Users often forget which fields to use to enter information when they add new customers to QuickBooks. This results in errors and inconsistencies in data and affects sales reporting. Confidence in sales reporting accuracy is low.

- Adding new brokers is a different process than adding other purchase vendors. Users often forget which fields to select and how to correctly assign the vendor number to add new brokers.

- Manual entries to certain G/L accounts cause reconciliation issues.



You need to set up payment terms for buying groups.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

2. DRAG DROP

You need to configure discounting for sales.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area.

3. You need to configure sales for the cash and carry desk.

What should you select?

4. DRAG DROP

You need to design a process to resolve the broker issues for Accounts.

Which three actions should perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

5. HOTSPOT

You need to report profitability by business line.

How should you configure the system? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

6. HOTSPOT

You need to configure the system to show the sales discounts.

How should you configure the system? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

7. A customer in the restaurant buying group purchases olive oil on the date of the overstock special.

You need to verify the sales price of the product for the customer.

Which price will the system generate?

8. You need to configure sales invoicing.

What are two possible ways to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

9. HOTSPOT

You need to resolve the reconciliation issues.

How should you complete the setup? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

10. You need to configure the new customer creation process.

Which two areas must you configure? Each correct answer presents part of the solution . NOTE: Each correct selection is worth one point.

11. DRAG DROP

You need to ensure that any transaction that uses a customer account always includes the customer source dimension.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

12. Topic 2, Case Study B Deliveries



This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case . However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.



To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.



At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.



To start the case study

To display the first question in the case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.



Current environment

Deliveries

- The company receives daily truckloads of products from their vendors, warehouses the products briefly, and then ships orders based on a weekly delivery cycle to each customer’s store.

- Customers have regular standing orders that are revised and finished one week prior to delivery.

- Best for You Organics has a fleet of trucks that make deliveries according to planned routes.

- The company also has a floating route for trucks to deliver rush orders. The route is being used more often by customers and has overwhelmed the warehouse with exception processing.



Duties

The company wants to provide greater separation of duties between activities in the office and activities in the warehouse.



The accounting team enters orders for the sales team, sends pick tickers back to the warehouse, and organizes shipping documents. The accounting team invoices the orders when they receive instructions from the warehouse that an order shipped.



Employees have expressed frustration because they need to work longer hours to accommodate the increase in sales.

The company does not use the Advanced Warehousing function.



Requirements

Salespeople

- Salespeople must be able to manage opportunities that are converted to quotes.

- Salespeople must be able to release orders to the warehouse to be fulfilled once a quote is final.

- Salespeople must be trained on how to determine if inventory is available when they are completing the quote to avoid promising inventory that is not on hand because all orders are processed one week in advance of delivery.



Team responsibilities

Deliveries must be shipped daily by employees in the warehouse. The office must be responsible for completing the invoicing process.



The current team responsibilities are shown in the following graphic:







The required team responsibilities are shown in the following graphic:







Vendor management

- The company contracts with each vendor for regular discounts at the invoice level.

- The company requires a pre-set discount percentage to calculate automatically when the purchaser completes a purchase order.

- The company must be able to see a copy of the completed purchase order in the system when they have new contract negotiations with their vendors.



Customer and inventory management

- Sales invoices must be automatically emailed by the system to customers.

- A template must be used for emails sent to customers. The template must not be altered.

- Customers who pre-pay their invoices must not receive a copy of their invoices.

- The company warehouses all products as Case quantities. The company has difficulty recording accurate costs for product returns. The company wants to expand their capabilities for managing returns by setting up all inventory in a quantity of Each.



Reporting

The company must be able to answer two key questions when they report financial results:

- Which customers are buying which items?

- Which salespeople are selling in which regions?



When discussing customers, the company must refer to each Customer Group as follows:

- Big Box

- Franchise

- Private



When discussing items, the company must refer to each Item Group as follows:

- Fair Trade

- Free Range

- Grass Fed

- Heirloom

- Organic



Salesperson names that must be used are:

- SalespersonA

- SalespersonB

- SalespersonC

- SalespersonD



Region names that must be used are:

- North

- South

- East

- West



Commission

- The company must be able to track salesperson performance within certain regions to calculate commission.

- Each salesperson must be assigned only to a single region.

- This commission data is currently recorded inconsistently, resulting in incorrect combinations that require manual correction. The company must have some level of automation to manage this.



Issues

Issue 1

The accounting team needs an improved process for reconciling inventory to the general ledger.

- Posted transactions are changing financial reporting in periods that have been closed.

- Unexpected changes in inventory cost for previous months are causing costing inaccuracies.

- The system must restrict the adjustment of costs for closed months.

- The new policy will be to restrict all users to posting in the current month only, with the exception of a few employees from the accounting team.

- The calendar fiscal year for company must begin on June 1.



Issue 2

The accounting team uses a complex manual accrual process to determine the accounting impact of items received but not invoiced. The system must streamline the item accrual process.



Issue 3

The company often receives a higher quantity of produce items than what they order because vendors allow for spoilage or damage of produce in transit. The company does not want to allow over receipt on non-produce items.



Issue 4

The company has received comments from their auditors that invoices are not being properly compared to received inventory documents before they are posted. The company does not use warehouse management and always handles processes directly from the purchase order.

The company always has the following documents:

- purchase order from the procurement department

- receiving document from the warehouse

- electronic invoice from the vendor



HOTSPOT

You need to configure reporting.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

13. You need to set up units of measure for an item to meet the requirements.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

14. You need to configure the system for receiving produce from the vendors.

What should you do?

15. DRAG DROP

You need to configure the system to address the costing adjustment concerns.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

16. HOTSPOT

You need to set up a new fiscal year and restrict posting.

Which options should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

17. DRAG DROP

You need to configure the purchase order process to meet the auditor’s requirements.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

18. HOTSPOT

You need to create the process for salespeople.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

19. You need to configure the system to meet the requirements for received items .

What should you do?

20. HOTSPOT

You need to configure purchase order discounting and history.

What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

21. You need to configure the system to meet the requirements for sending invoices.

Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

22. You need to enforce restrictions for salespeople and regions to meet the requirements for Commission.

What should you do?

23. DRAG DROP

You need to advise the company on how to process existing sales orders.

Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

24. Topic 3, Misc. Questions



DRAG DROP

A company implements Dynamics 365 Business Central.

The database contains very few posted entries. You observe that Global Dimension 1 is configured incorrectly. You need to run the Change Global Dimensions function in Sequential mode to replace Global Dimension 1.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

25. You are implementing Dynamics 365 Business Central.

You use infinite items such as water, electricity, and natural gas.

You need to set up the items.

Which item type should you use for infinite items?

26. DRAG DROP

You are setting up a new item in Dynamics 365 Business Central. The item is a tangible good with an inventory asset value. The item is acquired by purchase specifically for each new instance of demand from an order.

You need to configure the Type, Replenishment System, and Reordering Policy fields on the item card to achieve the stated requirements.

How should you configure each field? To answer, drag the appropriate values to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

27. The general ledger account for accounts receivable must match the sum of all balances on the customer cards.

You need to set up the general ledger account card for accounts receivable to meet this requirement.

Which configuration should you use?

28. DRAG DROP

You need to configure security for Dynamics 365 Business Central objects.

Which permission or set of permissions is allowed for each type of object? To answer, drag the appropriate permissions to the correct object types. Each permission set may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

29. HOTSPOT

You are implementing Dynamics 365 Business Central.

The accounting manager wants to set up a complete Purchase Document Approval system with an approval hierarchy that meets the following requirements:

✑ Sara processes all purchase orders. Any purchase orders that Sara processes must be approved.

✑ Michelle can approve purchase orders up to $10,000.

✑ Shawn can approve the orders up to $50,000.

✑ Purchase orders above $50,000 must be approved by Remy. You need to create the hierarchy.

Which hierarchy setup should be used for each limit? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

30. DRAG DROP

You are a functional consultant working on purchase returns in Dynamics 365 Business Central.

A customer orders 100 pieces of an item from a vendor. After receiving them into inventory and posting the invoice, the customer determines that only 50 pieces are needed.

You create a purchase return order to return 50 pieces of the item. The vendor has authorized the return.

You need to apply the return to the original purchase.

Which five actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

31. DRAG DROP

A company uses Dynamics 365 Business Central.

The company’s funds are limited and some invoices that are due cannot be paid on time.

You need to prioritize vendors when you suggest vendor payments.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

32. A company uses Dynamics 365 Business Central.

You must create a general ledger account and define the general ledger account as a purchase account for general journal transactions.

You need to configure the system.

33. A company plans to verify that purchase invoices use agreed-upon prices and discounts.

The company is configuring settings on a vendor card. The company receives a validation error when creating a purchase order for the vendor.

You need to find out which setting is causing the validation error.

Which configuration option on the vendor card must you populate?

34. DRAG DROP

You are implementing Dynamics 365 Business Central for a company.

The company must perform inventory valuation according to the following business rules:

✑ Use the first in, first out (FIFO) costing method for all items.

✑ Include received items that are not yet invoiced on balance sheets.

✑ Lock inventory value by closing the month.

You need to recommend a process for the company’s accounting department to use.

Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

35. Monetary amounts for local currency must always display three decimal places.

In General Ledger Setup, you need to configure the appropriate setup field with the appropriate value.

What should you do?

36. A user reports that they cannot create or view sales quotes in Dynamics 365 Business Central.

You need to help the user create and view sales quotes.

From which three cards can the user perform the required activities? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

37. A company uses Dynamics 365 Business Central.

A customer wants to sell items that are not normally counted in the company's warehouse.

You need to configure the system to meet this requirement.

What should you set up?

38. DRAG DROP

A company is implementing Dynamics 365 Business Central.

You need to create a new company that is configured similarly to an existing company. The existing company has data that must be used as a template for the new company.

Which tools should you use? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

39. HOTSPOT

A furniture manufacturing company is creating new items in Dynamics 365 Business Central. The company currently searches for the products by material, color, and size.

You must expand the search capabilities for the items. Not all the items will have the same searchable characteristics. Some new search characteristics may need to be added.

You need to configure the system to automatically recommend additional search criteria for items.

Which features should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.