How to Solve error ”Outside of validity date limit” in Journal Entries

By | April 14, 2021

In Sage X3, any transaction that impacts a company’s profit and loss needs to be recorded in their accounting system is called ‘Journal Entries’.

        A journal entry is used to record a business transaction in the accounting records of a business. A journal entry is usually recorded in the general ledger; alternatively, it may be recorded in a subsidiary ledger that is then summarized and rolled forward into the general ledger.

        In Sage X3, all documents such as Purchase Invoice, Sales Invoice, Shipment, etc. are coded to ‘automatic journals’, thus creating journal entries automatically when the documents are validated. Each document is coded to specific accounts in the ‘automatic journal’ setup, thereby posting the entries in the desired accounts during a transaction. However, these entries are posted in the ‘temporary’ mode which allows the user to modify the entry in terms of accounts, business partner, amount and description fields, before it is changed to ‘final’ during final validation.

        When the status is Temporary, journals can be deleted or modified, but journals generated in other modules are subject to consistency checks. Once the status is Final, some accounting elements included in a journal can no longer be modified.

        Depending on the setup of the transaction and journal type used, the following elements can be specified in journal entry:

  • Purely analytical journals
  • General and analytical journals
  • IAS documents, etc.

STEPS :-

Navigate to:  Financials -> Journals -> Journal Entry

  • Open the Journal Entry screen from Financials > Journals > Journal Entry
  • Click the New button to open a blank entry
  • Select a Site (defined as a financial site)
  • Select an Entry Type from the list according to the nature of the transaction. Each type is loaded with its required settings.
  • The Number field will be automatically generated by X3 when the document is created.
  • Select the accounting Date of posting this entry.

  Here, we can see that we are facing the below issue while creating journal entry. Refer the below figure:

Follow the steps given below to solve this error:-

 Navigate To: All -> Setup -> Financial  -> Journal Entry Transaction

As we are creating journal entry for STDCO transaction, Select the same transaction in entry transaction screen. 

Fig02: Journal Entry Transaction Screen

Here, we can see that the value in the field Validity End date is set to ’04/12/20′,  that means the validity of this transaction is valid only till 2020, but we are creating the transaction for 2021 so we are facing the error. Refer the below figure.        

We need to change the ‘Validity end date‘, till which date we want for the particular entry transaction of the Journal Entry.

So here we are changing the value to 12/31/21. Save and validate the same entry transaction.

Fig03: Validity end date

Hence, our journal entry has been created successfully. Refer the below screen shot

Fig04: Journal Entry Screen

This blog helps to solve the error “Outside of validity date limit ” while creating journal entry.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.