• From: Saudi Arabia
  • Registered: 10/07/2017
  • Posts: 67

Topic: I want to export a chart

I have a FA program and I want to export a chart of it how are you? Via phpmyadmin What are the names of the tables or the correct method that does not cause problems when working to have a transplant in another FA account

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

Re: I want to export a chart

You can export charts with he!p of below tables.

0_chart_class
0_chart_master
0_chart_types

These three tables are enough to export chart of accounts to other FA.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Saudi Arabia
  • Registered: 10/07/2017
  • Posts: 67

Re: I want to export a chart

Thank you very kvvaradha you are a great programmer

Ok and how to export data stored in "System and General GL Setup"

  • cleal
  • cleal
  • Senior Member
  • Offline
  • From: Guatemala
  • Registered: 10/25/2018
  • Posts: 50

Re: I want to export a chart

I think you need, attachments, bank_accounts, bank_trans, comments, dimensions, gl_trans and journal

cleal

cleal's Website

  • From: Saudi Arabia
  • Registered: 10/07/2017
  • Posts: 67

Re: I want to export a chart

There are no records as mentioned, there is no need for them
thanks

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: I want to export a chart

sys_prefs

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • cleal
  • cleal
  • Senior Member
  • Offline
  • From: Guatemala
  • Registered: 10/25/2018
  • Posts: 50

Re: I want to export a chart

fiscal_year

cleal

cleal's Website

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,181

Re: I want to export a chart

@king1984 - If you goto "System and General GL Setup" , there are some predefined or used existing COA here. So when you edit the COA, and the code changed. the system GL can't get right value. 

So once you modify the above tables. manually you need to setup the "System and General GL Setup" accounts once again. IF you go with programmatic, It wil be harder and more complex.  manual and simple to adapt it.

hope it helps you .

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • From: Saudi Arabia
  • Registered: 10/07/2017
  • Posts: 67

Re: I want to export a chart

kvvaradha wrote:

@king1984 - If you goto "System and General GL Setup" , there are some predefined or used existing COA here. So when you edit the COA, and the code changed. the system GL can't get right value. 

So once you modify the above tables. manually you need to setup the "System and General GL Setup" accounts once again. IF you go with programmatic, It wil be harder and more complex.  manual and simple to adapt it.

hope it helps you .

I took steps and set "System and General GL Setup" but noticed that in add items I find GL Accounts data not changing to the default data that you set in "System and General GL Setup"

As in the picture http://prntscr.com/ljhrg2

What is the problem if you allow ??

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: I want to export a chart

Items get their default accounts from Items &Inventory -> Item Categories - its in the wiki

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Saudi Arabia
  • Registered: 10/07/2017
  • Posts: 67

Re: I want to export a chart

Thank you my dear

I have another question I do not know needs to create a new topic or not

In the "Customer Payment Entry" screen with the "Into Bank Account" field, I want to change the name "petty cash"

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: I want to export a chart

Yes new topic would be better..any further unrelated questions, please ask in the relevant forum.

But as you've already asked it...

Go to Banking and General Ledger -> Bank Accounts, you can add as many account as you require and define your 'default' account.

FA takes a little time to learn, you will need to read - to learn how to use the program and get the best out of the program. This investment in time will be repaid when you see how much time FA can actually save you
Clicking help in the top right corner of any page of the program will take you to the relevant wiki page.
The wiki contains most of the info you will need to know, most of the rest you can find in this forum.

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Saudi Arabia
  • Registered: 10/07/2017
  • Posts: 67

Re: I want to export a chart

Thank you for your help

I want to remove the "petty cash" record that I did not find in the bank accounts list

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 627

Re: I want to export a chart

Please send a screenshot of your bank accounts page

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/