VisionCore How To
Home Search Support Forum Knowledge Base Print

Changes on General Ledger Form

Here are the changes made in General Ledger form.

1.Add a Balance field at the bottom of the grid. For Asset/ Expense accounts, value of this field is equal to Debit minus Credit. While for Liability/ Revenue/ Equity accounts, it will use Credit minus Debit formula.

Changes on General Ledger Form1

 

2. The Historical Balance field will be computed as the balance of the account ‘As of’ the ‘To Date’

3.Add different Date Ranges.

As Of Date – This will set the From Date to 1/1/1900 and To Date to the current business date. From Date cannot be changed while To Date can be changed manually.

As Of Date Filters - The following As Of Date Filters will set the default From Date to 1/1/1900 and can be changed manually. To Date cannot be changed manually and it will be set as follows.

As Of Date Fiscal Year – This will set the To Date to the last day of your current fiscal year.

As Of Date This Month - This will set the To Date to the last day of month based on the business date.

As Of Date Period - This will set the To Date to the last day of your current period.

As Of Date Previous Fiscal - This will set the To Date to the last day of the previous fiscal year

As Of Date Previous Month - This will set the To Date to the last day of the previous month based on the business date.

As Of Date Previous Period - This will set the To Date to the last day of the previous period.

As Of Date Previous Quarter - This will set the To Date to the last day of the previous quarter.

As Of Date Previous Year - This will set the To Date to exactly a year before the business date.

As Of Date Next Fiscal - This will set the To Date to the last day of the next fiscal year.

As Of Date Next Month - This will set the To Date to the last day of next month based on your business date.

As Of Date Next Period - This will set the To Date to the last day of the next period.

As Of Date Next Year - This will set the To Date exactly a year after the business date

Custom - This will allow you to set any From and To Date manually.

Fiscal Year - This will set the From Date to the first day of your current fiscal year. To Date will be set to the last day of your current fiscal year.

Previous Fiscal - This will set the From Date to the first day of your previous fiscal year. To Date will be set to the last day of your previous fiscal year.

Next Fiscal - This will set the From Date to the first day of your next fiscal year. To Date will be set to the last day of your next fiscal year.

Period - This will set the From Date to the first day of your current period. To Date will be set to the last day of your current period.

Previous Period - This will set the From Date to the first day of your previous period. to Date will be set to the last day of your previous period.

Next Period - This will set the From Date to the first day of your next period. To Date will be set to the last day of your next period.

This Month - This will set the From Date to the first day of the current month. To Date will be set to the last day of the current month. This will be based on your business date.

Previous Month - This will set the From Date to the first day of the previous month. To Date will be set to the last day of the previous month. This will be based on your business date.

Next Month - This will set the From Date to the first day of the next month. To Date will be set to the last day of the next month. This will be based on your business date.

Fiscal Year To Date - This will set the From Date to the first day of the current Fiscal Year. To Date will be set to the current business date.

Next Fiscal To Date - This will set the From Date to the first day of the next Fiscal Year. To Date will be set to the current day of the affected Fiscal Year.

Previous Fiscal To Date - This will set the From Date to the first day of your previous fiscal year. To Date will be set to the current day of the affected Fiscal Year.

Month To Date - This will set the From Date to the first day of the current month. To Date will be set to the current business date.

Period To Date - This will set the From Date to the first day of your current period. To Date will be set to the current business date.

Quarter To Date - This will set the From Date to the first day of your current quarter. To Date will be set to the current business date.

Year To Date - This will set the From Date to the first day of your current year. To Date will be set to the current business date.

LYFYTD - This stands for Last Year's Fiscal Year To Date. This will set the From Date to the first day of last year's fiscal year. End Date will be set to the current business date.

LYMTD - This stands for Last Year's Month To Date. This will set the From Date to the first day of last year's current month. To Date will be set to the current business date.

LYQTD - This stands for Last Year's Quarter To Date. This will set the From Date to the first day of last year's current quarter. To Date will be set to the current business date.

LYYTD - This stands for Last Year's Year To Date. This will set the From Date to the first day of last year. To Date will be set to the current business.

 


Reference: Task 2746