How to effectively manage the Cash Flow Forecasting by using NAV/Business Central

Business Central/NAV General Discussions
1

Hi all,

I used the Cash Flow Forecasting in NAV/BC and that’s somehow fine, but sometimes it’s inaccurate or the report is not fully clear specially when you show to the Business managers.

I am looking for some guides to How to effectively manage the Cash Flow Forecasting by using NAV/Business Central.

in the past I used sheets and this is great but normally need more manual works, I need to utilize NAV/BC very well.

Thanks in advance

2

Dears, Is my discussion has a value:

How to effectively manage the Cash Flow Forecasting by using NAV/Business Central?

Thanks in advance

3

Difficult to say what is wrong in your setup or what you are doing wrong, without seeing it. And are you doing this in a production or demo environment?

I assume you’ve already checked out this video, if not then let me suggest it to you to start with:

https://www.youtube.com/watch?v=QT1xVsdDNKI

I’ve never setup the cash flow module myself, but I were to do it, then I would start by following the examples in the video and at docs.microsoft.com. Slowing work my way through it, making sure it was correct according to the test data I was adding. Then when that worked and I was sure it does it correctly, then I would start setting up my customer (also in a test copy).

4

I have testted all versions of Cash Flow Forecast and none of them have ever failed. The setup is extremely simple so you cannot hardly do any errors.

If you show us a case where it goes wrong (with a step-for-step-guide) then it is easy to tell you what you do wrong.

I have trained more than 200 people in this “module” - all with great success.

5

Opps, Sorry I did not see your reply

Dear Mr [mention:61b2aa9ce72e429baa1ef43208ddbea4:e9ed411860ed4f2ba0265705b8793d05] & [mention:74275055534c437ab13054c27a1ed5fb:e9ed411860ed4f2ba0265705b8793d05]

Thanks much, I have studied again the setup and the mistake I was doing is assigning the G/L accounts to the Receivables

az650530.vo.msecnd.net/…/81243_04_04_SUCFF.mp4

6

Hello Mr [mention:74275055534c437ab13054c27a1ed5fb:e9ed411860ed4f2ba0265705b8793d05] & [mention:61b2aa9ce72e429baa1ef43208ddbea4:e9ed411860ed4f2ba0265705b8793d05]

Sorry to open this question again, now I noticed the amounts paid to Vendors in advance, coming as Cash in, How to exclude those.

Also, I have some employee loans recorded in customers, how to exclude?

Thanks so much

7

I am not sure on how your “paid to vendors in advance” is done? What is the document type of the Vendor ledger Entry? But I would believe that you cannot “ignore” those pays without development. Or you have to filter and delete the lines in the journal before you register it.

8

OK, I am deleting before registering; but once I recalculate the Chart on the role center every deleted entry comes back.

The payment is done to the vendor from payment journal as they request and Advance payment before starting the production (Video production), we did not receive any invoice yet. I see NAV/BC determining that as Receivables for some reasons or some mistakes I did.

9

How do your payment journal look like??

And yes, the purpose of the cash flow forecast is that everything comes back as how the cash flow is supposed to look like when you recalculate the lines…So it kinda works as intended from microsoft.

You can say that if you just register it as a payment then it is cash going out that is nok linked to an purchase order or Purchase invoice.

The only thing that can change it is using the standard pre-payment functionality.