{"id":114,"date":"2012-02-01T12:19:08","date_gmt":"2012-02-01T12:19:08","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=114"},"modified":"2023-10-04T11:07:24","modified_gmt":"2023-10-04T11:07:24","slug":"check-validity-of-an-accounting-period-in-sage-erp-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2012\/02\/01\/check-validity-of-an-accounting-period-in-sage-erp-x3\/","title":{"rendered":"Check Validity of an Accounting Period in Sage ERP X3"},"content":{"rendered":"

As an ERP user it is quiet mandatory that whenever we do any accounting transaction, it should be carried in Open Fiscal Year\/Open Period.<\/p>\n

Now if we design a custom screen that deals with financial transactions in Sage X3, it should check for the validity of transaction date. In other words, it needs to be confirmed if the transaction is being created for an open period\/open Fiscal Year.<\/p>\n

The Validation of this Accounting date may be difficult as we need to check for all the possible conditions which can make this date valid.<\/p>\n

But in Sage X3 this minor but vital task can be done by calling an inbuilt method. Please refer the below given code snippet:<\/p>\n

If [M:XXX0]ACCDATE <> [0\/0\/0]\nCall CONTPER (VALEUR, [M: XXX0] LEDTYP, [M: XXX0] FCY) From CPTSUB
\nEndif
\nIn the above code snippet the parameters for the sub program are mentioned below:
\nVALEUR = Date Value
\nLEDTYP= Ledger Type
\nFCY= Site<\/p>\n

Now if you select an invalid transaction date, i.e. Transaction Date of the Period\/Year which is closed, you would receive message stating \u201cPeriod Not Open\u201d\/ \u201cFiscal Year Closed\u201d.
\n\"\"<\/a>
\nThis snippet can be added as per the technical requirement of your system. Once the Error is logged you can make the MKSTAT = 2 so that the focus remains on the error field itself.<\/p>\n

Hope this single line of code will help you in solving a big problem.
\nStay tuned for more tips and tricks on Sage X3 programming.
\nHappy and SafeX3<\/strong> Coding!!!<\/p>\n

About Us<\/strong><\/span>
\nGreytrix<\/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

Greytrix<\/a> caters to a wide range of Sage Enterprise Management (Sage X3) offerings \u2013 a Sage Business Cloud Solution. Our unique GUMU\u2122 integrations include Sage Enterprise Management (Sage X3) for Sage CRM<\/a>, Salesforce.com<\/a> and Magento eCommerce<\/a> along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3)<\/a>. Currently we are Sage Enterprise Management Implementation Partner<\/a> in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services<\/a>, integrated applications such as POS<\/a> | WMS<\/a> | Payment Gateway<\/a> | Shipping System<\/a> | Business Intelligence<\/a> | eCommerce<\/a> and have developed add-ons such as Catch \u2013 Weight <\/a> and Letter of Credit<\/a> for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.<\/p>\n

Greytrix is a recognized Sage Rockstar ISV Partner<\/a> for GUMU\u2122 Sage Enterprise Management \u2013 Sage CRM integration also listed on Sage Marketplace<\/a>; GUMU\u2122 integration for Sage Enterprise Management \u2013 Salesforce is a 5-star app listed on Salesforce AppExchange<\/a>.<\/p>\n

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

As an ERP user it is quiet mandatory that whenever we do any accounting transaction, it should be carried in Open Fiscal Year\/Open Period. Now if we design a custom screen that deals with financial transactions in Sage X3, it should check for the validity of transaction date. In other words, it needs to be\u2026 Read More »<\/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,11],"tags":[476,832,1465,2020,2451],"class_list":["post-114","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-tips","tag-custom","tag-fiscal","tag-period","tag-screen","tag-year"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/114","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=114"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/114\/revisions"}],"predecessor-version":[{"id":27528,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/114\/revisions\/27528"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}