Error: “Too Many Tables open” in Sage X3

By | May 26, 2021

Sometimes In sage X3, Developers can do customization within sage x3 using development module and in that they need to open some tables to do some customization in sales quote or sales order or delivery as well as in sales invoice or any sage x3 module.

Sometimes we need to follow sequential operation means first we create sales quote then we create sales order from that sales quote then we need to create transaction from delivery screen then we create invoice for that delivery. In this case, At a time three to four screens like sales order, sales quote, sales delivery and sales invoice. When we open the screen, Standard opens their standard tables for sales quote, sales order, delivery and sales invoice so standard automatically creates invoice using that open tables. These tables will close only when we close those screens.

 So, in this situation sometimes we face an error like “Too many tables open” as shown in figure 1 and stopped the working of standard and crashes the screen. This error arises when a number of tables are opened at a time and not closed ahead. This is a standard error that which occurred when standard finds that many tables are opened.

Fig 1: Error message

To solve this error, we need to follow following steps:

  1. Follow the below path to open the Folders screen to solve this error.
           
    Setup > General parameters > Folders

        In the setup module, In general parameters open the folder generation screen.

  • Go to the Miscellaneous tab and change the value of open tables.

In Folder generation go to the Miscellaneous tab. In the miscellaneous tab there is a field named as ‘Open tables’ as shown in figure 2.

Fig 2 : Open tables field in folder generation screen

We have to increase the value of open tables to solve this error. Just we need to increase the value of open tables and save it. We do not need to do the folder validation. Only you need to save it. When you save it populates one message that is File APL.ini modified as shown in figure 3. It means changes are reflected and saved properly.

Fig 3: Changes in open table field and saved

Now If we follow same procedure to create sales invoice through sales quotes, sales order and delivery sequentially then it does not show any error because now we have increased the value of open tables so at a time that number of tables which is shown in open table field that number of tables can be open at a time. In figure 2 . Value of open tables are 300 so standard can allow 300 tables to be opened at a time.

In this way, by doing above steps we can solve this error.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged 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 competence. 

Greytrix caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. 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 and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.