2/17/20: Code has a bug or needs to be fixed. Need to narrow down where issue in the code lies. Currently when you pull gl deposits to export to excel, it just runs the report again. Won't pull gl expenses at all. This was on data2- it worked in steve's local environment but not here.

From Mike on 9/21: I updated Steve on need for full G/L for all accounts and to be able to query it for an entire 12 month period.   In any IRS or State audit we would need to be able to produce a G/L.  As we begin targeting large accounting groups the g/l report will be an expected output of the system.

10/09/19 updated the query to show YTD from Month chosen

Used CreateDate DatePart

From Mike 

We are compartmentalizing the various G/L sections and kind of reminds me of accounting back in the day

You had a Bank G/L , a A/R , A/P GL , Income Ledger, etc. and ultimately the accountants had to tie it all together.

So we now have

Entire Bank G/L Section

Expense G/L Section   

That just leaves us with the below needed ledgers which could be run independently and be labeled as additional Ledgers :

Inventory Accts  --- Probably 1 report since Big

Other Current Assets /Fixed Assets /Other Assets – Probably could combine into one report

Income Accts  - 1 report since larger query

Other Income / Expense  Accts  ( “Below The Line” items on Income Statement so should be small report )

Other Current Liabilities /Long Term Liabilities – Probably could combine into one report

Equity Accounts  - ( If you remove the Net Income Line from this report the Query should be small )  - ultimately you could get G/L data for entire income statement in various pieces above which would mitigate pulling that line item in the Equity Ledger Report, thus keeping it a small query

Under This Structure we would want all General Ledger Accounts to be one of  the below “Types” to then allow us to run the independent ledgers

Bank

A/R

Inventory Acct ( Includes Raw Materials / WIP )

Other Current Asset

Fixed Asset

Other Asset

Other Current Liability

Long Term Liability

Equity Acct

Income Acct

Costs of Goods Sold Acct

Expense Acct

Other Income / Expense Acct