Thursday, July 17, 2014

AX 2012 Cash flow forecast Part II: Purchase Cash flow forecast

Purpose: The purpose of this article is to illustrate how to use cash flow forecast functionality for purchase orders .

  Use the following procedures to work with Cash flow forecast:
1.     Click General ledger > Setup > Posting > Liquidity.









2.     Click New to create a line for a liquidity account.

3.     In the Main account field, select a ledger account that is a cash or cash-equivalent account then close the form

4.     Click Accounts Payable > Setup > Customer posting profiles.


5.     On the Setup tab, in the Settle account field, select the account to use as the liquidity ledger account for Vendor payments then close the form


6.     Click General ledger > Setup > Chart of accounts > Chart of accounts.

7.     Select a chart of accounts. Select the Accounts Payable summary account and then click Edit on the Main accounts tab.


8.     Select Companies in the Select the level of main account to display field and select a legal entity. On the Setup tab, click Cash flow forecast.


9.     In the Percent field, enter 100.


10.  In the Terms of payment field, select the terms of payment.


11.  In the Main account field, select the cash account to which the sales account is linked for the cash flow forecast.


12.  Close the Set up cash flow forecasts form.


13.  Click Accounts Payable > Common > Purchase orders > All Purchase orders
.


14.  Create a purchase order of 7,000 for a vendor whose Terms of payment field value is the same as in step 10





18.  Click General ledger > Common > Main accounts.

19.  Select the cash account that you selected in step 11 then On the Action Pane, in the related information group, click Cash flow forecasts.

20.  As you can see the system add new Cash Out record the for the test bank account. 





 Note: if you create new Purchase orders the system will create a new record for each Purchase order. So if you need to know the Cash out for a specific date you need to filter the data in the Cash flow forecasts form then do manual summation.


To get new posts and updates, please follow the blog by clicking the Join this site Button in the top-right side under my personal information