T210 Customized Forms and Master-Detail Relationship

Audience: This course is intended for application developers who are starting to learn how to customize Acumatica ERP.

Acumatica ERP Experience Required: 0-3 months

Who Should Attend (relationship to Acumatica): Developers of Acumatica ERP customizations.

Acumatica ERP version: 2019 R2

Training Description: The T210 Customized Forms and Master-Detail Relationship training webinar will describe how to customize existing Acumatica ERP forms and define the master-detail relationship. In this course, you will learn how to add custom controls and tabs to an existing Acumatica ERP form. You will also learn how to implement the UI logic, calculations, and insertion of a default detail record by using Acumatica Framework.

Training Syllabus: The program is covered over three days as follows:

• Day 1: Custom Fields. In this session, you will learn how to add a custom column to an Acumatica ERP database table, a custom field to an Acumatica ERP data access class, and the control for the custom field to the form.
• Day 2: Master-Detail Relationship and Business Logic. In this session, you will learn how to define the master-detail relationship between data and implement an automatic numbering of detail records. You will also learn how to restrict the possible values of a field by using the PXRestrictor attribute and mark localizable messages in code. You will update the fields of the same data record and of the other records on the update of a field. You will learn one of the possible ways to retrieve a data record from the database in code by using the static PXSelectorAttribute.Select<>() method
• Day 3: Custom Tab, Calculations, and Insertion of a Default Record. In this session, you will learn how to add a new data view to the business logic of an Acumatica ERP form. Also, you will learn how to use the Screen Editor to add a new container control to an Acumatica ERP form, how to use the PXFormula attribute for calculations, and how to add a default detail record to the grid.

Partner Certification: This class is based on the materials of the T210 Customized Forms and Master-Detail Relationship course, which is part of the Application Developer badge. Completion of this class does not give you an automatic completion of the related course at Partner University; you will still need to complete the exam at Partner University.

Date and time: This training meets the following three times, and attendees are expected to attend all three sessions:

• Mon, Aug 31, 2020 10:00 AM – 12:00 PM PT
• Tue, Sep 1, 2020 10:00 AM – 12:00 PM PT
• Wed, Sep 2, 2020 10:00 AM – 12:00 PM PT

Registration URL: https://webinar.ringcentral.com/webinar/register/WN_CPWmHY-FS06-uQxvCUvc_A

Instructor: Dmitry Naumov

In the role of Principal Software Engineer, Dhiren is working on developing Acumatica integrations with external systems.

With over 16 years of software engineering experience specializing in design, development, and deployment of Windows and web-based systems, Dhiren’s expertise encompasses everything from Technical Lead, Project Development, Architecture & Framework design, Component modeling and building, release management and developer support.

Prior experience includes developing .NET based rich internet application client working with JMS-based message-driven SOA design and one of the core developers at Everest Software INC focusing on ERP product development and later product customizations.

Prerequisites­

Required Knowledge and Background

To complete the course successfully, you should have the following required knowledge:

• Proficiency with C#, including but not limited to the following features of the language:
  • Class structure
  • OOP (inheritance, interfaces, and polymorphism)
  • Usage and creation of attributes
  • Generics
  • Delegates, anonymous methods, and lambda expression 
• Knowledge of the following main concepts of ASP.NET and web development:
  • Application states
  • The debugging of ASP.NET applications by using Visual Studio
  • The process of attaching to IIS by using Visual Studio debugging tools
  • Client- and server-side development
  • The structure of web forms 
• Experience with SQL Server, including doing the following:
  • Writing and debugging complex SQL queries (WHERE clauses, aggregates, and subqueries)
  • Understanding the database structure (primary keys, data types, and denormalization 
• The following experience with IIS:
• The configuration and deployment of ASP.NET websites
• The configuration and securing of IIS

Advance Preparations: Prepare the environment for the training course as follows:

• Make sure the environment that you are going to use for the training course conforms to the System Requirements.
• Make sure that the Web Server (IIS) features that are listed in Configuring Web Server (IIS) Features are turned on.
• Install the Acuminator extension for Visual Studio.
• Download the customization project and the source code of the extension library to a folder on your computer.
• Install Acumatica ERP 2019 R2. On the Main Software Configuration page of the installation program, select the Install Acumatica ERP and Install Debugger Tools check boxes.
• Download training guide and deploy Acumatica ERP instance with I100 company data. Instructions can be found on page 10 of the training guide.

Training Materials Please download the following training materials that you will use during the training:

• Training guide: T210 Customized Forms and Master-Detail Relationship 2019 R2.pdf
• Files for training: T210 Files For Training

Continuing Professional Education

• Program knowledge level: Basic
• Delivery method: Group Internet based program*
• NASBA field of study: Computer Software & Applications
• Maximum number of CPE credits that may be earned by the participant: 6

For more information regarding administrative policies—such as refunds, cancellations, and complaints—please contact Acumatica at 1-888-228-8300.

* We offer CPE credits for this course if you attend the course in the format of online instructor-led RingCentral session. During the session, we measure your attentiveness by using polling questions at random times. We provide the certificate if you have completed three polling questions per session. To get the certificate with confirmed CPE credits, after the session is complete, please send a request to training@acumatica.com.

National Registry Statement
Acumatica is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.