{"id":4375,"date":"2026-09-04T10:47:48","date_gmt":"2026-09-04T10:47:48","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/acumatica\/?p=4375"},"modified":"2026-09-04T10:47:49","modified_gmt":"2026-09-04T10:47:49","slug":"https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/","title":{"rendered":"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li><strong>Enable Migration Mode<\/strong><\/li>\n<\/ul>\n\n\n\n<p>Ensure that <strong>Migration Mode<\/strong> is enabled by following these steps:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Navigate to <strong>Payables<\/strong><\/li>\n\n\n\n<li>Go to <strong>Preferences<\/strong><\/li>\n\n\n\n<li>Open <strong>Accounts Payable Preferences<\/strong><\/li>\n\n\n\n<li>Enable <strong>Migration Mode<\/strong><\/li>\n\n\n\n<li>Click <strong>Save<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1-1024x442.png\" alt=\"\" class=\"wp-image-4376\" srcset=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1-1024x442.png 1024w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1-300x130.png 300w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1-768x332.png 768w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1-660x285.png 660w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1.png 1377w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>AP Bills Import \u2013 Excel Sheet Guidelines<\/strong><\/li>\n<\/ul>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Refer to the prescribed <strong>AP Bills Import Excel sheet format<\/strong>.<\/li>\n\n\n\n<li>In Migration Mode, all imported bills will be created in <strong>Open status<\/strong>.<\/li>\n\n\n\n<li>The <strong>Type<\/strong> field must be one of the following:\n<ul class=\"wp-block-list\">\n<li>Bill<\/li>\n\n\n\n<li>Debit Adjustment<\/li>\n\n\n\n<li>Credit Adjustment<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The <strong>Reference Number<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Can be any value<\/li>\n\n\n\n<li>Must be unique for each record<\/li>\n\n\n\n<li>After import, the system will generate the AP Bill Number in sequence<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Ensure the following details are correctly populated:\n<ul class=\"wp-block-list\">\n<li>Vendor ID<\/li>\n\n\n\n<li>Vendor Reference (Invoice Number)<\/li>\n\n\n\n<li>Currency, Currency Rate Type, and Currency Rate (if applicable)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The <strong>Balance Amount<\/strong> and <strong>Document Amount<\/strong> must be the same.<\/li>\n\n\n\n<li>Provide the appropriate <strong>Account<\/strong> and <strong>Subaccount<\/strong> details.<\/li>\n\n\n\n<li>Enter the <strong>Terms Code<\/strong> (based on which the system will calculate the Due Date).\n<ul class=\"wp-block-list\">\n<li>Also include the <strong>Cash Discount Date<\/strong>, if applicable.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"416\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/2-1-1024x416.png\" alt=\"\" class=\"wp-image-4377\" srcset=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/2-1-1024x416.png 1024w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/2-1-300x122.png 300w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/2-1-768x312.png 768w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/2-1-660x268.png 660w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/2-1.png 1378w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Data Provider &#8211; ACU Import AP Bills<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"434\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/3-1-1024x434.png\" alt=\"\" class=\"wp-image-4378\" srcset=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/3-1-1024x434.png 1024w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/3-1-300x127.png 300w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/3-1-768x326.png 768w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/3-1-1536x652.png 1536w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/3-1-2048x869.png 2048w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/3-1-660x280.png 660w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>) Import Scenario &#8211; ACU Import AP Bills.<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"439\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/4-1-1024x439.png\" alt=\"\" class=\"wp-image-4379\" srcset=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/4-1-1024x439.png 1024w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/4-1-300x129.png 300w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/4-1-768x329.png 768w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/4-1-660x283.png 660w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/4-1.png 1377w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"442\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/5-1-1024x442.png\" alt=\"\" class=\"wp-image-4380\" srcset=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/5-1-1024x442.png 1024w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/5-1-300x129.png 300w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/5-1-768x331.png 768w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/5-1-1536x662.png 1536w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/5-1-2048x883.png 2048w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/5-1-660x285.png 660w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Import by Scenario \u2013 ACU Import AP Bills<\/strong><\/li>\n<\/ul>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li>Click the <strong>Prepare<\/strong> button to validate the data.<\/li>\n\n\n\n<li>Click the <strong>Import<\/strong> button to upload the file.<\/li>\n\n\n\n<li>The bills will be generated in <strong>Open status<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"438\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/6-2-1024x438.png\" alt=\"\" class=\"wp-image-4381\" srcset=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/6-2-1024x438.png 1024w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/6-2-300x128.png 300w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/6-2-768x329.png 768w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/6-2-1536x658.png 1536w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/6-2-2048x877.png 2048w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/6-2-660x283.png 660w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>F) See the below Bills and Adjustments Screen<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"443\" src=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/7-1-1024x443.png\" alt=\"\" class=\"wp-image-4382\" srcset=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/7-1-1024x443.png 1024w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/7-1-300x130.png 300w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/7-1-768x332.png 768w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/7-1-660x286.png 660w, https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/7-1.png 1377w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Ensure that Migration Mode is enabled by following these steps:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146,3],"tags":[4,16,393,392],"class_list":["post-4375","post","type-post","status-publish","format-standard","hentry","category-acumatica","category-acumatica-erp","tag-acumatica","tag-acumatica-erp","tag-import-bills","tag-migration-mode"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Import Bills Using the Bills and Adjustment Screen in Migration Mode<\/title>\n<meta name=\"description\" content=\"ConclusionImporting AP Bills through the Bills and Adjustments screen in Migration Mode provides a structured and efficient way to migrate historical bill data into Acumatica. By enabling Migration Mode, preparing the Excel file correctly, configuring the appropriate Data Provider, and mapping the required fields through the Import Scenario, bills can be imported accurately while maintaining the required vendor, financial, currency, and payment terms information.\" \/>\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\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode\" \/>\n<meta property=\"og:description\" content=\"ConclusionImporting AP Bills through the Bills and Adjustments screen in Migration Mode provides a structured and efficient way to migrate historical bill data into Acumatica. By enabling Migration Mode, preparing the Excel file correctly, configuring the appropriate Data Provider, and mapping the required fields through the Import Scenario, bills can be imported accurately while maintaining the required vendor, financial, currency, and payment terms information.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/\" \/>\n<meta property=\"og:site_name\" content=\"Acumatica \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2026-09-04T10:47:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-09-04T10:47:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1377\" \/>\n\t<meta property=\"og:image:height\" content=\"595\" \/>\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\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/\",\"name\":\"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1-1024x442.png\",\"datePublished\":\"2026-09-04T10:47:48+00:00\",\"dateModified\":\"2026-09-04T10:47:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec\"},\"description\":\"ConclusionImporting AP Bills through the Bills and Adjustments screen in Migration Mode provides a structured and efficient way to migrate historical bill data into Acumatica. By enabling Migration Mode, preparing the Excel file correctly, configuring the appropriate Data Provider, and mapping the required fields through the Import Scenario, bills can be imported accurately while maintaining the required vendor, financial, currency, and payment terms information.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1.png\",\"width\":1377,\"height\":595},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode\"}]},{\"@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\/c49d53021d39726d820c6fd517b2c2ec\",\"name\":\"greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g\",\"caption\":\"greytrix\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode","description":"ConclusionImporting AP Bills through the Bills and Adjustments screen in Migration Mode provides a structured and efficient way to migrate historical bill data into Acumatica. By enabling Migration Mode, preparing the Excel file correctly, configuring the appropriate Data Provider, and mapping the required fields through the Import Scenario, bills can be imported accurately while maintaining the required vendor, financial, currency, and payment terms information.","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\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/","og_locale":"en_US","og_type":"article","og_title":"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode","og_description":"ConclusionImporting AP Bills through the Bills and Adjustments screen in Migration Mode provides a structured and efficient way to migrate historical bill data into Acumatica. By enabling Migration Mode, preparing the Excel file correctly, configuring the appropriate Data Provider, and mapping the required fields through the Import Scenario, bills can be imported accurately while maintaining the required vendor, financial, currency, and payment terms information.","og_url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/","og_site_name":"Acumatica \u2013 Tips, Tricks and Components","article_published_time":"2026-09-04T10:47:48+00:00","article_modified_time":"2026-09-04T10:47:49+00:00","og_image":[{"width":1377,"height":595,"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1.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\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/","name":"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1-1024x442.png","datePublished":"2026-09-04T10:47:48+00:00","dateModified":"2026-09-04T10:47:49+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/c49d53021d39726d820c6fd517b2c2ec"},"description":"ConclusionImporting AP Bills through the Bills and Adjustments screen in Migration Mode provides a structured and efficient way to migrate historical bill data into Acumatica. By enabling Migration Mode, preparing the Excel file correctly, configuring the appropriate Data Provider, and mapping the required fields through the Import Scenario, bills can be imported accurately while maintaining the required vendor, financial, currency, and payment terms information.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-content\/uploads\/2026\/09\/1-1.png","width":1377,"height":595},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/2026\/09\/04\/https-www-greytrix-com-blogs-acumatica-wp-admin-post-phppost4375actionedit\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/acumatica\/"},{"@type":"ListItem","position":2,"name":"How to Import Bills Using the Bills and Adjustment Screen in Migration Mode"}]},{"@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\/c49d53021d39726d820c6fd517b2c2ec","name":"greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/acumatica\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3cdb553d6ca07df0e407d5e092f2410d163e0fd40b27734b345b04c8f0786969?s=96&d=mm&r=g","caption":"greytrix"},"url":"https:\/\/www.greytrix.com\/blogs\/acumatica\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/4375","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/comments?post=4375"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/4375\/revisions"}],"predecessor-version":[{"id":4383,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/posts\/4375\/revisions\/4383"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/media?parent=4375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/categories?post=4375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/acumatica\/wp-json\/wp\/v2\/tags?post=4375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}