RKL eSolutions Blog Trends and Insights

Sage ERP X3 Table Is Full Error in Payment Proposals

If you process Payment Proposals in Sage ERP X3, there are a variety of dimensions that govern the number of lines that can be included in a single payment generation. If the payments that meet your filter criteria exceed these numbers, you will receive errors. We will outline here what you can do for Sage ERP X3 table is full error in payment proposals.

Table is full error

Full Error

Log file record

Error Log

Activity Codes

Most errors like this in Sage ERP X3 involve setting the screen dimension value on the appropriate activity codes. PAY and PYL are the activity codes that govern the payment screen. However, we increased the dimension value on these 2 activity codes as shown below and ran a dictionary validation, but the Table Is Full error persisted.

Activity Code

Activity Code

Then we discovered the payment proposal screen has a hard-coded line limit. If you run A/P-A/R Accounting > Payments > Payment Proposals task and set the Control flag on the parameter screen, it utilizes the PAYPROCTL screen:

Payment Proposals

Adjust Screen Line

To resolve the Table Is Full error, go to the design of the PAYPROCTL screen and increase the Line value to something more than the default 300. Save and validate the screen and re-run the Payment Proposal.

Screen

In Summary

The bad news is you have some work to do. The great news is the SAFE X3 Framework provides you the ability to personalize this to meet your exact needs.

We're Here to Help

Need Help Figuring It All Out? Contact Us with any questions about upgrading, updating, integrating, and everything in between!

[jbutton color="green" size="medium" link="http://www.rklesolutions.com/contact-us/"]Contact RKL eSolutions  >>>[/jbutton]



Tags: Sage X3
Cliff Horst

Written by Cliff Horst

Cliff Horst is the VP Application Support at RKL eSolutions with an expertise in SQL Server, Crystal Reports, Sage 500, Sage X3, and KnowledgeSync.