How to access the values of Chart of Account from DB?

shahid · March 7, 2019, 1:44pm

Hello,
Is there possible to access these values of chart of accounts using Database? and possible to add or subtract any value?

joshiparthin · March 7, 2019, 5:54pm

Try accessing frappe api

And fetch values from dB.

By database I suppose you are talking about fetching programmatically right ?

vrms · March 7, 2019, 6:03pm

would

SELECT * FROM `tabJournal Entry`;

or

SELECT * FROM `tabJournal Entry Account`;

be helpful?

you’d first say

cd ~/frappe-bench
bench mariadb

(which brings you into the mysql console with the database of your current site) and then use the above commands (in case you are not familiar with that)

shahid · March 8, 2019, 11:13am

Thanks but i know i can fetch from journal entry using above statement but actually i want to fetch taxes, and taxes are also come from Sales Invoice, if i fetch it from journal entry it will not show the amount of Sales invoices. hope you’ve got my point. i just want to fetch the exact figure which is showing in chart of account.