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
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.
Hello Mr Palle Arentoft & Erik P. Ernst
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
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.
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.
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.