+ Reply to Thread
Results 1 to 1 of 1

Excel VBA Dates in Cash Flow Forecaster Being Extremely Difficult, and Spottily Working

  1. #1
    Registered User
    Join Date
    01-18-2019
    Location
    Kansas City, MO
    MS-Off Ver
    Office 2016
    Posts
    6

    Excel VBA Dates in Cash Flow Forecaster Being Extremely Difficult, and Spottily Working

    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)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-23-2017, 11:21 PM
  2. working with cash flow projection template
    By Natalie Kwaramba in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-05-2016, 03:31 AM
  3. Replies: 0
    Last Post: 07-27-2012, 11:32 AM
  4. collate cash flow series by dates
    By team_qq in forum Excel General
    Replies: 11
    Last Post: 05-29-2010, 05:54 PM
  5. [SOLVED] Discounted Cash Flow valuation template for Excel?
    By LTCDAVE in forum Excel General
    Replies: 0
    Last Post: 06-18-2006, 03:55 PM
  6. [SOLVED] can you create a cash flow diagram in excel
    By jk in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-12-2006, 11:00 AM
  7. [SOLVED] Excel cash flow formulas
    By Kenny S in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-07-2006, 10:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1