Small and medium business | Business Central, N...

Cash flow Forecast Worksheet and G/L Budget entries are empty for suggesting

(0) Share

Report

Posted on by Hrvoje Kusulja

372

Hello,

when using BC, SaaS , v16 and v17, I need help for setup Cash Flow Forecast - Worksheet, and Suggest Worksheet lines, it does not set me entries from G/L Budget (as a source type) that I have put.

Other source types (receivables, sales orders, payables etc.) are working.

What I am doing wrong for this?

I cannot find concrete info/docs example etc., who is using G/L Budget entries in Cash flow forecast also.

Here is example that returns me empty rows.

I have read the:
(+) Enhanced Cash Flow Forecasting - Dynamics 365 Business Central Community

All responses (15)

Answers (0)

Sort by

Suggested answer

Bilal Haider 487 on at

Like (0)

Report
Copy link

Link copied!

Hi,

1. Please verify that the Budget that you have specified have G/L Budget entries. If it has then fine just note for which date range these entries are.

2. Now open the Cash Flow Forecast that is first in options and see what is the date set for G/L budget entries there and is that date range have some entries for G/L Budget.
Hrvoje Kusulja 372 on at

Like (1)

Report
Copy link

Link copied!

Hello, thank you for prompt reply, I do confirm dates are entered and correct, and I have values in this period.

What about "Chart of Cash Flow Accounts", anything needs to be done there? (i do not have with source type g/l budget)
Suggested answer

Bilal Haider 487 on at

Like (0)

Report
Copy link

Link copied!

Yes, you need to do setup at Cash Flow Accounts if you have not done before. May be you already know you can link one cash flow account to all G/L account budget entries. So do this setup and I am hopeful it will work. Let me know if still issue.
Hrvoje Kusulja 372 on at

Like (0)

Report
Copy link

Link copied!

I do not know / understand what I am doing wrong.

Here is my chart of cash flow accounts and it all works.

I also tried to add temporary new for G/L Buget source type, but unsure hot wo configure it, i tried several times, but still suggest lines in worksheet, does not give me lines for my budgets in cash flow.
Suggested answer

Dirk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Did you specify "G/L Budget from" and "G/L Budget to" on the Cash Flow Forecast Card page !?
Hrvoje Kusulja 372 on at

Like (0)

Report
Copy link

Link copied!

Yes, here is my cash flow foreacast card:
Suggested answer

Dirk Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Ok, good.

What about the "G/L Integration" field on the Cash Flow Account Card page?

This needs to be set to "Budget".

And what about the "G/L Account Filter" on the same page?

Did you specify a filter for G/L Accounts for which you entered G/L Budgets for that period?

The "Source Type" should be set to "G/L Budget"
Bilal Haider 487 on at

Like (0)

Report
Copy link

Link copied!

Please post the Budget card for YEAR-2021
Hrvoje Kusulja 372 on at

Like (0)

Report
Copy link

Link copied!

I have tried, but still zero results

- change G/L integration to Budget only

- remove filtering (to include all records)

- source type is G/L Budget

I have in G/L budget, correct account numbers, amounts, and dates, and Budgeting works by itself. I just can not get those records to Cash flow also :/

Here is part of Budget card:
Bilal Haider 487 on at

Like (0)

Report
Copy link

Link copied!

Please show the date filter on this Budget Card