{
    "id": 4460,
    "date": "2023-09-06T15:48:08",
    "date_gmt": "2023-09-06T15:48:08",
    "guid": {
        "rendered": "http:\/\/100.28.163.57\/?p=4460"
    },
    "modified": "2023-10-18T14:08:05",
    "modified_gmt": "2023-10-18T14:08:05",
    "slug": "adding-usr-prefix-to-the-existing-users-fields-in-acumatica",
    "status": "publish",
    "type": "post",
    "link": "https:\/\/sprinterra.com.ua\/en\/adding-usr-prefix-to-the-existing-users-fields-in-acumatica\/",
    "title": {
        "rendered": "Adding Usr prefix to the existing users\u2019 fields in Acumatica ERP"
    },
    "content": {
        "rendered": "<div data-elementor-type=\"wp-post\" data-elementor-id=\"4460\" class=\"elementor elementor-4460\" data-elementor-post-type=\"post\">\n\t\t\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-41677c0e e-flex e-con-boxed e-con e-parent\" data-id=\"41677c0e\" data-element_type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-13c16917 elementor-widget elementor-widget-theme-post-title elementor-page-title elementor-widget-heading\" data-id=\"13c16917\" data-element_type=\"widget\" data-widget_type=\"theme-post-title.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h1 class=\"elementor-heading-title elementor-size-default\">Adding Usr prefix to the existing users\u2019 fields in Acumatica ERP<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4bb2498e elementor-align-center elementor-widget elementor-widget-post-info\" data-id=\"4bb2498e\" data-element_type=\"widget\" data-widget_type=\"post-info.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"elementor-inline-items elementor-icon-list-items elementor-post-info\">\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-7693618 elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-user\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-custom\">\n\t\t\t\t\t\t\t\t\t\tYuriy Muzychyn\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-663091d elementor-inline-item\" itemprop=\"datePublished\">\n\t\t\t\t\t\t<a href=\"https:\/\/sprinterra.com.ua\/en\/2023\/09\/06\/\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-calendar\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-date\">\n\t\t\t\t\t\t\t\t\t\t<time>September 6, 2023<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/li>\n\t\t\t\t<li class=\"elementor-icon-list-item elementor-repeater-item-db2e804 elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-clock\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text elementor-post-info__item elementor-post-info__item--type-time\">\n\t\t\t\t\t\t\t\t\t\t<time>3:48 pm<\/time>\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t<\/ul>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-b1e409e e-flex e-con-boxed e-con e-parent\" data-id=\"b1e409e\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a664ffc elementor-widget elementor-widget-text-editor\" data-id=\"a664ffc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><em>We are starting a new series for <a href=\"https:\/\/www.acumatica.com\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ERP Acumatica<\/a> developers. This article is perfect starting point for beginners, demystifying the fundamentals of Acumatica customization.\u00a0 \u00a0<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a4766c news-h3 elementor-widget elementor-widget-heading\" data-id=\"8a4766c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Creating Custom Fields<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ddae363 elementor-widget elementor-widget-text-editor\" data-id=\"ddae363\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A standout feature of <a href=\"https:\/\/www.acumatica.com\/\">Acumatica ERP<\/a> is the ability to create personalized fields, enhancing the system&#8217;s standard database tables. Here, we\u2019ll guide you through the seamless process of scripting in the Settings interface to create and integrate these special fields.<\/p>\n<p><b>Database scripts <i class=\"fa fa-text fa-arrow-right\" aria-hidden=\"true\"><\/i> Add <i class=\"fa fa-text fa-arrow-right\" aria-hidden=\"true\"><\/i> Custom Column to Table<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-9ed2523 e-flex e-con-boxed e-con e-parent\" data-id=\"9ed2523\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-d373dea e-con-full e-flex e-con e-parent\" data-id=\"d373dea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2bac167 elementor-widget elementor-widget-text-editor\" data-id=\"2bac167\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u00a0<\/p>\n<p>As you venture into adding custom fields, the crucial PXCacheExtension integration in the output DAC class comes into play, allowing the fields to interact proficiently. Achieving this sets the stage for developers to fully utilize the personalized fields, fostering the ability to:<\/p>\n<ol>\n<li>Store new vital data in the database<\/li>\n<li>Exhibit database information on the user interface<\/li>\n<li>Utilize field data for API requests or log response data from specific API requests<\/li>\n<li>Develop versatile business logic for individual tasks<\/li>\n<\/ol>\n<p>\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-d6737dc e-con-full e-flex e-con e-parent\" data-id=\"d6737dc\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ad484d3 elementor-widget elementor-widget-image\" data-id=\"ad484d3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/elementor\/thumbs\/computer-science-q9sp5gp40ne8qo1m32s5cfijl2duh4chvbp0eotxa4.jpg\" title=\"computer-science\" alt=\"computer science\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-2df53d1 e-flex e-con-boxed e-con e-parent\" data-id=\"2df53d1\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b389541 elementor-widget elementor-widget-text-editor\" data-id=\"b389541\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Adhering to naming conventions is vital. All custom fields must begin with a &#8220;Usr&#8221; prefix in both the database and the abstract class, aligning with the ISV software certification prerequisites. This practice not only maintains system coherence but also safeguards your software solution&#8217;s functionality and data during system upgrades. Explore more on this in the &#8220;<a href=\"https:\/\/www.acumatica.com\/media\/2019\/05\/2019r1-ISV-Software-Certification-Guildlines.pdf\">Acumatica ISV Software Certification Guidelines<\/a>&#8220;.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-a0c39cb e-flex e-con-boxed e-con e-parent\" data-id=\"a0c39cb\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6ec7218 news-h3 elementor-widget elementor-widget-heading\" data-id=\"6ec7218\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Meeting the Requirements<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-54156dd e-flex e-con-boxed e-con e-parent\" data-id=\"54156dd\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-60b7adf elementor-widget elementor-widget-text-editor\" data-id=\"60b7adf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Here&#8217;s a word of caution: failing to adhere to certain guidelines can cause significant issues during system upgrades, including the deletion of user fields. This not only disrupts the functionality of your software solution but also results in data loss in specific fields. As an example, consider this coding snippet:<\/p>\n<p><b>public abstract class usrFieldName: BqlType &lt;IBqlBool, bool&gt;.Field&lt;usrFieldName&gt; {}. <\/b><\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>At a first glance, things might seem straightforward. However, complications arise when existing projects have user fields without the prescribed &#8216;Usr&#8217; prefix. This could be due to a number of reasons, including insufficient attention to the requirements during development or the incorporation of specific functionalities at the expansion stage.<\/p>\n<p>Correcting this apparent simple error is rather intricate, primarily because data associated with these fields is already housed in the existing database without the &#8216;Usr&#8217; prefix. But don&#8217;t fret, as we&#8217;re here to guide you on how to successfully amend this issue. By following the steps outlined below, both your code and settings will align perfectly with the requirements for creating and using special fields. Here&#8217;s the action plan:<\/p>\n<p>\u00a0<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<ol>\n<li><strong>Database Adjustment<\/strong>: Initiate by creating new fields in the database, identical to the existing ones but now with the &#8216;Usr&#8217; prefix.<\/li>\n<li><strong>Data Migration<\/strong>: Ensure a seamless transfer of data from the old fields to the newly minted ones. Subsequently, remove the old fields to streamline the database.<\/li>\n<li><strong>Class Field Configuration<\/strong>: Adjust the fields of the class into PXCacheExtension to sync with the initial DAC class properly.<\/li>\n<li><strong>Website Page Update<\/strong>: Finally, remove fields that lack the necessary prefix from the website pages and substitute them with the newly created equivalents, this time boasting the &#8216;Usr&#8217; prefix.<\/li>\n<\/ol>\n<p>Let&#8217;s explore each step in detail, providing you with a roadmap for a smooth transition to a more efficient and streamlined system\u00a0<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>At this point, I want to share with you one of the ways of how to successfully correct this flaw. Following the steps described below, the code itself and the settings will thoroughly comply with the requirements on creating and using special fields. To begin with, we will identify and form a plan of the work and changes which will have to take place:<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>In the images provided below you can find a more detailed description of these steps.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-cb3f50a e-flex e-con-boxed e-con e-parent\" data-id=\"cb3f50a\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4f9d449 news-h3 elementor-widget elementor-widget-heading\" data-id=\"4f9d449\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 1: A Glimpse into the Settings Window<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-22d1a8f e-flex e-con-boxed e-con e-parent\" data-id=\"22d1a8f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-58f5641 elementor-widget elementor-widget-text-editor\" data-id=\"58f5641\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Begin by navigating to the Settings window to create fields equivalent to the existing ones.\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-8b3bc2d e-flex e-con-boxed e-con e-parent\" data-id=\"8b3bc2d\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cbbf867 elementor-widget elementor-widget-image\" data-id=\"cbbf867\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1536\" height=\"774\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/creating-equivalent-fields-1536x774.png\" class=\"attachment-1536x1536 size-1536x1536 wp-image-2549\" alt=\"Creating equivalent fields\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/creating-equivalent-fields-1536x774.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/creating-equivalent-fields-300x151.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/creating-equivalent-fields-1024x516.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/creating-equivalent-fields-768x387.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/creating-equivalent-fields.png 1903w\" sizes=\"(max-width: 1536px) 100vw, 1536px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-c41b212 e-flex e-con-boxed e-con e-parent\" data-id=\"c41b212\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-347db11 elementor-widget elementor-widget-text-editor\" data-id=\"347db11\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Utilize the customization settings interface to craft your own fields seamlessly, as illustrated below:<\/p>\n<p>go to the settings on the screen <b>Customization Projects (SM204505)<\/b>, then go to the menu option <b>Database scripts <i class=\"fa fa-text fa-arrow-right\" aria-hidden=\"true\"><\/i> Add <i class=\"fa fa-text fa-arrow-right\" aria-hidden=\"true\"><\/i> Custom Column to Table<\/b>. In the dialogue window, insert all the necessary parameters equivalent to the fields without the prefix.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-66f6265 e-flex e-con-boxed e-con e-parent\" data-id=\"66f6265\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e30c42f elementor-widget elementor-widget-image\" data-id=\"e30c42f\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1536\" height=\"774\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/inserting-parameters-of-fields-1536x774.png\" class=\"attachment-1536x1536 size-1536x1536 wp-image-2552\" alt=\"Inserting parameters of fields\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/inserting-parameters-of-fields-1536x774.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/inserting-parameters-of-fields-300x151.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/inserting-parameters-of-fields-1024x516.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/inserting-parameters-of-fields-768x387.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/inserting-parameters-of-fields.png 1914w\" sizes=\"(max-width: 1536px) 100vw, 1536px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-8cd212c e-flex e-con-boxed e-con e-parent\" data-id=\"8cd212c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f71daf4 news-h3 elementor-widget elementor-widget-heading\" data-id=\"f71daf4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 2: Handling Data Transfer and Old Fields<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-c10dd99 e-flex e-con-boxed e-con e-parent\" data-id=\"c10dd99\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-04caa5b elementor-widget elementor-widget-text-editor\" data-id=\"04caa5b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Now, let\u2019s get our hands a bit dirty with some SQL scripting. To facilitate a smooth transition, you\u2019ll need to write SQL scripts to transfer data from the old fields to the new ones, followed by the removal of the old fields.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-0a6c8bf e-flex e-con-boxed e-con e-parent\" data-id=\"0a6c8bf\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-20efccc elementor-widget elementor-widget-image\" data-id=\"20efccc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"227\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/deleting-old-fields-1024x291.png\" class=\"attachment-large size-large wp-image-2550\" alt=\"Deleting old fields\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/deleting-old-fields-1024x291.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/deleting-old-fields-300x85.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/deleting-old-fields-768x218.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/deleting-old-fields.png 1165w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-24d1ca5 e-flex e-con-boxed e-con e-parent\" data-id=\"24d1ca5\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ae25e6a elementor-widget elementor-widget-text-editor\" data-id=\"ae25e6a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Adding new SQL script:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-06ff9f5 e-flex e-con-boxed e-con e-parent\" data-id=\"06ff9f5\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a3b18ba elementor-widget elementor-widget-image\" data-id=\"a3b18ba\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"405\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-sql-1024x518.png\" class=\"attachment-large size-large wp-image-2554\" alt=\"New SQL\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-sql-1024x518.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-sql-300x152.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-sql-768x388.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-sql-1536x776.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-sql.png 1907w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-0f5d52a e-flex e-con-boxed e-con e-parent\" data-id=\"0f5d52a\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-481b7cf elementor-widget elementor-widget-text-editor\" data-id=\"481b7cf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Here&#8217;s a flexible SQL script template that can be adapted for various field alterations:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\u00a0<\/div>\n<p><strong>IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_NAME = &#8216;table_name_in_DB&#8217; AND COLUMN_NAME = &#8216;UsrFieldName&#8217;)<\/strong><br \/><strong>BEGIN<\/strong><br \/><strong>ALTER TABLE table_name_in_DB ADD UsrFieldName bit NULL;<\/strong><br \/><strong>END;<\/strong><br \/><strong>IF EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_NAME = &#8216;table_name_in_DB&#8217; AND COLUMN_NAME = &#8216;UsrFieldName&#8217;)<\/strong><br \/><strong>BEGIN<\/strong><br \/><strong>IF EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_NAME = &#8216;table_name_in_DB&#8217; AND COLUMN_NAME = &#8216;FieldName&#8217;)<\/strong><br \/><strong>BEGIN<\/strong><br \/><strong>exec(&#8216;UPDATE table_name_in_DB SET UsrFieldName = FieldName&#8217;);<\/strong><br \/><strong>IF EXISTS (SELECT * FROM information_schema.COLUMNS WHERE TABLE_NAME = &#8216;table_name_in_DB&#8217; AND COLUMN_NAME = &#8216;UsrFieldName&#8217;)<\/strong><br \/><strong>BEGIN<\/strong><br \/><strong>ALTER TABLE table_name_in_DB DROP COLUMN FieldName;<\/strong><br \/><strong>END;<\/strong><br \/><strong>END;<\/strong><br \/><strong>END;<\/strong><br \/><strong>GO<\/strong><br \/><br \/><\/p>\n<p>This script performs a series of checks and operations to ensure that data is transferred correctly without duplication, followed by the removal of the old fields.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-aed11b5 e-flex e-con-boxed e-con e-parent\" data-id=\"aed11b5\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c6be73a elementor-widget elementor-widget-image\" data-id=\"c6be73a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"403\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/sql-script-1024x516.png\" class=\"attachment-large size-large wp-image-2556\" alt=\"SQL script\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/sql-script-1024x516.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/sql-script-300x151.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/sql-script-768x387.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/sql-script-1536x774.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/sql-script.png 1919w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-9973a51 e-flex e-con-boxed e-con e-parent\" data-id=\"9973a51\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d667566 news-h3 elementor-widget elementor-widget-heading\" data-id=\"d667566\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 3: Setting Field Classes in DAC Correctly<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-037063c elementor-widget elementor-widget-text-editor\" data-id=\"037063c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Next, let\u2019s focus on setting the field classes in the DAC correctly. For those using a code approach, align the field class in PXCacheExtension with the initial DAC class. Here&#8217;s a snippet to guide you:<\/p>\n<div class=\"bg-black rounded-md mb-4\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans justify-between rounded-t-md\"><strong>public abstract class usrTrackHours: BqlType &lt;IBqlBool, bool&gt;.Field&lt;usrTrackHours&gt; {};<\/strong><\/div>\n<\/div>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>Remember to scrutinize your code thoroughly to identify and update all instances where the specific field is utilized.<\/p>\n<p>For those preferring a project interface setting, navigate to the <strong>Customization Projects<\/strong> <strong>(SM204505) page, select the DATA ACCESS &gt; Add New<\/strong> <strong>Record<\/strong> menu option, and input the necessary parameters for the new field \u2013 don\u2019t forget the &#8216;Usr&#8217; prefix (\u00a0 <strong><em>UsrFieldName<\/em><\/strong>, for example)<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p><em>The below image illustrates how to add a new record to access data and setting parameters:<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-09687cb e-flex e-con-boxed e-con e-parent\" data-id=\"09687cb\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9faedd2 elementor-widget elementor-widget-image\" data-id=\"9faedd2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"403\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-record-to-access-data-1024x516.png\" class=\"attachment-large size-large wp-image-2553\" alt=\"New record to access data\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-record-to-access-data-1024x516.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-record-to-access-data-300x151.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-record-to-access-data-768x387.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-record-to-access-data-1536x774.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/new-record-to-access-data.png 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-a1ba46f e-flex e-con-boxed e-con e-parent\" data-id=\"a1ba46f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fb92088 elementor-widget elementor-widget-text-editor\" data-id=\"fb92088\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><em>As well as setting the necessary parameters for the users\u2019 project interface field settings:<\/em><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-98d8045 e-flex e-con-boxed e-con e-parent\" data-id=\"98d8045\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-474d2b8 elementor-widget elementor-widget-image\" data-id=\"474d2b8\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"398\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/user-interface-parameters-1024x510.png\" class=\"attachment-large size-large wp-image-2557\" alt=\"User interface parameters\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/user-interface-parameters-1024x510.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/user-interface-parameters-300x149.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/user-interface-parameters-768x382.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/user-interface-parameters-1536x765.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/user-interface-parameters.png 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-9cb3a81 e-flex e-con-boxed e-con e-parent\" data-id=\"9cb3a81\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-59a303e elementor-widget elementor-widget-text-editor\" data-id=\"59a303e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Then we will consider deletion of the fields without the necessary prefix and changing them into the fields with <em>Usr<\/em> prefix.<\/p><p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p><p>Editing XML project in the project setting:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-f9fa783 e-flex e-con-boxed e-con e-parent\" data-id=\"f9fa783\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-78aa761 elementor-widget elementor-widget-image\" data-id=\"78aa761\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"404\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/editing-xml-project-1024x517.png\" class=\"attachment-large size-large wp-image-2551\" alt=\"Editing XML project\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/editing-xml-project-1024x517.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/editing-xml-project-300x152.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/editing-xml-project-768x388.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/editing-xml-project-1536x776.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/editing-xml-project.png 1914w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-770dd27 e-flex e-con-boxed e-con e-parent\" data-id=\"770dd27\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8c39747 elementor-widget elementor-widget-text-editor\" data-id=\"8c39747\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Next we will look at saving XML project in the project setting. To do so, it will be convenient to open <b>Customization Projects (SM204505)<\/b> page, then go to the menu option <b>File <i class=\"fa fa-text fa-arrow-right\" aria-hidden=\"true\"><\/i> Edit Project XML<i class=\"fa fa-text fa-arrow-right\" aria-hidden=\"true\"><\/i> and replace the necessary fields in the window with XML code<\/b>.<\/p><p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p><p>To do so, change:<b>&lt;Prop Key = &#8220;DataField&#8221; Value = &#8220;FieldName&#8221; \/&gt;<\/b>into<b>&lt;Prop Key = &#8220;DataField&#8221; Value = &#8220;UsrFieldName&#8221; \/&gt;<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-15d9e29 e-flex e-con-boxed e-con e-parent\" data-id=\"15d9e29\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cc1a228 elementor-widget elementor-widget-image\" data-id=\"cc1a228\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"461\" src=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/save-to-database-1024x590.png\" class=\"attachment-large size-large wp-image-2555\" alt=\"Save to database\" srcset=\"https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/save-to-database-1024x590.png 1024w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/save-to-database-300x173.png 300w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/save-to-database-768x442.png 768w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/save-to-database-1536x885.png 1536w, https:\/\/sprinterra.com.ua\/wp-content\/uploads\/2021\/08\/save-to-database.png 1580w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-9351520 e-flex e-con-boxed e-con e-parent\" data-id=\"9351520\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6d50516 news-h3 elementor-widget elementor-widget-heading\" data-id=\"6d50516\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Step 4: Updating the Website Pages<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8786480 elementor-widget elementor-widget-text-editor\" data-id=\"8786480\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Lastly, it&#8217;s time to clean up your website pages. Remove the fields lacking the &#8216;Usr&#8217; prefix and replace them with their new equivalents.<\/p>\n<p>Once you&#8217;ve made all the necessary adjustments, save your changes to the database. Remember to publish your customization project to apply all the changes you&#8217;ve made.<\/p>\n<p>Following the completion of these adjustments, ensure to save your progress to the database. Before wrapping up, publish your customization project to enact all the alterations you&#8217;ve orchestrated, heralding a new era of streamlined and standardized operations in your Acumatica ERP system.<\/p>\n<p><strong>Remember to always have a backup of your database to prevent any loss of data during this transition.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-cf451cd e-flex e-con-boxed e-con e-parent\" data-id=\"cf451cd\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9aaab76 news-h3 elementor-widget elementor-widget-heading\" data-id=\"9aaab76\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">And Last, but Not Least! <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-15d414a elementor-widget elementor-widget-text-editor\" data-id=\"15d414a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Thank you for following along, and here&#8217;s to a more efficient and optimized Acumatica ERP system!\u00a0<\/p>\n<p>We&#8217;ve visually documented the entire process for your convenience, guiding you step-by-step from the initiation of field creation to the final publishing of your customized project.\u00a0 The journey to mastering Acumatica customization starts with a solid foundation.<\/p>\n<p>\u00a0Stay tuned for more insights and guided walk-throughs in our series. Our goal is to make your Acumatica customization journey as smooth as possible.<\/p>\n<p><strong>Happy coding!<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb4a288 news-h3 elementor-widget elementor-widget-heading\" data-id=\"cb4a288\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Need Expert Assistance? Choose Sprinterra Customization Services!<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-51aca58 elementor-widget elementor-widget-text-editor\" data-id=\"51aca58\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Taking the first steps in customizing your Acumatica ERP system can be a complex process, but you don&#8217;t have to do it alone!<\/p>\n<p><a href=\"http:\/\/100.28.163.57\/acumatica\/\"><strong>Sprinterra&#8217;s Customization Services<\/strong><\/a> are here to facilitate a seamless transition, making sure that every detail aligns perfectly with your business goals.<\/p>\n<p>Whether you&#8217;re looking to optimize existing functionalities or develop new, groundbreaking features, our seasoned experts are ready to assist you every step of the way. With Sprinterra by your side, you&#8217;re not just meeting requirements; you&#8217;re exceeding expectations.<\/p>\n<p>\ud83d\udd39 <a href=\"http:\/\/100.28.163.57\/contact-us\/\"><strong>Embark on a Hassle-Free Customization Journey with Sprinterra Today!<\/strong><\/a><\/p>\n<p>Let&#8217;s explore how we can make YOUR Acumatica customization project a resounding success &#8211; a dynamic, flexible, and robust ERP system, tailored to your unique business needs.<\/p>\n<p><strong><a href=\"http:\/\/100.28.163.57\/contact-us\/\" target=\"_new\">Get in Touch with Sprinterra<\/a><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-ffd9832 e-flex e-con-boxed e-con e-parent\" data-id=\"ffd9832\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-2d617c0 e-flex e-con-boxed e-con e-parent\" data-id=\"2d617c0\" data-element_type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-d558d3e e-con-full e-flex e-con e-parent\" data-id=\"d558d3e\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-eb80aa2 elementor-widget elementor-widget-heading\" data-id=\"eb80aa2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Subscribe To Our Newsletter<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2425aa3 elementor-widget elementor-widget-text-editor\" data-id=\"2425aa3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Get the latest insights on exponential technologies delivered straight to you<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-element elementor-element-0f37958 e-con-full e-flex e-con e-parent\" data-id=\"0f37958\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dfa4a9e elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"dfa4a9e\" data-element_type=\"widget\" data-settings=\"{&quot;button_width&quot;:&quot;33&quot;,&quot;step_next_label&quot;:&quot;Next&quot;,&quot;step_previous_label&quot;:&quot;Previous&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Newsletter\" action=\"\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"4460\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"dfa4a9e\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"\" \/>\n\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-above\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-recaptcha_v3 elementor-field-group elementor-column elementor-field-group-field_3c1728f elementor-col-100 recaptcha_v3-bottomright\">\n\t\t\t\t\t<div class=\"elementor-field\" id=\"form-field-field_3c1728f\"><div class=\"elementor-g-recaptcha\" data-sitekey=\"6LcPSUIqAAAAAP_gg-Sk43ooUGStBTbNpoX7b7u-\" data-type=\"v3\" data-action=\"Form\" data-badge=\"bottomright\" data-size=\"invisible\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-recaptcha_v3 elementor-field-group elementor-column elementor-field-group-field_7e3766e elementor-col-100 recaptcha_v3-bottomright\">\n\t\t\t\t\t<div class=\"elementor-field\" id=\"form-field-field_7e3766e\"><div class=\"elementor-g-recaptcha\" data-sitekey=\"6LcPSUIqAAAAAP_gg-Sk43ooUGStBTbNpoX7b7u-\" data-type=\"v3\" data-action=\"Form\" data-badge=\"bottomright\" data-size=\"invisible\"><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-text elementor-field-group elementor-column elementor-field-group-name elementor-col-33\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-name\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tFull Name\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"text\" name=\"form_fields[name]\" id=\"form-field-name\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"Adam Smith\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-33 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-email\" class=\"elementor-field-label\">\n\t\t\t\t\t\t\t\tEmail Address\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-sm  elementor-field-textual\" placeholder=\"examples@gmail.com\" required=\"required\" aria-required=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-33 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-sm\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Yes!<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<input type=\"hidden\" name=\"trp-form-language\" value=\"en\"\/><\/form>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>",
        "protected": false
    },
    "excerpt": {
        "rendered": "<p>We are starting a new series for ERP Acumatica developers. This article is perfect starting point for beginners, demystifying the fundamentals of Acumatica customization.\u00a0 \u00a0 Creating Custom Fields A standout feature of Acumatica ERP is the ability to create personalized fields, enhancing the system&#8217;s standard database tables. Here, we\u2019ll guide you through the seamless process [&hellip;]<\/p>",
        "protected": false
    },
    "author": 8,
    "featured_media": 4205,
    "comment_status": "closed",
    "ping_status": "closed",
    "sticky": false,
    "template": "elementor_header_footer",
    "format": "standard",
    "meta": {
        "_acf_changed": false,
        "footnotes": ""
    },
    "categories": [
        34
    ],
    "tags": [
        48,
        49,
        50,
        51,
        52,
        53,
        54,
        55,
        56,
        57,
        58,
        59,
        61,
        62,
        63
    ],
    "class_list": [
        "post-4460",
        "post",
        "type-post",
        "status-publish",
        "format-standard",
        "has-post-thumbnail",
        "hentry",
        "category-acumatica",
        "tag-acumatica-customization",
        "tag-acumatica-development",
        "tag-acumatica-erp",
        "tag-acumatica-functionality",
        "tag-acumatica-implementation",
        "tag-acumatica-localization",
        "tag-acumatica-mobile-framework",
        "tag-acumatica-modules",
        "tag-acumatica-partner",
        "tag-acumatica-platform",
        "tag-acumatica-solutions",
        "tag-acumatica-support",
        "tag-acumatica-upgrades",
        "tag-acumatica-var",
        "tag-acumatica-vars"
    ],
    "acf": [],
    "_links": {
        "self": [
            {
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/posts\/4460",
                "targetHints": {
                    "allow": [
                        "GET"
                    ]
                }
            }
        ],
        "collection": [
            {
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/posts"
            }
        ],
        "about": [
            {
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/types\/post"
            }
        ],
        "author": [
            {
                "embeddable": true,
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/users\/8"
            }
        ],
        "replies": [
            {
                "embeddable": true,
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/comments?post=4460"
            }
        ],
        "version-history": [
            {
                "count": 0,
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/posts\/4460\/revisions"
            }
        ],
        "wp:featuredmedia": [
            {
                "embeddable": true,
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/media\/4205"
            }
        ],
        "wp:attachment": [
            {
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/media?parent=4460"
            }
        ],
        "wp:term": [
            {
                "taxonomy": "category",
                "embeddable": true,
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/categories?post=4460"
            },
            {
                "taxonomy": "post_tag",
                "embeddable": true,
                "href": "https:\/\/sprinterra.com.ua\/en\/wp-json\/wp\/v2\/tags?post=4460"
            }
        ],
        "curies": [
            {
                "name": "wp",
                "href": "https:\/\/api.w.org\/{rel}",
                "templated": true
            }
        ]
    }
}