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 confirmed if the transaction is being created for an open period/open Fiscal Year.

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.

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

If [M:XXX0]ACCDATE <> [0/0/0] Call CONTPER (VALEUR, [M: XXX0] LEDTYP, [M: XXX0] FCY) From CPTSUB
Endif
In the above code snippet the parameters for the sub program are mentioned below:
VALEUR = Date Value
LEDTYP= Ledger Type
FCY= Site

Now if you select an invalid transaction date, i.e. Transaction Date of the Period/Year which is closed, you would receive message stating “Period Not Open”/ “Fiscal Year Closed”.

This 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.

Hope this single line of code will help you in solving a big problem.
Stay tuned for more tips and tricks on Sage X3 programming.
Happy and SafeX3 Coding!!!

About Us
Greytrix – 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.

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

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.