{"id":41,"date":"2023-04-06T11:54:41","date_gmt":"2023-04-06T11:54:41","guid":{"rendered":"https:\/\/senortalks.co.uk\/?p=41"},"modified":"2023-04-25T10:11:04","modified_gmt":"2023-04-25T10:11:04","slug":"summarize-multiple-expense-report-lines-into-a-single-payables-line-in-vendor-transactions","status":"publish","type":"post","link":"https:\/\/senortalks.co.uk\/?p=41","title":{"rendered":"Summarize multiple expense report lines into a single payables line in vendor transactions"},"content":{"rendered":"\n<p>Good morning Readers!<\/p>\n\n\n\n<p>I was recently demonstrating how an employee can log his expense reports in Microsoft Dynamics 365 Finance and had created multiple expense lines like hotel, car rental, meals and I processed the expense report by posting it as a vendor payable transaction. I was expecting a single line in the vendor transactions for the total amount that is payable to the vendor for his entire expense report\/trip. However, I could see that there were multiple vendor transaction lines created, one line for each expense line. This was not ideal for the customer at the other end of my demo and they objected that this would cause unnecessary reconciliation issues.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"430\" src=\"https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport01-1024x430.jpg\" alt=\"\" class=\"wp-image-42\" srcset=\"https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport01-1024x430.jpg 1024w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport01-300x126.jpg 300w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport01-768x322.jpg 768w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport01-1536x645.jpg 1536w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport01.jpg 1854w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>I could understand their predicament and after checking the expense parameters, I found a flag that when turned on will summarize all expense lines into a single vendor transaction in the Accounts Payable \/ Purchase ledger module. My customer was happy with the outcome!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"449\" src=\"https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport02-1024x449.jpg\" alt=\"\" class=\"wp-image-43\" srcset=\"https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport02-1024x449.jpg 1024w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport02-300x132.jpg 300w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport02-768x337.jpg 768w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport02-1536x674.jpg 1536w, https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/040623_ExpenseReport02.jpg 1718w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Hope you find this quick tip helpful, Cheers!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quick tip on how to summarize multiple expense lines into a single vendor payable transaction line<\/p>\n","protected":false},"author":3,"featured_media":45,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[2],"tags":[3,4,6,5,8,7],"jetpack_featured_media_url":"https:\/\/senortalks.co.uk\/wp-content\/uploads\/2023\/04\/pexels-karolina-grabowska-5900134-scaled.jpg","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/41"}],"collection":[{"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=41"}],"version-history":[{"count":2,"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions"}],"predecessor-version":[{"id":46,"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/41\/revisions\/46"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=\/wp\/v2\/media\/45"}],"wp:attachment":[{"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=41"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=41"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/senortalks.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=41"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}