Development reference model to build management reporter using dynamics great plain aggregated

ABSTRACT


INTRODUCTION
The transformation of digitization of technology has affected significant changes to business patterns.Digital technology transformation changes business patterns for companies to make strategic decisions quickly, precisely, and accurately to increase efficiency, be practical and achieve maximum company performance.The use of information technology in companies to business processes improve is a very valuable asset [1].This certainly requires management companies to make breakthroughs to enhance work efficiency and competitive advantage.The enterprise resource planning (ERP) system use is an essential thing that the management company must consider to achieve agility in making decisions quickly and precisely.But in fact, the companies still need to work on adjusting the ERP business processes, resulting in the investment value of procurement of an ERP system being expensive and having a high potential risk of failure [2].Organizational support in maintaining performance and ensuring continuity ERP usage becomes very important [3].Besides that, needed to evaluate of user experience of the ERP system to determine user impressions the performance for business needs [4].ERP systems can give contribute to making decision and determine the strategy business and organization performance [5].In actually, most companies still maintain the old way of working before using the ERP system, thus demanding that the ERP system follow the old way of working.Besides that, it is difficult for users to follow the business processes of a standardized ERP system.The organizational dimensions can develop a business strategy based on empirical evidence to address ERP implementation problems [6].The structured analysis and design is one approach to solving business activity problems in ERP system implementation [7].This needs to be provided so that there is no need to make adjustments to modify business processes from the ERP system.It should be noted that adjusting the business processes of the ERP system will result in the way the ERP system works becoming unstable and having a high risk of failure in implementing the ERP system.Top management's decision to select the ERP system used must consider the synchronization and alignment of the company's strategy that focuses on business needs and the capabilities of the ERP system.Technical understanding related to the ERP business processes it will be easier to make adjustments to current business processes.If the current business process matches the standard ERP business processes, the company's project management must adapt to the ERP business processes.
The reference business process model shows that the comparing and finding differences in decision of management based on business requirements and ERP system capacity.This becomes the basis for deciding on the selection of alternatives for adapting of an ERP system, adapting of business processes, and combinating ERP with other solutions [8].The reference business process model can be seen in Figure 1.

Adaptation of Business Processes
Combinating ERP with other solutions

Figure 1. Reference business process model
Customize current business processes by following the ERP business processes.This requires a reference model for mapping current business processes to adopt the ERP business processes [9].The ERP business process adapts to the current business process.If the current business process has a different ERP system business processes used, then this requires significant to customize the ERP business process.This can cause the ERP system to become unstable and have a potential risk of failure in implementing ERP.Combine the ERP system business processes used and carry out business process engineering to adapt to the business processes of the ERP system as a business process reference model according to the needs of company management.An effective business strategy to determine the company's whereabout is to integrate the company's internal analysis to identify the company's strengths and weaknesses [10].Business process reengineering is one of the critical factors for ERP implementation success according to the needs of top management to enhance work effectively and efficiently [11].The business processes change that affect ERP implementation, so it is necessary to provide the ability to adapt and agility to support the evolution of the organizational environment [12].For this reason, it is necessary to standardize ERP business processes, provide guides for users in carrying out the ERP business processes, and provide training materials for users, which can also be coordinated by an ERP consultant to assist users in running the ERP system used.Based on these choices becomes the basis for consideration for company management in selecting an ERP system, namely mapping according to the characteristics of the company's current business processes by designing an existing business process reference model.Most of the ERP implementation results in companies have yet to significantly affect the running process.The use of an ERP system will impact business process changes, such as reducing waiting time in completing work, helping managerial levels share information for strategic  [13].For this reason, it needs to consider the challenges in implementing ERP and ensure the results of ERP implementation can be successful.The challenges in implementing ERP systems are how to get the various benefits of using an ERP system realistically, considering the following factors [14].Technology selection is an essential consideration of enterprise management decisions to invest in project management such as ERP.In addition, the company's management support affects the performance of the ERP system by making changes to running business processes to follow the business processes of the ERP system used.Change management is changing business processes, people, and technology and is fundamental to management decisions to carry out change management processes to achieve success in implementing ERP.The management of knowledge management evidences knowledge management improved company performance.Managing knowledge as a means of sharing ability can increase flexibility and innovation in ERP use.Emerging technology is used to enhance processes, legitimize, and accelerate the speed of the process in making decisions that are precise, accurate, and up to date with the availability of information needed by managerial levels in decision-making strategies.
The use ERP application of the dynamics great plain (GP) is one of the ERP applications that can be made easy with a user guide so that it helps users understand business processes more efficiently.In the ERP application of the dynamics GP there is a facility for developing reports known as the management reporter (MR).MR is an analytical tool that corporate users can use to find various information related to business performance in several areas of business units and companies for strategic decision-making, monitoring business growth based on real-time indicators, and as business automation software [15].This MR can produce various dynamic financial information and has a professional format.MR can make flexible arrangements to design financial information in report layout settings, columns, and rows.MR can present drafts of various financial information that can group and/or consolidate several accounts in financial statements by reducing financial information from several business units and companies.MR can also take one format and create separate financial information for each division, department, or profit center.Besides that, MR can generate real-time reports based on transactions that have been input into the Microsoft Dynamics GP application, which is an advantage of using MR for users.MR can perform the function of arithmetic formulas in presenting various advanced reports to help strategic decision-making.MR has an attractive appearance with logos and subtitles of different designs.MR can collaborate with colleagues, auditors, and other parties to create, distribute, and present various financial information.MR can produce interactive reports to assist decision-making from real-time financial information.MR can integrate interoperability and track data with the Microsoft Dynamics ERP application.MR can present various reports relatively quickly and the layout of reports can be converted into external files as support in Microsoft Office spreadsheet formats excel or pdf.MR can help make decisions rapidly and accurately for company management in determining the company's strategic business direction in the future, with the following points: MR can group information into groups to automate and combine reports from several business units of the company.MR can group reports into groups to automate and consolidate reports from several company business units.MR can schedule the presentation information on a daily, weekly, or monthly basis automatically and flexibly.MR can produce various reports based on the order of the withdrawal process in presenting financial information so that MR can assist users in conducting strategic analysis and decisionmaking.

