The following are some of the principle design issues that need to be considered:
- Design the pages and reports to be used to display or interrogate the data.
- Define what keys are to be used or available to the users (though the SQL Server database supports sorting data without predefined Business Central AL keys).
- Define what fields will be allowed to be visible, what the totaling fields are, how the totaling will be accomplished (for example, FlowFields or on-the-fly processing), and what dynamic display options will be available.
- Define what type of filtering will be needed. Some filtering needs may be beyond the ability of the built-in filtering function and may require auxiliary code functions.
- Determine whether external data analysis tools will be needed and will therefore need to be interfaced.
- Design considerations at this stage often result in returning to the previous data structure definition stage to add additional data fields, keys...