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 caluate 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?
—————————— Chris Warren Senior Business System Engineer ivWatch, LLC Newport News ——————————
Spencer Coulter
Member
June 17, 2021 at 8:34 AM
Chris,
The key here is the financial aspects of a document, in your case you are using the lines to manage some of that but really from a financial standpoint everything is driven from the invoicing process which sources from the header dates on the document. Definitely understand the process as you outlined it but the process will be header focused for cash flow, you’ll likely need to add a modification to the system that registers lines into your cash flow using the receiving dates + payment terms instead to get to what you are looking for.
—————————— Spencer Coulter Director, Business Applications
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Report
You have already reported this .
Welcome to our new site!
Here you will find a wealth of information created for people that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!