METHOD
This research uses a descriptive qualitative approach and the method of developing the system development life circle with a workflow model.Descriptive in question is a problem-solving procedure that is investigated by describing the state of the research object based on reality to accurately produce a systematic description of the object of research [16], [17].In addition, this research adopts the systematic literature review prisma to survey previous literature as a theoretical basis [18], [19].The workflow model is based on guidelines from the sales reference business process model from the dynamics great plain (GP) application [20]- [22].One of the important factors in a company that will implement an ERP system is assessing the ERP vendor by considering budget, time, and resources.Microsoft Dynamics is an ERP vendor that needs to be considered in implementing an ERP system using the right methodology according to the company's business characteristics.Choosing an ERP methodology is important to determine successful ERP system implementation [23]- [25].Based on the figure workflow of sales reference business process shows that business processes are more effective and paperless and reduce the repetition of business processes between departments.Even business process collaboration occurs so managerial levels can monitor order status and outstanding accounts receivable (AR) in real-time.The workflow of the sales reference business process started after admin sales created sales order (SO), so the production department prepared production Comput Sci Inf Technol ISSN: 2722-3221  Development reference model to build management reporter using dynamics … (Santo Fernandi Wijaya)

243
planning and checked the material available.If material is available, so the production planning makes a work order.After the production department creates goods issues and the warehouse makes delivery order (DO) to send to the customer.After the customer receipt goods, so admin warehouse posts DO, and admin finance creates an invoice for account receivable collection from the customer.Based on the sales setup reference business process model of Microsoft Dynamics GP, it shows that the activity in general setup makes a customer master and complete all customer information needs.The action in customer management is managing customers with the payment feature and credit limits.The activity in posting setup is setting up ledger accounts that will be formed automatically in every transaction using the customer.This description can be explained in the hierarchical workflow of the sales reference business process can be seen in Figure 2.

Figure 2. Workflow of sales reference business process
Based on figure of sales references business process model of Microsoft Dynamics GP which shows that the action in blanket order is a feature in making bookings done by marketing in projecting sales based on booking orders.The activity in sales quote is an offer made by marketing to customers in carrying out the product sales process.The activity in SO is creating a SO based on the final sales quote that has been agreed upon by the customer.The activity in the DO is to schedule the delivery of goods and delivery of goods based on SOs.The activity in an invoice posting is to create sales transactions for goods sent to customers.The activity in AR aging is an activity to monitor customer bills.The activity of the sales reference business process model of Microsoft Dynamics GP is described in Figure 3.

