Share
Report
5Hello. I'm trying to create a cash flow forecast including G/L budget entries. Everything is working fine except all account schedule period (month normally) columns for cash flow budget lines in the next fiscal year are showing the entire amount for the year instead of monthly changes. This is true for all months in the next year. I've tried a variety of column specifications, e.g. for January FY[13], 1FY[1], CY+1M, etc and they all exhibit the same behavior. Are account schedules meant to be used across fiscal period boundaries?
For example, for the setup I have payroll G/L budget entries for through the end of next year. In Chart of Cash Flow Accounts I have a line for budgeted payroll (Source Type=G/L Budget, G/L Integration = Budget, G/L Account Filter = {range of payroll of accounts}). The Cash Flow Forecast successfully brings in (Suggest Worksheet Lines) entries for the budget line through the entire period of interest. Examining CF Availability by Periods shows that the budget amounts are distributed under G/L Budget as expected per period.
My Account Schedule has a budgeted payroll line that specifies Cash Flow Entry Account and points to the Cash Flow Account specified in the previous paragraph. Now when opening the overview for that Account Schedule everything looks great through the end of this year, but every month in next year shows the total amount for 2023.
Am I trying to do something unsupported or have I specified columns incorrectly? Is there a better way to accomplish my goal.
I appreciate any help or insight you folks provide.
All responses (
Answers (
