{"id":3830,"date":"2025-12-08T05:57:25","date_gmt":"2025-12-08T05:57:25","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=3830"},"modified":"2026-02-27T09:48:43","modified_gmt":"2026-02-27T09:48:43","slug":"upload-action-with-custom-grid-screen-for-data-import","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/","title":{"rendered":"Upload Action with Custom Grid Screen for Data Import"},"content":{"rendered":"\n

In many businesses\u2019 scenarios in Acumatica<\/a>, they need a simple way to upload data without using the full Import Scenarios module. Sometimes you want users to upload a small file, validate it, review the data in a grid, and save it\u2014directly inside a custom screen. That’s exactly where a custom grid screen with an Upload button becomes useful.<\/p>\n\n\n\n

Why Bother with a Custom Upload Screen?<\/h2>\n\n\n\n

Import scenarios are great for complex, repeating imports. But most of the users just want to upload their file and move on with their day. A custom screen strips away all that complexity. You build exactly what they need, nothing more, nothing less. Upload, review, save & Done. Here’s where things get interesting. With a custom screen, you control the validation logic completely.<\/p>\n\n\n\n

How We Can Build It.<\/h2>\n\n\n\n

Here is the functional overview of how this type of screen is created in Acumatica<\/a>. This explanation focuses on the process and architecture rather than the utilization of the code.<\/p>\n\n\n\n

Create Custom Table<\/h3>\n\n\n\n

We need somewhere to store the data. You define a custom table with whatever fields make sense or meet your requirements.<\/p>\n\n\n\n

Build the Custom Screen<\/h3>\n\n\n\n

Using Acumatica’s customization platform, you create a new screen. It needs a few key pieces:<\/p>\n\n\n\n

A grid to display the imported data<\/p>\n\n\n\n

An Upload button<\/p>\n\n\n\n

The usual Save and Cancel buttons<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Straightforward, the grid is where users will see and interact with their uploaded\/imported data. Make sure about the upload action setting.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The Upload Button<\/h3>\n\n\n\n

When users click the Upload button, Acumatica opens a file browser. They pick up their Excel file, and the system takes it for processing.

When you upload the file, a popup opens asking how you want to handle blank (null) values. You can choose to replace them with 0 or \u2018\u2013\u2019.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After you click OK, the next popup appears, allowing you to map the fields from the screen to the fields in the uploaded Excel file.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

This is standard Acumatica functionality you’re just plugging into what’s already there.<\/p>\n\n\n\n

Show It in the Grid<\/h3>\n\n\n\n

After processing, the data appears in the grid. Users can review everything, make manual edits if needed, and then save when they’re satisfied.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Think of the grid as a staging area. Nothing’s permanent until they hit Save. They can delete bad rows, fix typos, even add new rows manually if they want.<\/p>\n\n\n\n

Conclusion<\/h2>\n\n\n\n

Look, Import Scenarios have their place. But sometimes you need something lighter and more focused. A custom grid screen with upload functionality gives you exactly that.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

In many businesses\u2019 scenarios in Acumatica, they need a simple way to upload data without using the full Import Scenarios module. Sometimes you want users to upload a small file, validate it, review the data in a grid, and save it\u2014directly inside a custom screen. That’s exactly where a custom grid screen with an Upload\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146,15,3,130,14],"tags":[193,4,16,363,365,364,362],"class_list":["post-3830","post","type-post","status-publish","format-standard","hentry","category-acumatica","category-acumatica-customization","category-acumatica-erp","category-acumatica-product","category-acumatica-services","tag-action","tag-acumatica","tag-acumatica-erp","tag-custom-screen","tag-data-validation","tag-import","tag-upload-action"],"yoast_head":"\nUpload Action with Custom Grid Screen for Data Import<\/title>\n<meta name=\"description\" content=\"Create an upload action with a custom grid screen to simplify data import, improve validation, and streamline record processing.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upload Action with Custom Grid Screen for Data Import\" \/>\n<meta property=\"og:description\" content=\"Create an upload action with a custom grid screen to simplify data import, improve validation, and streamline record processing.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-08T05:57:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-27T09:48:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1150\" \/>\n\t<meta property=\"og:image:height\" content=\"273\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Greytrix\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Greytrix\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/\",\"name\":\"Upload Action with Custom Grid Screen for Data Import\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2-1024x243.png\",\"datePublished\":\"2025-12-08T05:57:25+00:00\",\"dateModified\":\"2026-02-27T09:48:43+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/552ee972453444bfd83035b7b7c1a407\"},\"description\":\"Create an upload action with a custom grid screen to simplify data import, improve validation, and streamline record processing.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2.png\",\"width\":1150,\"height\":273},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upload Action with Custom Grid Screen for Data Import\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\",\"name\":\"Acumatica \u2013 Tips, Tricks and Components\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/552ee972453444bfd83035b7b7c1a407\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"Greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/acumatica\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upload Action with Custom Grid Screen for Data Import","description":"Create an upload action with a custom grid screen to simplify data import, improve validation, and streamline record processing.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/","og_locale":"en_US","og_type":"article","og_title":"Upload Action with Custom Grid Screen for Data Import","og_description":"Create an upload action with a custom grid screen to simplify data import, improve validation, and streamline record processing.","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2025-12-08T05:57:25+00:00","article_modified_time":"2026-02-27T09:48:43+00:00","og_image":[{"width":1150,"height":273,"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2.png","type":"image\/png"}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/","name":"Upload Action with Custom Grid Screen for Data Import","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2-1024x243.png","datePublished":"2025-12-08T05:57:25+00:00","dateModified":"2026-02-27T09:48:43+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/552ee972453444bfd83035b7b7c1a407"},"description":"Create an upload action with a custom grid screen to simplify data import, improve validation, and streamline record processing.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2025\/12\/Screenshot-2.png","width":1150,"height":273},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2025\/12\/08\/upload-action-with-custom-grid-screen-for-data-import\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"Upload Action with Custom Grid Screen for Data Import"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/","name":"Acumatica \u2013 Tips, Tricks and Components","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/552ee972453444bfd83035b7b7c1a407","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"Greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/acumatica\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/3830","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/comments?post=3830"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/3830\/revisions"}],"predecessor-version":[{"id":3836,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/3830\/revisions\/3836"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=3830"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=3830"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=3830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}