Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Cash Flow Forecasting ...
Small and medium business | Business Central, N...
Answered

Cash Flow Forecasting and Purchase Order Dates

(0) ShareShare
ReportReport
Posted on by Murrgh

Good morning,

We have recently set up Cash Flow Forecasting in NAV 2017. We're running into some issues with the automatic dates that are being brought into the Cash Flow Worksheet.

Here are some background details:

  • Purchase Orders have multiple lines for items that we receive on the first of the month. The Expected Receipt Date is set to 7/1/2021, 8/1/2021, etc for each line.
  • The Cash Flow Worksheet pulls in the "Cash Flow Date" as the PO Header Due Date + Payment Terms Code for each line.
  • However, instead of taking the "Expected Receipt Date" for each line - it's just using the above formula to calculate the date. Since it's using the header due date, it results in each months Cash Flow Date being 7/1/2021 - when in realize each one should be a month apart.


How do we have to set up the Purchase Orders so that the Cash Flow Worksheet properly pulls in the dates? Or is this an error on the Cash Flow Setup?

  • GRNI for Purchase order Profile Picture
    GRNI for Purchase o... 27 on at
    Cash Flow Forecasting and Purchase Order Dates
    how do you resolve above issue mentioned? is there any out of box cash flow forecast you can recommend
  • AMayer Profile Picture
    AMayer 10 on at
    RE: Cash Flow Forecasting and Purchase Order Dates

    We run into the same issue, we could transfer larger orders with different lines to blanket sales and purchasing orders, but will this solve the problem? 

  • Murrgh Profile Picture
    Murrgh on at
    RE: Cash Flow Forecasting and Purchase Order Dates

    Thanks - this is what I am seeing. But how does this work with Blanket Purchase Orders? If I'm using Cash Flow Forecasting, I will only be able to have one line per PO to have the CF Report be accurate with dates.

  • Verified answer
    Gulshan Shubham Profile Picture
    Gulshan Shubham 2,200 on at
    RE: Cash Flow Forecasting and Purchase Order Dates

    Hi Murrgh,

    In the case of Purchase Order (& Sales Order), the Cash Flow Date is the value in the Due Date field of the document header (in your case Purchase Order document), unless you are using the Cash Flow Payment Terms as well.

    The expected Receipt date has no role to play in the Cash Flow Date for PO. Also, Payment Terms cannot be defined line-wise in base NAV. If you are currently doing so then it must be customization.

    So, please check on these points because the out-of-the-box Cash Flow module works just fine.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans