FrontAccounting forum — I want to export a chart

Re: I want to export a chart

null@example.com (poncho1234) — Sat, 17 Nov 2018 14:48:20 +0000

Please send a screenshot of your bank accounts page

Re: I want to export a chart

null@example.com (king1984) — Sat, 17 Nov 2018 14:43:14 +0000

Thank you for your help

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

Re: I want to export a chart

null@example.com (poncho1234) — Sat, 17 Nov 2018 13:50:02 +0000

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.

Re: I want to export a chart

null@example.com (king1984) — Sat, 17 Nov 2018 13:02:12 +0000

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"

Re: I want to export a chart

null@example.com (poncho1234) — Sat, 17 Nov 2018 12:19:19 +0000

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

Re: I want to export a chart

null@example.com (king1984) — Sat, 17 Nov 2018 12:10:15 +0000

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 ??

Re: I want to export a chart

null@example.com (kvvaradha) — Tue, 30 Oct 2018 17:38:23 +0000

@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 .

Re: I want to export a chart

null@example.com (cleal) — Tue, 30 Oct 2018 16:39:51 +0000

fiscal_year

Re: I want to export a chart

null@example.com (poncho1234) — Tue, 30 Oct 2018 16:32:08 +0000

sys_prefs

Re: I want to export a chart

null@example.com (king1984) — Tue, 30 Oct 2018 13:39:04 +0000

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

Re: I want to export a chart

null@example.com (cleal) — Tue, 30 Oct 2018 13:35:56 +0000

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

Re: I want to export a chart

null@example.com (king1984) — Tue, 30 Oct 2018 10:07:41 +0000

Thank you very kvvaradha you are a great programmer

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

Re: I want to export a chart

null@example.com (kvvaradha) — Fri, 12 Oct 2018 01:38:46 +0000

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.

I want to export a chart

null@example.com (king1984) — Thu, 11 Oct 2018 13:50:54 +0000

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