{"id":2454,"date":"2013-01-31T09:33:39","date_gmt":"2013-01-31T09:33:39","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=2454"},"modified":"2024-12-18T09:49:00","modified_gmt":"2024-12-18T09:49:00","slug":"source-journal-profile-in-sage-300-erp","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/","title":{"rendered":"Source Journal Profile in Sage 300 ERP"},"content":{"rendered":"<p>In Sage 300 ERP (formerly known as Sage Accpac ERP) has a distinctive feature known as Source Journal Profile in GL, which can be used by User to configure their Source Journals Reports. Say for an example, \u00a0Users want to view <strong>Total Cash In<\/strong> or <strong>Payment<\/strong> that he has received, then in Source Journal Profile he has to define the source journal profile code say <strong>Payment<\/strong>, AR Payments for a particular account (Petty Cash), which would list down all the transactions (payments) for Petty Cash account.<br \/>\nThe GL Source Journal Profiles let you specify which source (type) of transactions you want in a report. Source journals select and print posted transaction details according to transaction source codes.<br \/>\nThe GL Source Journal reports created using Source Journal Profile can be used for different purposes such as; Reports requested by Auditors, Tracking specific transactions for month end balancing, basic job cost reporting etc.<br \/>\n<strong>For Setting up a Source Journal Profile, follow below mentioned process:<\/strong><\/p>\n<p style=\"padding-left: 30px\"><strong>1.<\/strong>\u00a0Navigate to Sage 300 ERP &gt;&gt; General Ledger Module &gt;&gt; G\/L Setup and select Source Journal Profiles.<br \/>\n<strong>2.<\/strong>\u00a0Enter a Journal Profile name (say Payment) and select the source codes to be included in the Source Journal Report.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png\" target=\"_blank\" rel=\"noopener\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-2455\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png\" alt=\"\" width=\"560\" height=\"397\" \/><\/a><\/p>\n<p style=\"text-align: left\">Here, in the above example AR Prepayment implies advance received from customers and AR Payment received implies total cash in from customers. It would give us the total payments received from customers.<\/p>\n<p style=\"text-align: left\"><strong>Similarly<\/strong>, one can create different profiles depending on their need; it can be Invoice Journals, Purchase and Receipt Journal, GL Journal and so on.<\/p>\n<p style=\"text-align: left\"><strong>Printing Source Journal Report:<\/strong><\/p>\n<p style=\"text-align: left\">Source Journal lists the details of posted transactions from the source codes that are included in source-journal definition.<\/p>\n<p style=\"text-align: left\">Users can also narrow report\u2019s focus by specifying ranges of report fields. Specify the source codes that appear in a report in the source journal profile, and specify the following items when you print the source journal:<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><strong>1.<\/strong>\u00a0Reports can be S<span style=\"line-height: 1.6em\">ort by account number, account segment, account group, or account sorted group.\u00a0<\/span><\/p>\n<p style=\"text-align: left;padding-left: 60px\"><strong>a.<\/strong>\u00a0<strong>Account Number<\/strong> &#8211; Chart of Accounts are defined in General Ledger, that identifies the account type as one of the income, expense, asset, and liability accounts that records companies business transactions.<br \/>\n<strong>b.<\/strong>\u00a0<strong>Account Segment<\/strong> &#8211; General Ledger account number let\u2019s user to define account numbers with two or more segments, one segment may be of account segment, and other segment may identify department. Every account number requires an account segment.<br \/>\n<strong>c.<\/strong>\u00a0<strong>Account Group<\/strong> &#8211; Account Group is a broader classification to which each Account is assigned. Sage 300 ERP uses Account Groups to classify Account Balances whether it is an Income Statement or Balance Sheet Account.<br \/>\n<strong>d.<\/strong>\u00a0<strong>Account Sorted Group &#8211; <\/strong>If you want to print a set of common account groups then give the same sort code to all account groups in set, specify printing by sort code order, and then choose the sort code of that set.<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><strong>2.<\/strong>\u00a0The ranges of account numbers, segment codes, account groups, or account sorted groups.<br \/>\n<strong>3.<\/strong>\u00a0The ranges of fiscal periods (Month selection Range), references, dates (From and to dates selection), posting sequences, and batch numbers.<\/p>\n<p style=\"text-align: left\">In other words, Journal profile specifies the type of transaction, but you refine the detail selection at print time. Thus, resulting in a flexible reports for tracing all kinds of transactions, originating from any of the sub-ledgers.<\/p>\n<p style=\"text-align: center\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/2.-GL-Source-Journals-Report.png\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter  wp-image-2456\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/2.-GL-Source-Journals-Report.png\" alt=\"\" width=\"517\" height=\"486\" \/><\/a><\/p>\n<p style=\"text-align: left\">General Ledger comes with three source journal report definitions:<\/p>\n<p style=\"text-align: left;padding-left: 30px\"><strong>1.<\/strong>\u00a0<strong>GLSJ01F.RPT<\/strong> \u2014 lists only the functional-currency value of transactions. This is a single-currency or functional-currency-only version of the source journal.<br \/>\n<strong>2.<\/strong>\u00a0<strong>GLSJ01S.RPT<\/strong><span style=\"line-height: 1.6em\"> \u2014 lists the source-currency and\/or the functional-currency value of transactions. This is the full multicurrency version of the source journal.<br \/>\n<strong>3.<\/strong>\u00a0<strong>GLSJ1SA.RPT<\/strong> \u2014 Use this report when you want to print source-currency reports on A4 paper.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Sage 300 ERP (formerly known as Sage Accpac ERP) has a distinctive feature known as Source Journal Profile in GL, which can be used by User to configure their Source Journals Reports. Say for an example, \u00a0Users want to view Total Cash In or Payment that he has received, then in Source Journal Profile\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/\">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":[1040,1101,2357,2451,2717,2718],"class_list":["post-2454","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-general-ledger","tag-gl-source-journal","tag-sage-300-erp","tag-sage-accpac-erp","tag-source-journal-profile","tag-source-journal-reports"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Source Journal Profile in Sage 300 ERP<\/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\/2013\/01\/31\/source-journal-profile-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=\"Source Journal Profile in Sage 300 ERP\" \/>\n<meta property=\"og:description\" content=\"In Sage 300 ERP (formerly known as Sage Accpac ERP) has a distinctive feature known as Source Journal Profile in GL, which can be used by User to configure their Source Journals Reports. Say for an example, \u00a0Users want to view Total Cash In or Payment that he has received, then in Source Journal Profile\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-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-01-31T09:33:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-18T09:49:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png\" \/>\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=\"4 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\/01\/31\/source-journal-profile-in-sage-300-erp\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/\",\"name\":\"Source Journal Profile in Sage 300 ERP\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png\",\"datePublished\":\"2013-01-31T09:33:39+00:00\",\"dateModified\":\"2024-12-18T09:49:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Source Journal Profile in 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":"Source Journal Profile in Sage 300 ERP","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\/01\/31\/source-journal-profile-in-sage-300-erp\/","og_locale":"en_US","og_type":"article","og_title":"Source Journal Profile in Sage 300 ERP","og_description":"In Sage 300 ERP (formerly known as Sage Accpac ERP) has a distinctive feature known as Source Journal Profile in GL, which can be used by User to configure their Source Journals Reports. Say for an example, \u00a0Users want to view Total Cash In or Payment that he has received, then in Source Journal Profile\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2013-01-31T09:33:39+00:00","article_modified_time":"2024-12-18T09:49:00+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/","name":"Source Journal Profile in Sage 300 ERP","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png","datePublished":"2013-01-31T09:33:39+00:00","dateModified":"2024-12-18T09:49:00+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/01\/1.-GL-Source-Journal-Profiles.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/01\/31\/source-journal-profile-in-sage-300-erp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Source Journal Profile in 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\/2454","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=2454"}],"version-history":[{"count":1,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2454\/revisions"}],"predecessor-version":[{"id":35476,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/2454\/revisions\/35476"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=2454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=2454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=2454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}