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






2 comments:

  1. A cash flow forecast is a financial tool used by businesses and individuals to project their expected cash inflows and outflows over a specified period, typically for a month, quarter, or year. This forecast helps in managing cash resources, making informed financial decisions, and ensuring that there is enough cash on hand to cover expenses and meet financial goals. Moolamore is an advanced accounting application that analyzes, manages, and projects real-time transaction data. Using our cash flow forecasting software and app, you can forecast and estimate your company's future financial position.

    ReplyDelete
  2. FRESH (US) F-ULLZ

    FULL-INFO WITH DL NUMS OF ALL STATES (A-Z)
    FULLI-NFO DATA WITH DL ISSUE & EXPIRY DATE ONLY SPECIFIC STATES
    FRESH DATA FOR UBER EATS & DOORDASH ETCC....
    (2000-2015 YOUNGER DATA WITH FULL INFO )
    (1930-1955 DEATH PROS WITH FULL INFO)
    DATA WITH FULL-INFO FOR UI-SBA
    DATA WITH GOOD CS (750~850)WITH FULL INFO ALL STATES
    EIN-LEADS WITH FULL INFO

    DL-SCAN PICS WITH FRONT & BACK +SELFIE
    (WITH SSN & WITHOUT SSN)

    ALL STATES ARE AVAILABLE

    SPECIFIC DATA CAN PROVIDE ON DEMAND
    GENDER
    DOB
    CITY-STATE

    UK-DATA IS AVAILABLE WITH NIN
    FULL-INFO
    RANDOM CITIES
    UK-LEADS WITH FULL INFO
    FULLNAME-NIN-DOB-ADDRESS-CITY-STATE-ZIP
    FRESH DATA

    (CAN PROVIDE SAMPLE FIRST FOR SERIOUS BUYER BEFORE A DEAL)
    (REPLACEMENT POLICY IS AVAILABLE FOR BAD DATA)

    CANADA DATA WITH FULL INFO AVAILABLE
    FULL-INFO WITH SIN
    INFO WITH MMN+SIN
    SINPROS OF CANADA

    CONTACT ME AT--TELEGRAM--@James307--usafullzinfos....(G-mail)

    ReplyDelete