Topic: Error System and General GL Setup

I added a new fiscal year for 2018 and entered System and General GL Setup and made a very simple adjustment and found this message when updating

"The Retained Earnings Account should be a Balance Account or the Profit and Loss Year Account should be an Expense Account (preferred the last one in the Expense Class)"

What is the solution I have tried over and over and have not found a solution

Re: Error System and General GL Setup

The Retained Earnings Account and the Profit and Loss Account must exist in your chart_master table with the correct chart_type - see the sql/en_US-new.sql file for parallels and adjust your Chart accordingly.

Setup => System and General GL Setup must have the Retained Earnings and the Profit/Loss Year accounts set properly.

Post's attachments

RE_PL.png 72.5 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

Re: Error System and General GL Setup

The problem is that this chart has been added from the system itself via inst_chart

Arabic Egypt 8 digits COA - GAAP

Re: Error System and General GL Setup

That chart is probably old and not updated correctly. Take an updated one from the FA24extensions repo depending on if you are using the English or Arabic one.

Read the wiki, search the forum and experience the code - live and learn.

Re: Error System and General GL Setup

Thank you apmuthu oh great

After entering the FAPO FA24extensions and downloading and updating the Charts

chart_en_EG-GAAP
chart_en_EG-general
chart_en_EG-english

The same problem

Re: Error System and General GL Setup

Just downloading the charts and overwriting the counterparts in the sql folder is good only for new companies created with them. The old companies created with the erroneous charts must be synched in schema and appropriately migrated to the new one. Just make one company with the en_US-new.sql and compare the schema with your older companies and synch the latter.