Description |
The Cash Projection Chart should have 3 lines for Cash, AR Aged and AP Aged and look like this chart.
!pastedImage_d141286_0.png|height=197,width=383!
We need to replace the Pivot Grid with a normal grid and only show 3 rows (Cash, AR Aged and AP Aged). Then for the columns there should only be 5 columns for the next 5 weeks of data for the Cash, AR Aged and AP Aged rows. Each line in the chart above would plot the 5 weeks of data for those 3 rows. It should look like the following grid with the same number and date formatting.
!pastedImage_d141286_1.png|height=97,width=492!
Data Calculation
# Take current balance of cash at the current date
# Subtract the balance of open AP with a due date in each week from the cash balance and calculate a running total
# Add the AR due in each week and calculate the running total
|