{"id":32751,"date":"2023-06-30T12:17:08","date_gmt":"2023-06-30T12:17:08","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=32751"},"modified":"2023-10-05T09:42:15","modified_gmt":"2023-10-05T09:42:15","slug":"payable-workflow-import-utility","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/","title":{"rendered":"Payable Workflow Import Utility"},"content":{"rendered":"\n

As we know, in Sage 300<\/a> invoice transactions submitted in Accounts Payable module cannot be reversed for revisions without generating either a credit or debit note against that particular invoice transaction. In order to avoid generating a credit or debit note, Invoice entry can be passed through Payable Workflow module.<\/p>\n\n\n\n

New Stuff<\/em> :- A Comprehensive Guide to Setting Up a Database in Sage 300 v2023 PU2<\/a><\/p>\n\n\n\n

The Payable Workflow module allows Users to validate the AP Invoice entry for revisions and the same can be posted only with approval of the authorized user. But creating such a vast number of invoice entries will be time consuming and mistake prone if done manually. So to reduce the manual efforts, we have developed an import utility named as \u201cPA Invoice Import Utility\u201d. Below is the brief description of how this utility works.<\/p>\n\n\n\n

This import utility will create PA invoice entries automatically in the Sage300. The user interface for importing entries from the excel sheet is as below:<\/p>\n\n\n\n

\"PA<\/a><\/center>\n
Fig1: PA Invoice Import Utility UI<\/center><\/font>\n\n\n\n

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

The user needs to select the appropriate excel sheet and then click on Import Button for the entries to be imported. The utility will validate data from the excel file with respect to Sage 300 database. The mandatory fields like Document number, Vendor Number, Workflow, Workflow code, etc. will be validated.<\/p>\n\n\n\n

On the click of import button PA Invoice entries will be generated successfully if data provided in the excel file is valid. In case the data is invalid, then the entry will not be created and an error log will be generated.<\/p>\n\n\n\n

Below is the format of the Import sheet that shows the fields of PA Invoice entries and the same will be used for import purpose.<\/p>\n\n\n\n

\"PA<\/a><\/center>\n
Fig2: PA Invoice Import Excel<\/center><\/font>\n\n\n\n

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

After successfully importing the data, you can check for the PA Invoice entries generated as shown below:<\/p>\n\n\n\n

\"Imported<\/a><\/center>\n
Fig3: Imported PA Invoice Entry<\/center><\/font>\n\n\n\n

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

Thus with the help of this import utility User can easily import the Invoice entries and save the manual efforts.<\/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","protected":false},"excerpt":{"rendered":"

As we know, in Sage 300 invoice transactions submitted in Accounts Payable module cannot be reversed for revisions without generating either a credit or debit note against that particular invoice transaction. In order to avoid generating a credit or debit note, Invoice entry can be passed through Payable Workflow module. New Stuff :- A Comprehensive\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[3574,1269,1367,4084,2960],"class_list":["post-32751","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-excel-export","tag-import","tag-invoice","tag-payables-workflow","tag-utility"],"yoast_head":"\nPayable Workflow Import Utility - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"description\" content=\"This import utility will create PA invoice entries automatically in Sage300 & can easily import the Invoice entries and save the manual efforts.\" \/>\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\/2023\/06\/30\/payable-workflow-import-utility\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Payable Workflow Import Utility - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"This import utility will create PA invoice entries automatically in Sage300 & can easily import the Invoice entries and save the manual efforts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-30T12:17:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-05T09:42:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.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=\"2 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\/2023\/06\/30\/payable-workflow-import-utility\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/\",\"name\":\"Payable Workflow Import Utility - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.png\",\"datePublished\":\"2023-06-30T12:17:08+00:00\",\"dateModified\":\"2023-10-05T09:42:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"This import utility will create PA invoice entries automatically in Sage300 & can easily import the Invoice entries and save the manual efforts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Payable Workflow Import Utility\"}]},{\"@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\/93977cd8aa8fbd1f151d3f664e29c9f2\",\"name\":\"Greytrix\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\/sageaccpacerp\/author\/greytrix\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Payable Workflow Import Utility - Sage 300 ERP \u2013 Tips, Tricks and Components","description":"This import utility will create PA invoice entries automatically in Sage300 & can easily import the Invoice entries and save the manual efforts.","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\/2023\/06\/30\/payable-workflow-import-utility\/","og_locale":"en_US","og_type":"article","og_title":"Payable Workflow Import Utility - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"This import utility will create PA invoice entries automatically in Sage300 & can easily import the Invoice entries and save the manual efforts.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2023-06-30T12:17:08+00:00","article_modified_time":"2023-10-05T09:42:15+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.png","type":"","width":"","height":""}],"author":"Greytrix","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Greytrix","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/","name":"Payable Workflow Import Utility - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.png","datePublished":"2023-06-30T12:17:08+00:00","dateModified":"2023-10-05T09:42:15+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"This import utility will create PA invoice entries automatically in Sage300 & can easily import the Invoice entries and save the manual efforts.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2023\/06\/image-10.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2023\/06\/30\/payable-workflow-import-utility\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Payable Workflow Import Utility"}]},{"@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\/93977cd8aa8fbd1f151d3f664e29c9f2","name":"Greytrix","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/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\/sageaccpacerp\/author\/greytrix\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/32751","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=32751"}],"version-history":[{"count":9,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/32751\/revisions"}],"predecessor-version":[{"id":33369,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/32751\/revisions\/33369"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=32751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=32751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=32751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}