• Registered: 07/23/2009
  • Posts: 14

Topic: COA Script File

This is my first contact with FA I like it I think it has a lot of potential and possibilities

If I may I will share with you some of my thoughts and suggestions

I am busy creating a scriptfile for COA for South Africa before I send ot to you I like to test is I have made all the changes in an existing scrip file (en_US_new2)
But it seems I am doing something wrong

Please explain the who the last "1" in the line below fits in with the rest or where doesit link to

INSERT INTO `0_chart_class` VALUES ('1', 'Assets', '1');

The same applies to the  Didgets after "income

INSERT INTO `0_chart_master` VALUES ('100000', '', 'Income', '101', '0');

The same applies to the last 2 didgets after the gl numbers

INSERT INTO `0_chart_types` VALUES ('101', 'GR - Income - (100000 - 149999)', '4', '1');

When I figured this out successfully I will send the script file to you to put on the
system

Regards

Gerrit

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: COA Script File

Hello,
The last value in 0_chart_class is a reference to a system defined type value (from release 2.1.3). 1 = assets, 2 = liabilities, 3 = equity, 4 = income, 5 = cost of sales, 6 = expenses.
0_chart_master: 101 is a reference (foreign key) to 0_chart_types. 0 is a value for inactivity (normal 0).
0_chart_types: 4 is a reference to the class id. 1 is a reference to another chart_type (sub-type). You can have more levels, but this is not necessary. The default value is -1.

/Joe