Explanation:
Box 1: Table extension
Isolate all new vendor exclusion codes as a new assembly by creating a table named VendExclusions.
Implement the Excel integration for the Vendor Exclusion List form.
The table extension object allows you to add additional fields or to change some properties on a table provided by the Dynamics 365 Business Central service. In this way, you can add data to the same table and treat it as a single table.
Box 2: Unique key
Create an index for the table named PrimaryIdx that uses the following fields: CustAccount, ItemId, VendAccount.
Box 3: Build and synchronize the database.
A project property lets you specify that the synchronize operation for the database should be performed every time that you build the project. This can be useful when you're making changes to the table structure for an application. Each time that you build, you will know that the database is synchronized with the tables as they are defined in the project.
Reference:
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-table-ext-object
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-tools/build-operations#synchronizing- the-database-at-each-build Design and Develop AOT Elements Testlet 2 Case study 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 this 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. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
Overview
First Up Consultants provides Commercial Cleaning services to its clients. The company purchases all its cleaning supplies from Best For You Organics Company.
First Up Consultants is using a cloud-based Dynamics 365 Finance instance. The system has a foundation table named CashDisc that contains one cash discount record for each cash discount type.
Best For You Organics Company invoices First Up Consultants and allows cash discounts based on how fast an invoice is paid. First Up Consultants is entitled to a two percent discount from Best for You Organics for any invoice that is paid within 10 days and has a minimum invoice amount of $2,500.
Business requirements
All new and extended objects must be located in an existing model named FinanceExt. The creation of new models is not permitted.
Best For You Organics Company requires that First Up Consultants apply specific minimum invoice amounts to each cash discount record. A cash discount may only be applied when the minimum invoice amount requirement has been met. The new field must be added to the CashDisc form grid with the allowable visible number of characters set to 10.
First Up Consultants must retrieve the required Cash Discount methods and corresponding minimum invoice amounts directly from Best For You Organics Company's enterprise resource planning (ERP) system.
The Chief Financial Officer (CFO) requires the following reports:
* A report that shows all outstanding invoices, their cash discount types including the new minimum threshold applicable, and the amount of the discount. The report must only be accessed by users who are members of the Accounts Payable Manager role.
* You must create a Microsoft Excel workbook that lists unpaid invoices to Best For You Organics Company that have a due date earlier than 5/1/2019 and an Invoice Amount between $20,000 and $100,000.
Cash discounts for unpaid invoices must be updated with the new minimum invoice amounts.
Financial requirements
Vendor Invoices Past Due form
You must be able to filter the grid on the Vendor Invoices Past Due form. By default, you must filter the form based on the Due Date, Invoice Amount, and Vendor columns. Users must be able to apply reusable user- specific filters to a page using multiple fields.
CashDisc form
You must extend the CashDisc form to add a new field named MinimumInvoiceAmount to the form. You must add a new Extended Data Type to the extension model for the new field. The new field must be added above the discount method field. The field must display 10 characters.
The accounts payable manager and the accounts payable clerk have Delete access to the form. You must after permissions to limit accounts payable clerks to have only View access to the form.
Cash Discount Records report
You must create a report that shows a list of CashDisc records. You must include the MinimumInvoiceAmount field and filtered data by using the CashDisc.DiscMethod field. Applicable security objects must be created in the existing "FinanceExt" model and configured so the report is accessible by those users to the accounts payable role.
Batch jobs
You must create a batch job that runs on the last day of each month to update the current unpaid invoices with changes in the minimum invoice amount. The job must meet the following requirements:
* Accept the following parameters: Vendor, DueDate.
* Be callable by an Action menu item.
* Allow users to specify vendors to include in the job.
* Use SysOperation Framework for all batch jobs.
You must create a batch job to identify modified CashDisc.MinimumInvoiceAmount values and apply these to open Purchase Lines.
