{"id":324,"date":"2012-04-19T08:52:43","date_gmt":"2012-04-19T08:52:43","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=324"},"modified":"2018-09-03T06:01:16","modified_gmt":"2018-09-03T06:01:16","slug":"calculation-part-of-financial-data-extraction","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2012\/04\/19\/calculation-part-of-financial-data-extraction\/","title":{"rendered":"Calculation Part of Financial Data Extraction"},"content":{"rendered":"<p>We have already set up an FDE in X3 we will proceed a step further i.e. to be acquainted about the Calculation part of the FDE. The below article will help you in getting an idea regarding the FDE Calculation.<\/p>\n<p><span style=\"color: #c71d22; font-size: 13pt;\"><strong>FDE Calculation<\/strong><\/span><\/p>\n<p><strong>Function Path:\u00a0\u00a0<\/strong> <strong>Financials &gt;\u00a0Reporting &gt; Financial Data Extraction &gt;\u00a0Calculation<\/strong><br \/>\nAs the name suggest this functionality will let us calculate or update the calculation of a group of tables. The parameters are entered through a single screen based on selected Report Group.<\/p>\n<p>The screen is divided into five sections:<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Selection section<\/li>\n<li>Generation section<\/li>\n<li>List section<\/li>\n<li>Parameter section<\/li>\n<li>Variables section<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2012\/04\/Image1-FDE-Calc1.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-325\" src=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2012\/04\/Image1-FDE-Calc1.jpg\" alt=\"\" width=\"688\" height=\"357\" \/><\/a><\/p>\n<ol>\n<li><strong>Selection section:<br \/>\n<\/strong>Report group: It is Field for the selection of the financial data extractions to be calculated. The selection can take place for a group, or several groups. In this case, it is necessary to leave the Report group field blank.<\/li>\n<li><strong>Generation section:\u00a0<\/strong>This section is based on versioning of the FDE Calculations.<br \/>\n\u201cAutomatic Version\u201d &#8211; Auto versioning of calculations is possible through this check box if checked <strong>or<\/strong> manual version entry can also be done by entering value in \u201cNew Version\u201d.<br \/>\nIt is possible to recalculate FDE\u2019s while keeping all the original parameters and to apply a shift only in terms of months. With this it is possible to automate the process of printing the monthly financial data extractions by avoiding entry of parameters.<\/li>\n<li><strong>List section:\u00a0<\/strong>The Table column presents all the tables making up the group as well as the version number to be generated if the information concerning said number has been modified manual or automatic version number.<br \/>\nSimply, it shows all (or selected Extraction codes) of selected Report Group. The extraction codes are shown under column \u201cGrid\u201d.<strong>\u00a0<\/strong><\/li>\n<li><strong>Parameters section: <\/strong>For each Extraction code in the list, the user needs to put in list of required parameters.<strong>\u00a0<\/strong><\/li>\n<li><strong>Variables section: <\/strong><br \/>\nThe values replaced by the variables can be entered in this last section. If the variable is controlled by a data type, a check will be performed on its existence.<strong>\u00a0<\/strong><\/li>\n<\/ol>\n<p><span style=\"color: #c71d22; font-size: 13pt;\"><strong>Batch Task Feature<\/strong><\/span><\/p>\n<p>The FDE Calculation function can be executed in batch mode, but no dedicated standard task is delivered to execute it. For that purpose, new Batch Task needs to be created by navigating Usage &gt; Batch server &gt; Task Management<br \/>\nNo print or inquiry is linked to FDE Calculation function. For that purpose, the FDE inquiry function is used.<br \/>\nThis blog will be further continued with the illustration of how an FDE can be used for inquiry of the financial statements.<\/p>\n<p><span style=\"font-size: Medium;\"><strong>About Us<\/strong><\/span><br \/>\n<a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a> \u2013 a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.<\/p>\n<p><a href=\"https:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our\u00a0unique GUMU&#x2122; integrations include <a href=\"https:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-x3-integration\">Sage Enterprise Management (Sage X3) for Sage CRM<\/a>,\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/gumu-x3-salesforce-integration\">Salesforce.com<\/a> and\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/magento-sage-integrations\/sage-x3-magento\">Magento eCommerce<\/a>\u00a0along with Implementation and Technical Support worldwide for <a href=\"https:\/\/www.greytrix.com\/africa\/product\/consulting\/implementation-planning\">Sage Enterprise Management (Sage X3)<\/a>. Currently we are <a href=\"https:\/\/www.greytrix.com\/africa\">Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia.\u00a0We also offer best-in-class\u00a0<a href=\"https:\/\/www.greytrix.com\/product\/erp-development\/sage-x3\">Sage X3 customization and development services<\/a>,\u00a0integrated applications such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/pos-system\">POS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/warehouse-management-system\">WMS<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/payment-gateway\">Payment Gateway<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/shipping-system\">Shipping System<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-integration-services\/business-intelligence\">Business Intelligence<\/a> | <a href=\"https:\/\/www.greytrix.com\/product\/sage-x3\/ecommerce-magento-integration\">eCommerce<\/a> and have developed add-ons such as <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/catch-weight\">Catch \u2013 Weight <\/a>\u00a0and <a href=\"https:\/\/www.greytrix.com\/product\/sage-enterprise-management-add-ons\/letter-of-credit\">Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n<p>Greytrix is a recognized <a href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2017\/07\/26\/greytrix-on-boards-sage-global-rockstar-isv-program-with-gumu-for-sage-crm-sage-x3-solution\/\">Sage Rockstar ISV Partner<\/a> for GUMU&#x2122; Sage Enterprise Management \u2013 Sage CRM integration also listed on <a href=\"https:\/\/www.sage.com\/marketplace\/asb_ListingDetail?listingId=a1h24000007PC3aAAG\" target=\"_blank\" rel=\"noopener\">Sage Marketplace<\/a>; GUMU&#x2122; integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on <a href=\"https:\/\/appexchange.salesforce.com\/listingDetail?listingId=a0N30000000psM5EAI\" target=\"_blank\" rel=\"noopener\">Salesforce AppExchange<\/a>.<\/p>\n<p>For more information on Sage X3 Integration and Services, please contact us at\u00a0<a href=\"mailto:x3@greytrix.com\">x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have already set up an FDE in X3 we will proceed a step further i.e. to be acquainted about the Calculation part of the FDE. The below article will help you in getting an idea regarding the FDE Calculation. FDE Calculation Function Path:\u00a0\u00a0 Financials &gt;\u00a0Reporting &gt; Financial Data Extraction &gt;\u00a0Calculation As the name suggest\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sagex3\/2012\/04\/19\/calculation-part-of-financial-data-extraction\/\">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":[8],"tags":[245,788],"class_list":["post-324","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","tag-calculation","tag-fde"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=324"}],"version-history":[{"count":3,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/324\/revisions"}],"predecessor-version":[{"id":15560,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/324\/revisions\/15560"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}