{"id":12583,"date":"2015-09-23T11:09:13","date_gmt":"2015-09-23T11:09:13","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=12583"},"modified":"2015-09-23T11:09:13","modified_gmt":"2015-09-23T11:09:13","slug":"service-invoice-import-routine-for-automobile-industries-in-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/","title":{"rendered":"Service Invoice Import Routine for Automobile industries in Sage 300"},"content":{"rendered":"

Generally the automobile industries are moving towards the implementation of ERP into their organization. In this blog we will see how the service invoices can directly create into Sage 300<\/a> from another system.
\nIf a vehicle comes in a workshop for servicing, then after completion of the service, we make invoice for the total labor chargers & extra parts that the worker has applied to that vehicle. This is nothing but called as Service Invoice in automobile industries.
\nIn case, if the industry already has the system for maintaining all those things then in this case we have created an import routine which will directly fetch the data from database, list out in UI control & after verifying all the data user can processed it for automatic creation of Invoices in Sage 300<\/a>.
\nFor achieving this we need to map the items from both the systems through optional fields, so that at the time of importing same item has to be present into the Sage 300 & customers as well. After mapping all those things we have to create SQL view which will fetch the data from both the database with linked sever connection.
\nBelow will be the UI for import routine:
\nNew Stuff:\u00a0<\/strong><\/em><\/span>Non-Returnable Gate Pass<\/a>
\n\"blog11\"<\/a>
\nIn this UI you will get the below controls:
\n\u2022 \u00a0Filter criteria for date selection & depends on that we will fetch the data from another systems database.
\n\u2022 \u00a0Location selection as this is mandatory field for creation of invoice in Sage 300<\/a>. This finder will show you all the locations from your company database in Sage 300.
\n\u2022 \u00a0This Grid will show you all the header level data from your database of another system.
\n\u2022 \u00a0Popup will display after clicking on a particular row & it will contain all the detail level data from your database of another system.
\n\u2022 \u00a0Once you have done with the data verification, you need to click Import button. This will start the process of importing into Sage 300<\/a> with the showing data in grid.
\nAfter completion of import process you will get the successful message into message box or else if there will be any error in importing, you will get those error in error log file. The path of error log which we have to set in configuration file.
\nAdvantages:<\/strong>
\n-As this is direct database to database importing of data, you will save your time of import & export data through some files like excel etc.
\nAlso Read:<\/strong><\/em><\/span>
\n1.Database To Database Integration in SAGE 300 ERP<\/a>
\n2.How Deposit date in AR receipt entry plays important role in Bank Reconciliation<\/a>
\n3.Generic Import-Export Macros for Sage 300 ERP<\/a>
\n4.Table Does Not Exist Error while importing data into Sage 300 ERP<\/a>
\n5.Import and Export feature in Style Maintenance screen of GreyMatrix for Sage 300 ERP<\/a>
\n <\/p>\n","protected":false},"excerpt":{"rendered":"

Generally the automobile industries are moving towards the implementation of ERP into their organization. In this blog we will see how the service invoices can directly create into Sage 300 from another system. If a vehicle comes in a workshop for servicing, then after completion of the service, we make invoice for the total labor\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[1269,1325,2645,2646,2647],"class_list":["post-12583","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-import","tag-integration","tag-service-invoice","tag-service-invoice-import","tag-service-invoice-integration"],"yoast_head":"\nService Invoice Import Routine for Automobile industries in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\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\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Service Invoice Import Routine for Automobile industries in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Generally the automobile industries are moving towards the implementation of ERP into their organization. In this blog we will see how the service invoices can directly create into Sage 300 from another system. If a vehicle comes in a workshop for servicing, then after completion of the service, we make invoice for the total labor\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-23T11:09:13+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.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=\"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\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/\",\"name\":\"Service Invoice Import Routine for Automobile industries in Sage 300 - 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\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.jpg\",\"datePublished\":\"2015-09-23T11:09:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Service Invoice Import Routine for Automobile industries in Sage 300\"}]},{\"@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":"Service Invoice Import Routine for Automobile industries in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","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\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/","og_locale":"en_US","og_type":"article","og_title":"Service Invoice Import Routine for Automobile industries in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"Generally the automobile industries are moving towards the implementation of ERP into their organization. In this blog we will see how the service invoices can directly create into Sage 300 from another system. If a vehicle comes in a workshop for servicing, then after completion of the service, we make invoice for the total labor\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-09-23T11:09:13+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.jpg","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/","name":"Service Invoice Import Routine for Automobile industries in Sage 300 - 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\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.jpg","datePublished":"2015-09-23T11:09:13+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/09\/blog115.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/09\/23\/service-invoice-import-routine-for-automobile-industries-in-sage-300\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Service Invoice Import Routine for Automobile industries in Sage 300"}]},{"@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\/12583","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=12583"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/12583\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=12583"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=12583"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=12583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}