D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Fixed asset Project Cash flow reporting using the ledger

  • 1.  Fixed asset Project Cash flow reporting using the ledger

    TOP CONTRIBUTOR
    Posted Feb 17, 2021 01:40 PM
    Hi Everyone,

    Am wondering if the community has attempted to report cashflow continuity reports via the general ledger and in particular how they have handled CAPEX reporting around fixed asset acquired through projects.

    We acquire Fixed assets via PO/AP, FA journals or Project eliminations. All methods understandably use the Acquisition Fixed asset transaction type and corresponding ledger account. However, in the instance of Project acquisitions, there is a timing issue from a cash flow perspective - we have already recognized the project expenditures in prior periods as cash flow expenditures. Consequently, this will cause us to double report the cash flow. The desire is to have the system to use another ledger account as this is not an acquisition from a cash flow perspective.

    Out of the box, it does not appear to be configurable for project eliminations to use a transaction type other than Acquisition, so we have considered a few options.

    1. Extension to allow for project eliminations to use alternate Fixed asset transaction types and corresponding configurable WIP offset account. Complex and expensive.
    2. Workaround: Cease using project eliminations and manual project eliminations via FA journal entry using an Acquisition adjustment transaction type. Extension required to allow an Acquisition adjustment without an Acquisition.

    Appreciate any insights into alternative approaches.

    Cheers,



    ------------------------------
    Christopher Ho Yee
    Altius Consulting
    Richmond BC
    ------------------------------


  • 2.  RE: Fixed asset Project Cash flow reporting using the ledger

    TOP CONTRIBUTOR
    Posted Feb 19, 2021 02:34 PM
    Edited by Zvika Rimalt Feb 19, 2021 02:34 PM
    so if I understand correctly, you are trying to distinguish between acquisitions coming from AP/PO and acquisitions coming from project elimination.

    If that's for reporting purposes only, can't you use the distinctive VOUCHER Number format used for elimination from the other, distinctive voucher number formats used by purchase order invoices and AP invoice journals respectively?


    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------



  • 3.  RE: Fixed asset Project Cash flow reporting using the ledger

    TOP CONTRIBUTOR
    Posted Feb 25, 2021 03:00 PM
    Thanks for the reply Zvika.

    We can't use different vouchers as we want the project acquisitions to appear in a different ledger account than the one defined in the Acquisitions. This is not possible as it uses the Acquisition Fixed asset transaction type out of the box. Don't think we could even use a separate voucher sequence as you can only have one sequence per transaction type.

    ------------------------------
    Christopher Ho Yee
    Altius Consulting
    Richmond BC
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role