{"id":2105,"date":"2014-08-19T10:08:00","date_gmt":"2014-08-19T10:08:00","guid":{"rendered":"https:\/\/www.dab-europe.com\/\/articles\/grouping-sap-fi-vendor-line-items\/"},"modified":"2025-03-11T12:31:15","modified_gmt":"2025-03-11T12:31:15","slug":"grouping-sap-fi-vendor-line-items","status":"publish","type":"articles","link":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/","title":{"rendered":"Grouping SAP\u00ae FI vendor line items"},"content":{"rendered":"<h2>Grouping SAP\u00ae FI vendor line items<\/h2>\n<p class=\"align-justify\">Today I will give you a little hint which will make it easier for you to navigate in long lists of SAP\u00ae vendor financial transactions.<\/p>\n<p class=\"align-justify\">A common SAP\u00ae transaction code is \u201cFBL1n\u201d. It allows you to display financial vendor line items in a list.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_01.png\" \/><\/p>\n<p class=\"align-justify\">You can restrict that list by several parameters, for example to list only open, or only cleared or all items for a certain vendor. You can limit the list according to a certain vendor, time range or company code as well.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_02.png\" \/><\/p>\n<p class=\"align-justify\">When listing \u201cAll items\u201d for an important vendor, the list display can get a little bit confusing: As it contains a wide range of different transaction types, like for example invoices, credit notes or payments, it is difficult to tell at a glance which transactions belong together &#8211; especially if it is more complex than a \u201cOne invoice \u2013 One outgoing payment\u201d scenario.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_03.png\" \/><\/p>\n<p class=\"align-justify\">The trick is to go to the menu bar at \u201eEnvironment\u201c  and select \u201eClearing transactions\u201c:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_04.png\" \/><\/p>\n<p class=\"align-justify\">This option now restructures the list, making it a bit easier on the eyes, as business transactions which are linked are grouped together.  The \u201cOne invoice \u2013 One outgoing payment\u201d scenarios can be spotted at a glance as highlighted in the following screenshot\u2026<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_05.png\" \/><\/p>\n<p class=\"align-justify\">\u2026 but also more complex constellations can be identified \u2013 and understood \u2013 a lot easier, for example the following group of five transactions, which consists of three invoices and two payments.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_06.png\" \/><\/p>\n<p class=\"align-justify\">We probably would have expected to find this in two different groups: The first one containing the invoice and payment of 31k Euros, the second group containing the two invoices (4k+5k) and the one payment of 9k.<\/p>\n<p class=\"align-justify\">Double-clicking allows us to drill down into the transactions. It shows that the three invoices AND one manual payment of 31k Euros have been cleared by a outgoing payment run transaction of 9k on 27th of October:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_07.png\" \/><\/p>\n<p class=\"align-justify\">This is the first payment, probably a down payment. It was entered manually using T-Code FB01, and not initiated by the automated payment run, which would have been T-Code F110. Let\u2019s compare it to the final clearing transaction:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.dab-europe.com\/\/wp-content\/uploads\/Publ\/cD\/20140820_grouping-FI-vendor-line-items_D_08.png\" \/><span style=\"text-align: justify;\">This is the second payment, which has been performed by the automated payment run. Only by this transaction, all four predecessors (3 invoices minus 1 potential manual down payment) were finally cleared.<\/span><br \/>\n<span style=\"text-align: justify;\">Without grouping the line items, constellations like that are hard to spot. If you have not been aware of this menu option before, it will make your SAP\u00ae data analytic life a lot easier when looking at financial transactions for vendors.<\/span><br \/>\n<span style=\"text-align: justify;\">By the way, the topic of \u201cManual Payments\u201d is an interesting one! I will have a more detailed look at it later on this year.<\/span><br \/>\n<span style=\"text-align: justify;\">For any comments on this article, feel free to write us at&nbsp;<\/span><span style=\"text-align: justify;\"><a href=\"mailto:info@dab-gmbh.de\">info@dab-gmbh.de<\/a><\/span><span style=\"text-align: justify;\">&nbsp;<\/span><\/p>\n<p class=\"align-justify\">To contact the author you can also use LinkedIn or XING (you may have to login first before you can access these links). <\/p>\n<p class=\"align-justify\">LinkedIn: <a target=\"_blank\" href=\"http:\/\/de.linkedin.com\/pub\/stefan-wenig\/54\/1b8\/b30\" rel=\"noopener\">http:\/\/de.linkedin.com\/pub\/stefan-wenig\/54\/1b8\/b30<\/a> <\/p>\n<p class=\"align-justify\">XING: <a target=\"_blank\" href=\"https:\/\/www.xing.com\/profile\/Stefan_Wenig2?sc_o=mxb_p\" rel=\"noopener\">https:\/\/www.xing.com\/profile\/Stefan_Wenig2?sc_o=mxb_p<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Grouping SAP\u00ae FI vendor line items Today I will give you a little hint which will make it easier for you to navigate in long lists of SAP\u00ae vendor financial transactions. A common SAP\u00ae transaction code is \u201cFBL1n\u201d. It allows you to display financial vendor line items in a list. You can restrict that list [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":4678,"template":"","articles_category":[],"articles_tag":[92],"class_list":["post-2105","articles","type-articles","status-publish","has-post-thumbnail","hentry","articles_tag-sap"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Grouping of the SAP supplier line item list<\/title>\n<meta name=\"description\" content=\"Efficient grouping of SAP supplier line item lists \u2713 Clear guidance &amp; tips \u2713 Optimized &amp; manageable processes \u2013 Learn more now!\" \/>\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.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Grouping of the SAP supplier line item list\" \/>\n<meta property=\"og:description\" content=\"Efficient grouping of SAP supplier line item lists \u2713 Clear guidance &amp; tips \u2713 Optimized &amp; manageable processes \u2013 Learn more now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/\" \/>\n<meta property=\"og:site_name\" content=\"dab\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-11T12:31:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2024\/06\/G19A7112-1024x683.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"683\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/\",\"name\":\"Grouping of the SAP supplier line item list\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/G19A7112-scaled.jpg\",\"datePublished\":\"2014-08-19T10:08:00+00:00\",\"dateModified\":\"2025-03-11T12:31:15+00:00\",\"description\":\"Efficient grouping of SAP supplier line item lists \u2713 Clear guidance & tips \u2713 Optimized & manageable processes \u2013 Learn more now!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/G19A7112-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/G19A7112-scaled.jpg\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/grouping-sap-fi-vendor-line-items\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Grouping SAP\u00ae FI vendor line items\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"name\":\"dab\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#organization\",\"name\":\"dab\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"contentUrl\":\"https:\\\/\\\/www.dab-europe.com\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/dab_logo-main-color-scaled.png\",\"width\":2560,\"height\":1463,\"caption\":\"dab\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dab-europe.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Grouping of the SAP supplier line item list","description":"Efficient grouping of SAP supplier line item lists \u2713 Clear guidance & tips \u2713 Optimized & manageable processes \u2013 Learn more now!","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.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/","og_locale":"en_US","og_type":"article","og_title":"Grouping of the SAP supplier line item list","og_description":"Efficient grouping of SAP supplier line item lists \u2713 Clear guidance & tips \u2713 Optimized & manageable processes \u2013 Learn more now!","og_url":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/","og_site_name":"dab","article_modified_time":"2025-03-11T12:31:15+00:00","og_image":[{"width":1024,"height":683,"url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2024\/06\/G19A7112-1024x683.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/","url":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/","name":"Grouping of the SAP supplier line item list","isPartOf":{"@id":"https:\/\/www.dab-europe.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/#primaryimage"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2024\/06\/G19A7112-scaled.jpg","datePublished":"2014-08-19T10:08:00+00:00","dateModified":"2025-03-11T12:31:15+00:00","description":"Efficient grouping of SAP supplier line item lists \u2713 Clear guidance & tips \u2713 Optimized & manageable processes \u2013 Learn more now!","breadcrumb":{"@id":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/#primaryimage","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2024\/06\/G19A7112-scaled.jpg","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2024\/06\/G19A7112-scaled.jpg","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/www.dab-europe.com\/en\/articles\/grouping-sap-fi-vendor-line-items\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dab-europe.com\/en\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/www.dab-europe.com\/en\/articles\/"},{"@type":"ListItem","position":3,"name":"Grouping SAP\u00ae FI vendor line items"}]},{"@type":"WebSite","@id":"https:\/\/www.dab-europe.com\/en\/#website","url":"https:\/\/www.dab-europe.com\/en\/","name":"dab","description":"","publisher":{"@id":"https:\/\/www.dab-europe.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dab-europe.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dab-europe.com\/en\/#organization","name":"dab","url":"https:\/\/www.dab-europe.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","contentUrl":"https:\/\/www.dab-europe.com\/wp-content\/uploads\/2025\/02\/dab_logo-main-color-scaled.png","width":2560,"height":1463,"caption":"dab"},"image":{"@id":"https:\/\/www.dab-europe.com\/en\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles\/2105","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles"}],"about":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/types\/articles"}],"author":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/users\/2"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media\/4678"}],"wp:attachment":[{"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/media?parent=2105"}],"wp:term":[{"taxonomy":"articles_category","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_category?post=2105"},{"taxonomy":"articles_tag","embeddable":true,"href":"https:\/\/www.dab-europe.com\/en\/wp-json\/wp\/v2\/articles_tag?post=2105"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}