{"id":28180,"date":"2020-05-17T16:12:54","date_gmt":"2020-05-17T16:12:54","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=28180"},"modified":"2024-05-06T05:01:48","modified_gmt":"2024-05-06T05:01:48","slug":"expense-report","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/","title":{"rendered":"Expense Report"},"content":{"rendered":"\n<p>In this blog, we are going to\ndiscuss about the new custom \u201cExpense Report\u201d which we have developed for one\nof our customers. This report helps in maintaining the actual and projection\ncosting for required inventory in our ERP System.<\/p>\n\n\n\n<p>The purpose of this customization\nis to store the Projection Expenses and fetch Actual Expenses from AP Invoice\ntransactions. Based on this the User can calculate the final Margin i.e.:\n&#8216;Gross Margin&#8217; and meet their business aspects.<\/p>\n\n\n\n<p>The user interface for \u201c\u201cExpense\nReport\u201d is as displayed below. The report data will be produced as an MS-excel\nexported file based on the user-specified Order entry range. This order number\nwill be mapped into the optional field from Account Payable Invoice screen for\nthe transaction reference purpose.<\/p>\n\n\n\n<p>Please refer the screenshot of the user interfaces for \u201cExpense Report\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"463\" height=\"164\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png\" alt=\"Report\" class=\"wp-image-28181\" title=\"Report\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png 463w, https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI-300x106.png 300w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/figure>\n\n\n\n<p>As\nyou can see in above screenshot user will be able to specify \u2018From\u2019 and \u2018To\u2019\nOrder number and report will get generated based on the selected Order number. <\/p>\n\n\n\n<p>Once user clicks on the Export button, a prompt will be displayed to select the path where reports needs to be exported. The report will get generated and will consist data of Order, AP invoice expenses (actual and projection) <\/p>\n\n\n\n<p>We have maintained two rows in the report for expense tracking  purpose. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Actual<\/strong>&#8211; this will be\ntransaction-level data \/ Expenses from AP invoice Screen. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Projection<\/strong>&#8211; We have maintained custom table to store the Projection expenses.<\/li>\n<\/ul>\n\n\n\n<p>Below is the excel-based generated output of expense report along with mapping of the some fields.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" width=\"1024\" height=\"102\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/OP-1024x102.png\" alt=\"Report\" class=\"wp-image-28182\" style=\"width:759px;height:75px\" title=\"Report\" srcset=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/OP-1024x102.png 1024w, https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/OP-300x30.png 300w, https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/OP-768x77.png 768w, https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/OP-660x66.png 660w, https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/OP.png 1305w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>So Number<\/strong>:- this will be the header level Order number field from the OE order entry screen and based on the same, the report will get export. <\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Customer<\/strong> <strong>name \\ number<\/strong>: &#8211; header level customer name or number field from OE order entry screen.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Item number<\/strong>: &#8211; this will be detail level selected item number field from the OE order entry screen.<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog, we are going to discuss about the new custom \u201cExpense Report\u201d which we have developed for one of our customers. This report helps in maintaining the actual and projection costing for required inventory in our ERP System. The purpose of this customization is to store the Projection Expenses and fetch Actual Expenses\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/\">Read More &raquo;<\/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":[1],"tags":[196,930,1825,2225],"class_list":["post-28180","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-ap-invoice-report","tag-expense","tag-order-entry-reports","tag-report"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Expense Statement.<\/title>\n<meta name=\"description\" content=\"Learn about the new bespoke Expense Report we created for one of our clients.\" \/>\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\/2020\/05\/17\/expense-report\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Expense Statement.\" \/>\n<meta property=\"og:description\" content=\"Learn about the new bespoke Expense Report we created for one of our clients.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-17T16:12:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-06T05:01:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.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\/2020\/05\/17\/expense-report\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/\",\"name\":\"Expense Statement.\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png\",\"datePublished\":\"2020-05-17T16:12:54+00:00\",\"dateModified\":\"2024-05-06T05:01:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2\"},\"description\":\"Learn about the new bespoke Expense Report we created for one of our clients.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png\",\"width\":463,\"height\":164},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expense Report\"}]},{\"@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":"Expense Statement.","description":"Learn about the new bespoke Expense Report we created for one of our clients.","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\/2020\/05\/17\/expense-report\/","og_locale":"en_US","og_type":"article","og_title":"Expense Statement.","og_description":"Learn about the new bespoke Expense Report we created for one of our clients.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2020-05-17T16:12:54+00:00","article_modified_time":"2024-05-06T05:01:48+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.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\/2020\/05\/17\/expense-report\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/","name":"Expense Statement.","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png","datePublished":"2020-05-17T16:12:54+00:00","dateModified":"2024-05-06T05:01:48+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/93977cd8aa8fbd1f151d3f664e29c9f2"},"description":"Learn about the new bespoke Expense Report we created for one of our clients.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2020\/05\/UI.png","width":463,"height":164},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2020\/05\/17\/expense-report\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Expense Report"}]},{"@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\/28180","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=28180"}],"version-history":[{"count":6,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/28180\/revisions"}],"predecessor-version":[{"id":34475,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/28180\/revisions\/34475"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=28180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=28180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=28180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}