Cash flow forecast issues regarding Purchase Orders on SAP Business One

[former_member593955]

My company imports products and we must consider more than one date to control delivery time. The system delivery time we use to control the date the goods will be available in my company and we needed to create another date to controle the date the goods must be shipped by the supplier, that will be obviously earlier than the date I will receive the good and have it available. This difference of dates is about one or two days for local suppliers and can reach up to 90 days for some imported products.

This situation causes a problem on cash flow forecast, because it consider it will be invoice on the system delivery date while it will be invoiced according the ship date.

I have tried to solve using A/P Down Payment Invoices on the invoice date (ship date), however it duplicates the payment on the forecast once it does not subtract the A/P Down Payment amount of the Purchase order payment on the cash flow forecast.

Does anyone found a solution for this problem?

[luca_arbore]

Hi Allan,

I opened an incident to SAP for same issue regarding Sales order and A/R Down Payment Invoice on Cash Flow Forecast report.

This is SAP's answer:

We analysed your case, and the scenario described in this support incident is the correct and expected behavior, based on the current definition of the SAP Business One application. The down payment invoice does not have the effect to close partially the Sales Order, the application for this report considers that as long as the Sales Order is not copied to higher document (Delivery, A/R Invoice) it remains in its integrity.

As your scenario relates to a new feature request and change to the system, kindly check if your scenario is already submitted in these sections:

Announcement of Legal Changes - SAP ONE Support Launchpad

All Improvement Request Lists - Customer Influence (sap.com)

Here is the link to the improvement request I submitted:

https://influence.sap.com/sap/ino/#/idea/299915

Luca Arbore