{"id":2688,"date":"2013-02-25T10:07:58","date_gmt":"2013-02-25T10:07:58","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=2688"},"modified":"2024-12-19T09:32:36","modified_gmt":"2024-12-19T09:32:36","slug":"record-already-exists-error-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/","title":{"rendered":"How to resolve "Record already exists error"- Sage 300 ERP"},"content":{"rendered":"\n

While using transaction entry screens<\/strong> of Sage 300 ERP (Formerly known as Sage Accpac ERP), sometimes users gets an error \u201cRecord already exists<\/strong>\u201d, due to which they will not be able to generate transactions with auto assigned number and needs to manually enter the Document Numbers.
<\/p>\n\n\n\n

\"Error\"<\/a><\/figure>\n\n\n\n


Also Read:<\/strong> Setup your own numbering in Sage 300 using Greytrix Document Numbering<\/a><\/p>\n\n\n\n

Possible Causes<\/strong>: Generally user gets \u201cRecord already exists<\/strong>\u201d error message in the following scenario’s:<\/p>\n\n\n\n

1.<\/strong> If  user change Next Number in Options UI, and tries to create a new transaction with auto generated no, it will result in a error message.
2.<\/strong> Sometimes user selects last transaction number and manually increment it with one, then create and post this new transaction. But Standard Sage 300 doesn’t reflect the  same in Next Number field in options UI. So next time if user tries to create a transaction with auto generated no, it will result in a error message.<\/p>\n\n\n\n

For example<\/strong> let us consider the PO Purchase Order Transaction assume that last Purchase Order No is PO000025 and Next Document Number for PO Order is PO000026.<\/p>\n\n\n\n

1.<\/strong> If  user accidentally change Next Number to PO000025 in PO Options UI, and tries to create a new Purchase Order with auto generated no, it will result in a error message.
2.<\/strong> It may also, happen that the user selected the last order no i.e. PO000025, manually change it to PO000026, create and post the new order. But Standard Sage 300 doesn’t reflect the  same in Next Number field (i.e. it still shows Next Document No as PO000026). So next time if user tries to create a new Purchase Order with auto generated no, it will result in a error message.<\/p>\n\n\n\n

Solution<\/strong>: Follow below mentioned steps to get rid of this error and can create transactions successfully.<\/p>\n\n\n\n

1.<\/strong> As we would be using Purchase Order Entry as an example, navigate to Purchase Order transaction >> Purchase order Entry and Check the last generated PO number from the purchase order entry screen.
<\/p>\n\n\n\n

\"Sage<\/a>
Purchase Order Entry Screen<\/figcaption><\/figure>\n\n\n\n


2.<\/strong> Then navigate to P\/O Set up >> P\/O option screen and check the Next number for Purchase Order Number. If it is same as the last PO number, then increment it to the next number and save.
<\/p>\n\n\n\n

\"Purchase<\/a>
PO Options Screen<\/figcaption><\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"Purchase<\/a>
PO Options Next Doc Number Updated<\/figcaption><\/figure>\n\n\n\n


3. <\/strong>Now create new purchase order entry and after posting the same you will be able to create it with PO Number auto incremented to next sequence number. Thus, \u201cRecord already exists\u201d error will not occur further.
<\/p>\n\n\n\n

\"New<\/a>
New PO Entry<\/figcaption><\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"Posting<\/a>
Posting Completed<\/figcaption><\/figure>\n\n\n\n


Hence, by following the above simple steps, Users can remove \u201cRecord already exists<\/strong>\u201d error occurred in any modules of Sage 300 ERP transaction screen like OE Transactions, A\/R  Transactions, and IC Transactions where document number is incremented from next sequence number.<\/p>\n\n\n\n

About Us<\/strong><\/span><\/p>\n\n\n\n

Greytrix<\/a> – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

Greytrix<\/a>\u00a0offers unique GUMU™<\/a> integrated solutions of\u00a0\u00a0Sage 300 <\/a>with Sage CRM,\u00a0Salesforce(listed on Salesforce Appexchange), Dynamics 365 CRM, and\u00a0Magento eCommerce,\u00a0along with Sage 300 Migration from\u00a0Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business <\/a>Works<\/a>. We also offer best-in-class\u00a0Sage 300 customization and development services\u00a0and integration services for applications such as\u00a0POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a>\u00a0and for Sage 300c development services we offer, upgrades of older codes and screens to new web screens, latest integrations using Data and web services to Sage business partners, end users and Sage PSG worldwide. <\/p>\n\n\n\n

Greytrix offers 20+ add-ons for Sage 300 to enhance productivity such as\u00a0GreyMatrix,\u00a0Document Attachment,\u00a0Document Numbering,\u00a0Auto-Bank Reconciliation,\u00a0Purchase Approval System,\u00a0Three-way PO matching,\u00a0Bill of Lading,\u00a0and\u00a0VAT for the Middle East. The GUMU™ integration for Dynamics 365 CRM \u2013 Sage ERP is listed on Microsoft Appsource with an easy implementation package. <\/p>\n\n\n\n

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button. <\/p>

For more details on Sage 300 and Sage 300c Services, please contact us at accpac@greytrix.com<\/a>, We will like to hear from you.<\/p>\n\n\n\n

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

While using transaction entry screens of Sage 300 ERP (Formerly known as Sage Accpac ERP), sometimes users gets an error \u201cRecord already exists\u201d, due to which they will not be able to generate transactions with auto assigned number and needs to manually enter the Document Numbers. Also Read: Setup your own numbering in Sage 300 using Greytrix Document\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":[2],"tags":[88,808,906,1728,2083,2191,2357,2451],"class_list":["post-2688","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac-oe-po-order-entry","tag-document-number","tag-error-auto-generated-document-no","tag-next-sequence-number","tag-purchase-order-entry","tag-record-already-exists-error","tag-sage-300-erp","tag-sage-accpac-erp"],"yoast_head":"\nHow to resolve "Record already exists error"- Sage 300 ERP<\/title>\n<meta name=\"description\" content=\"Users can remove \u201cRecord already exists\u201d error occurred in any modules of Sage 300 ERP transaction screen like OE, A\/R, & IC Transactions\" \/>\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\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to resolve "Record already exists error"- Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"Users can remove \u201cRecord already exists\u201d error occurred in any modules of Sage 300 ERP transaction screen like OE, A\/R, & IC Transactions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-25T10:07:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-19T09:32:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/\",\"name\":\"How to resolve \\\"Record already exists error\\\"- Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg\",\"datePublished\":\"2013-02-25T10:07:58+00:00\",\"dateModified\":\"2024-12-19T09:32:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Users can remove \u201cRecord already exists\u201d error occurred in any modules of Sage 300 ERP transaction screen like OE, A\/R, & IC Transactions\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to resolve "Record already exists error"- Sage 300 ERP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to resolve \"Record already exists error\"- Sage 300 ERP","description":"Users can remove \u201cRecord already exists\u201d error occurred in any modules of Sage 300 ERP transaction screen like OE, A\/R, & IC Transactions","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\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"How to resolve \"Record already exists error\"- Sage 300 ERP","og_description":"Users can remove \u201cRecord already exists\u201d error occurred in any modules of Sage 300 ERP transaction screen like OE, A\/R, & IC Transactions","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-02-25T10:07:58+00:00","article_modified_time":"2024-12-19T09:32:36+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/","name":"How to resolve \"Record already exists error\"- Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg","datePublished":"2013-02-25T10:07:58+00:00","dateModified":"2024-12-19T09:32:36+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Users can remove \u201cRecord already exists\u201d error occurred in any modules of Sage 300 ERP transaction screen like OE, A\/R, & IC Transactions","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2021\/08\/Record-already-exists-Error.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/02\/25\/record-already-exists-error-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"How to resolve "Record already exists error"- Sage 300 ERP"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?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\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=2688"}],"version-history":[{"count":11,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2688\/revisions"}],"predecessor-version":[{"id":33079,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2688\/revisions\/33079"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=2688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=2688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=2688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}