When trying to project cash flow, using the Cash Flow Management module makes it easy as long as your GP data is up to date. Follow the steps below to set up the cash flow:
1) Go to Tools>>Setup>>Financial>>Cash Flow Forecast.
2) Make the following selections:
a) Select the Checkbooks to include and enter exchange rates for foreign currency checkbooks
b) flat amount beginning balance
c) gl account affecting cash
d) choose sales open and/or work transactions and/or SOP Documents
e) choose purchasing open and/or work transactions and/or POP Documents
f) General Cash Flow transactions (What If transactions can also be entered into the Cash Flow Transactions window to assist with the Forecast)
g) What date to use for Customer collections, Average Days to Pay or Invoice Due Date
Once the setup is complete, you can use the Inquiry>>Financial>>Cash Flow Calendar to project the cash flow for each day. Click on the day to open the Cash Flow Explorer to see what makes up the transactions for the day.