Hello,
I have build a "Cash Flow Forecaster" in Excel VBA. We have a bunch of workbooks that keep track of our Invoices, and Vendor Invoices. We also have workbooks to keep track orders not shipped but will be in the future, thus becoming invoices that are due. So what this forecaster is supposed to do is go through all the workbooks, look at each of these invoices and orders, take the values (what we are going to paid on it, what we are going to pay, etc) and put it in a chart for the correct date. An example of the chart is attached. There are some additional features such as trying to introduce delays (the shipping is delayed, or a customer is a slow paying customer and so on), but I don't think that will be too relevant to this question, and only writing it here so the 1-2 lines of code that appear for delays aren't a surprise.
The chart feeds into a calendar view where we can see projected cash positions. Now the problem is, that the code is working for every column on the chart, expect for "A/R" (and subsequently Time Delayed A/R, as that column is just an adjustment of the A/R column). I am stumped, but I believe the problem is that it's just not finding the correct date in the chart for every invoice it finds. I checked the source file if it's date formatting issues, and didn't find any issues. It's so strange, and I cannot understand how to debug this becuase this code is working on the other columns, and it is doing a similar thing for all the other columns
I have attached a snippet of the code, labelled "Invoice" and that is the snippet that populates the "A/R" and the "Time Delay A/R", and another snipped "Vendor" which populates the "Vendor A/P". The invoice side has a few more lines of code as it's also doing the time delay. What it's doing on the A/R side is that some dates it has the correct figures, and on some dates it's completely missing.
Any ideas how I can begin to debug this thing? (Sorry for the long post)
Bookmarks