D365 Finance & Operations and Dynamics AX Forum

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 17, 2021 01:39 PM
From: Christopher Ho Yee
Subject: Fixed asset Project Cash flow reporting using the ledger

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
------------------------------

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
------------------------------

Original Message:
Sent: Feb 19, 2021 02:33 PM
From: Zvika Rimalt
Subject: Fixed asset Project Cash flow reporting using the ledger

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

Original Message:
Sent: Feb 17, 2021 01:39 PM
From: Christopher Ho Yee
Subject: Fixed asset Project Cash flow reporting using the ledger

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
------------------------------