{"id":19761,"date":"2018-07-19T12:03:48","date_gmt":"2018-07-19T12:03:48","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=19761"},"modified":"2024-04-25T05:36:49","modified_gmt":"2024-04-25T05:36:49","slug":"sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/","title":{"rendered":"Sage 300 2018 Release &#8211; GL Batch Creation in two databases simultaneously"},"content":{"rendered":"<p>How you organize your chart of accounts depends on how you intend to use a particular feature of the General Ledger system. You must decide:<\/p>\n<ul>\n<li>Which accounts you need.<\/li>\n<li>Which account segments each account requires.<\/li>\n<li>How you will assign account numbers.<\/li>\n<\/ul>\n<p>Begin by listing the accounts you need, and then decide on an account numbering scheme that suits your financial reporting requirements. Companies\u00a0can sometimes\u00a0get over a hundred applications for a single requirement.<\/p>\n<p><strong>Let\u2019s take Example to understand this How Sage 300 &#8211; Creating GL Batch in two databases simultaneously?<\/strong><\/p>\n<p>As the previous post, we have provided a solution to handle this challenge in Sage 300 Desktop version. (Refer below link)<\/p>\n<p><em><strong>New Stuff:<\/strong> <\/em><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/12\/31\/gl-batch-creation-in-two-databases-simultaneously\/\" target=\"_blank\" rel=\"noopener\">GL Batch Creation in two databases simultaneously<\/a><\/p>\n<p>And here we come up with the Desktop Version and developed same in Sage 2018 Desktop Version.<br \/>\n<u><\/u><\/p>\n<p><u>Short Overview of GL Batch Creation in two databases:<\/u><\/p>\n<p>We have customized GL Batch Entry screen in such a way that, The batches for which \u201cReady to post\u201d is set as \u201cYes\u201d, after posting them, they get posted in two databases simultaneously where one is the source and other is target database.<\/p>\n<p>The user needs to select the batches and set it Ready to post to yes.<\/p>\n<p>Then all the batches will get posted in the source database and also get created and posted in the target database as well as the Fiscal year and Fiscal Period will be changed according to the target database fiscal calendar setting.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\" target=\"_blank\" rel=\"noopener\">Greytrix<\/a>\u00a0a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized 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 expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\" target=\"_blank\" rel=\"noopener\">Greytrix<\/a>\u00a0offers unique GUMU&#x2122; integrated solutions of\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-300-erp-integration\" target=\"_blank\" rel=\"noopener\">Sage 300 with Sage CRM,<\/a>\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/gumu-300-salesforce-integration\" target=\"_blank\" rel=\"noopener\">Salesforce.com\u00a0<\/a>and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp\/ecommerce-magento-integration\" target=\"_blank\" rel=\"noopener\">Magento eCommerce<\/a>\u00a0along with Sage 300 Migration from\u00a0<a href=\"https:\/\/www.greytrix.com\/resources\/sage-erp-crm-migration.pdf\" target=\"_blank\" rel=\"noopener\">Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-300-erp-development\" target=\"_blank\" rel=\"noopener\">Sage 300 customization and development services<\/a>\u00a0and integration service for applications such as\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-300-integration-services\" target=\"_blank\" rel=\"noopener\">POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a>\u00a0and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services \u00a0to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/greymatrix-apparel-solution\" target=\"_blank\" rel=\"noopener\">GreyMatrix<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/greytrix-document-attachement\" target=\"_blank\" rel=\"noopener\">Document Attachment<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/greytrix-document-numbering\" target=\"_blank\" rel=\"noopener\">Document Numbering<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/auto-bank-reconciliation\" target=\"_blank\" rel=\"noopener\">Auto-Bank Reconciliation<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/purchase-approval-system\" target=\"_blank\" rel=\"noopener\">Purchase Approval System<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/three-way-po-matching\" target=\"_blank\" rel=\"noopener\">Three way PO matching<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/bill-of-lading\" target=\"_blank\" rel=\"noopener\">Bill of Lading<\/a>\u00a0and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-300-erp-add-ons\/vat-middle-east\" target=\"_blank\" rel=\"noopener\">VAT for Middle East<\/a>.<\/p>\n<p>For more details on Sage 300 and 300c Services, please contact us at\u00a0<a href=\"mailto:accpac@greytrix.com\" target=\"_blank\" rel=\"noopener\">accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How you organize your chart of accounts depends on how you intend to use a particular feature of the General Ledger system. You must decide: Which accounts you need. Which account segments each account requires. How you will assign account numbers. Begin by listing the accounts you need, and then decide on an account numbering\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/\">Read More &raquo;<\/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":[11,277,384,704,770,1057,2323,2694,3023],"class_list":["post-19761","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-2-databases","tag-at-a-time","tag-both","tag-database","tag-desktop","tag-gl-batch","tag-sage-2018","tag-simultaneously","tag-version"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>GL Batch Creation in Two Databases Simultaneously<\/title>\n<meta name=\"description\" content=\"Learn about tailoring the GL Batch Entry screen so that batches marked Ready to Post as Yes are posted.\" \/>\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\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"GL Batch Creation in Two Databases Simultaneously\" \/>\n<meta property=\"og:description\" content=\"Learn about tailoring the GL Batch Entry screen so that batches marked Ready to Post as Yes are posted.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-19T12:03:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-25T05:36:49+00:00\" \/>\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=\"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\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/\",\"name\":\"GL Batch Creation in Two Databases Simultaneously\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"datePublished\":\"2018-07-19T12:03:48+00:00\",\"dateModified\":\"2024-04-25T05:36:49+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"Learn about tailoring the GL Batch Entry screen so that batches marked Ready to Post as Yes are posted.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sage 300 2018 Release &#8211; GL Batch Creation in two databases simultaneously\"}]},{\"@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":"GL Batch Creation in Two Databases Simultaneously","description":"Learn about tailoring the GL Batch Entry screen so that batches marked Ready to Post as Yes are posted.","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\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/","og_locale":"en_US","og_type":"article","og_title":"GL Batch Creation in Two Databases Simultaneously","og_description":"Learn about tailoring the GL Batch Entry screen so that batches marked Ready to Post as Yes are posted.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2018-07-19T12:03:48+00:00","article_modified_time":"2024-04-25T05:36:49+00:00","author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/","name":"GL Batch Creation in Two Databases Simultaneously","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"datePublished":"2018-07-19T12:03:48+00:00","dateModified":"2024-04-25T05:36:49+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"Learn about tailoring the GL Batch Entry screen so that batches marked Ready to Post as Yes are posted.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/07\/19\/sage-300-2018-release-gl-batch-creation-in-two-databases-simultaneously\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Sage 300 2018 Release &#8211; GL Batch Creation in two databases simultaneously"}]},{"@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\/19761","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=19761"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19761\/revisions"}],"predecessor-version":[{"id":25145,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/19761\/revisions\/25145"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=19761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=19761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=19761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}