💁Agenda of the Video▶️: To Show, How-To assign "Date Filter" in Chart of Accounts (COA) List Page in Business Central.
✅Hint1️⃣: Try to View "Chart of Accounts" List Page as a whole report, like a Trial Balance (TB) Report.
✅Hint2️⃣: Financial Statement = Profit & Loss Account, AND Balance Sheet.
✅Hint1️⃣: Try to View "Chart of Accounts" List Page as a whole report, like a Trial Balance (TB) Report.
✅Hint2️⃣: Financial Statement = Profit & Loss Account, AND Balance Sheet.
Category
📚
LearningTranscript
00:00hello friends welcome to my channel i am freelancer madhvi and today we are going to discuss
00:11the chart of account date filter and how you can see trial balance
00:20many people do that when you check data from financials or general ledger
00:29they use trial balance but if you have a particular group or subgroup
00:37you can check the data from financials or income statements
00:41and check the data from the gs
00:45then you can check the chart of account and you can put date filter
00:49and if you want to put the statement filter
00:51then you can put the statement filter
00:53so i will show you how to do it
00:55now if you think we want to put the statement filter
00:58if you click on the filter filter or you can click on the filter box
01:05if you want to choose income statement or balance sheet
01:09then you can choose income statement
01:11then you can choose net change column
01:13that you can choose
01:15and if you want to choose balance sheet
01:17then you can choose balance sheet
01:19as on date
01:21balance at date column
01:23okay
01:25now we will check balance at date
01:27we will check balance sheet
01:29we will put balance sheet
01:31but now i will need date filter
01:33that i will put date wise
01:35now i will put balance at date
01:37so as on date
01:39as on date
01:41we will make financial statement
01:43we will make financial statement
01:45like balance sheet
01:47so as on date
01:49at the period end
01:51you will show closing values
01:53okay
01:55and net change
01:57income statement
01:59for the period
02:01okay
02:03what is the balance
02:05what is the balance
02:07what is the balance
02:09you can do in the system
02:10if there is future entries
02:11if there is future entries
02:13then you can include the future entries
02:15so now we will use balance at date
02:17because we are looking at balance sheet
02:19so now i will put date filter
02:21check the width
02:22which is the fault
02:23here in the field
02:24here again
02:25a filter button
02:27i will find the date and then
02:28here
02:29let me assume
02:30you have the 1st of the video
02:31that you have the data
02:32at the 31st of the month
02:34and you will see the date
02:36which is the date
02:37which is the date
02:38and you can choose
02:39as on date
02:40you have to understand
02:41what is the date
02:42and you have to be aligned
02:43here
02:44let us click balance at date
02:45choose
02:46the date
02:47then
02:47the date
02:48which is the balance sheet
02:49which is the balance sheet
02:50so you can write a filter on the balance sheet statement
02:54then you can also open it in excel
03:00and if you want to look at the balance sheet
03:05then you can also write a filter on the balance sheet
03:11and if you want to bring it in excel
03:14then you will find values
03:17and if you want to add income statement to the net change with the column here, you will need to add a filter to this
03:25and you will need to change the data to the income balance, and you will need to click on the balance sheet
03:33so this way, you will need to change the column to the net change and balance sheet to the balance sheet
03:41and here, you will need to change the statement in short form
03:47so this way, you can see a report directly from the chat app account
03:53which is connected to any statement, its group and subgroups and ledger and subledger
03:59Thank you for watching!