RESULTS AND DISCUSSION
In this section, this part of the research explains the results of input transactions from the Microsoft Dynamics GP application.The Microsoft Dynamics GP application can crosscheck all transactions that have been input through the smart-list facility.This research will explain one of the essential reports every company needs, the cash flow report.Based on this cash flow report, the company's management can make strategic decisions related to the company's financial policy, and also from this cash flow report, can find out the company's financial health, which can be known in real-time, up-to-date, and informative related to the sales business process on the cash flow report is the receipt from the customer.Based on the Microsoft Dynamics GP application, you can trace transactions that have been inputted into the GP application, so you can check transaction journals in an up-to-date and real-time manner.Based on the journal inquiry report from the Microsoft Dynamic GP application, which will become a data source to create the financial information using MR.The smart-list data is operational transaction data consisting of accounts needed by MRs.Withdrawals, the smart list allows users to browse journals on accounts, making it easier to make corrections if errors occur before carrying out the reporting process to MR.The smart-list Microsoft dynamic GP application that described in Figure 4.
In Figure 5, it is a display of the MR, it can be said that the show is user-friendly and makes it easy for the users to design various reports, including financial information that can assist management levels in making strategic decisions that are useful for increasing competitive advantage for the company.Besides that, reports generated from the MR can be in digital form, which can be presented in the form of a screen on the computer screen, so that it is paperless, and this will increase the effective and efficient way of working for users who use the MR.The MR provides a standard layout of financial reports that are used.MR creates custom reporting layouts by creating custom rows and columns.The MR described in Figure 5.This is a sampling for withdrawing data based on bank transactions.When creating a row modifier, selecting an attribute distribution reference as a filter for data be retrieved from the Microsoft Dynamics GP application is necessary.This proves the data integration from the Microsoft Dynamics GP application with the MR.MR row definition is described in Figure 6.
Based on the previous explanation, continuing to prove the integration of data from the Microsoft Dynamics GP application with the MR, the formula for getting the beginning balance from the general ledger is done in a way lookup row modifier account modifier: /BB begbal (beginning balance).The procedure of the beginning balance is described in Figure 7.After doing the row definition, it is necessary to determine the column definition so that it can present the financial report as needed.The column definition can specify the required report period, for example, periodic reports on a weekly, monthly, quarter, semester, and annual basis.After defining the rows and defining the columns in the Microsoft Dynamic GP application, it is necessary to make choices about the report to be presented such as displaying negative numbers, displaying digit separators, displaying currency symbols on the first line, displaying blanks for zero amounts, displaying rows without amounts, displaying report without an active row, show report in grid view.
The users can tick each option to present information as needed.Based on the previous explanation, the user can then click the notification button to present information as needed.Based on this information, management can make further decisions.The management acquisition report is described in Table 1.

CONCLUSION
Based on the result and discussion of this research, this research shows that the business process reference model is one of the critical factors for business process engineering to adopt the ERP business processes.Understanding the business process reference model comprehensively can help users adjust the current business process model so that the ERP use becomes more effective and reduces the failure rate in implementing the ERP system.Besides that, it is necessary to pay attention to the managerial level of readiness of the company in making changes to the way it works by following the workings of the selected ERP system.Management support for change management is urgently needed.This matter considers the company's readiness level to make change management, so the company should follow the business processes of the selected ERP.This will reduce the failure rate in implementing ERP.Based on the dynamics GP sales business process reference model, the users can adjust their current business processes by adopting the business process model from the dynamics GP ERP application.Using MRs to present various information can increase effectiveness and assist users in producing multiple reports needed for strategic decision-making in a fast, precise, and informative manner.In addition, reporter management can be flexible in changing the layout of information required by company management, which can ultimately help company management make decisions to improve company performance further.Due to the limitations in this Comput Sci Inf Technol ISSN: 2722-3221  Development reference model to build management reporter using dynamics … (Santo Fernandi Wijaya) 247 research, these researchers can continue this research by developing business process reference models in other modules to assist users in finding the overall business process reference model for all modules of the ERP system.Besides that, this research can be continued by developing an online platform application of the ERP business process reference that users can use to assess the company's readiness to adopt business processes from the ERP system used.From a computer science perspective, this research can be continued by developing an integration of business process reference models from ERP systems with comparisons of ERP applications which are the object of further research.

Figure 3 .
Figure 3.Sales reference business process model