Current environment
Fabrikam Inc. is a medium-sized company that plans to implement Dynamics 365 Business Central as an ERP system. The company has a development department that will help with the ERP implementation.
Most employees work remotely from different countries or regions and speak different languages. The various locations and languages cause issues with the current on-premises software.
Planned improvements
Fabrikam Inc. plans to implement new and modern software to manage the company. The company wants to use Business Central because it is cloud-based and meets all company requirements.
The company intends to improve reporting and integration functionality by using modern tools such as Power BI and APIs. To reduce the amount of information sent by email, the company plans to expose vendor information to be consumed from external users.
Technical specifications
The development department installed Visual Studio Code to create Business Central extensions so the ERP system could be customized according to company needs. All extensions must be developed for the Business Central 2024 wave 1 online version.
The development department plans to use telemetry to control the appropriate use of each new development and works directly in licensed sandbox environments supplied by Microsoft.
Department-specific requirements
The following departments at Fabrikam Inc. have multiple requirements:
1. Development
2. Control
3. Accounting
4. Quality
Development department
The development department designed an extension for the purchase department. Because the developers plan to work with telemetry for monitoring operations, they need the Application Insights information. To accomplish this, the department must add a setting in the corresponding file.
The quality department does not want to receive any warning about the Application Insights setting when the extension is compiled.
Control department
The control department requires customizations to Business Central by using a per-tenant extension (PTE) named Subcontract Docs. The PTE includes a table named Subcontract Documents. The table has the following fields:
ID: A unique identifier
Subcontract No.: Related to the standard Vendors table Description: A short description of a received document Document: A media type that has the document Comments: Comments about the document Date: When the document was imported Amount: Amount related with the imported document Posted: Indicates if the document is managed
The extension must be in English - United States (ENU) and Spanish Traditional Sort (ESP) so the application can be used in both languages. The translations must be on the table, not on the page, to avoid repeating them. The control department does not want to use translation files.
The control department manager requires a brief guide for the Description and Comments fields when employees create a new record so users know what to include in the fields. The guide must disappear as soon as users add a value in the fields.
The Subcontract Documents table must be displayed on a new page named Subcontract Document List through an action from the standard Vendor page.
The Amount field, included in the Subcontract Document List, must be formatted in bold format when the record is posted (field Posted = true).
The control department also requires a report to display a list of subcontract documents named Subcontract Documents Excel List. The report must meet the following requirements:
1. Downloads a file only in Microsoft Excel.
2. Includes a predefined format with two worksheets: one with the posted subcontract documents and another with the unposted subcontract documents.
Accounting department
The accounting department plans to use Power BI to analyze information generated by the control department. The accounting department plans to expose an API named API Customer Lines. To improve the performance, the API must use read-only information and work with a Query object to summarize the data.
You have the following code:
The accounting department must expose data such as the following:
The qty column must be the sum of the Outstanding quantity field of Sales Order Lines. It must be in descending order by quantity.
The department also exposes a page named Fabrikam Vendor API that includes vendor information from the Vendor table, such as number and name. The API must use the replica database to improve performance.
Because Fabrikam Inc. is based in multiple countries and regions, the company periodically must send accounting movements between two dates to the local tax offices named Fabrikam Accounting.
The format for this file must be an XML file generated by an XMLport object. For security reasons, it is not possible to receive data from this XMLport.
The generated XML file must have a schema like this:
Quality department
The quality department requires that every new app or extension is designed to meet standard company guidelines. The quality department plans to follow the standard Business Central data model. The quality development must be able to use triggers correctly.
The department must ensure that when a vendor is deleted, the system also removes each record in the Subcontract Documents table related to the vendor. If the subcontract document record has the field Posted = false, it must not be possible to delete the record.
The department has a version 1.0.0.1 installed for an extension named Quality Control. The department develops a new version 1.0.0.2 and uses a codeunit with the subtype Upgrade to update it. The department requires the values for AppVersion and DataVersion on the trigger OnUpgradePerCompany
after using NavApp.GetCurrentModuleInfo(myinfo).