Book Image

Microsoft Dynamics AX 2012 R3 Financial Management

By : Mohamed Aamer Ala El Din (USD)
Book Image

Microsoft Dynamics AX 2012 R3 Financial Management

By: Mohamed Aamer Ala El Din (USD)

Overview of this book

Table of Contents (18 chapters)
Microsoft Dynamics AX 2012 R3 Financial Management
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Cash flow transactions


The transactions that affect the cash flow forecast are purchase and sales orders. The cash flow transactions also depend on the configuration of the company-wide parameters and the master data setup.

Purchase order cash flow forecast

This section illustrates the cash flow forecast transaction for a purchase order (PO). The order's data is as follows:

  • Configuration of the Accounts payable module's parameters:

    • Period between delivery and invoicing: 5 days

    • Invoice period: 7 days

    • Settle period: 3 days

  • Vendor master data:

    • Terms of payment: 15 days

  • Purchase order data:

    • Purchase order date: January 1

    • Purchase order quantity: 1 Piece

    • Currency: EGP

    • Default currency: USD

    • Exchange rate: 1 USD = 5 EGP

    • Purchase price: 5,000 EGP = 1,000 USD

The purchase order was created on January 1. Based on the setup of the period between delivery and invoice, which is 5 days, the date will be January 6 (by adding 5 days to the PO line date). Based on the setup of the invoicing period, which is 7...