Fee Journals - Time and Material Project Revenue and Accrued Revenue

(0) Share

Report

Posted on by Community Member

Hello All

is it possible to Post a Fee journal to a T&M Project with line property Non-Chargeable. book Revenue as 0 but accrue the line amount?

I have few transaction in our production environment where Revenue is showing 0 but accrued the line amount. I tried hard to simulate this scenario but I failed.

not sure how these entries got posted. cant really think now. also from accounting post of view they make no scenes as if revenue is 0 then why would we accrue

but the project statement totals are correct, Project actual transaction report is correct. its just the project fee transactions when i open these transaction are out

Screenshot of one of these entries

FEE Transaction

Fee Transactions Enquiry or Sort Field Report Fee Transaction

appreciate your help

Thank you

Sandeep

Version Information:

Installed product version : Microsoft Dynamics 365 for Finance and Operations, Enterprise edition (July 2017)Installed platform version : Update12 (7.0.4709.41171)

*This post is locked for comments

I have the same question (0)

All responses (17)

Answers (0)

Community Member on at

Like (0)

Report

sorry missed the screens

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello sandeep madavi,

Has the project group of your project the accrue revenue parameters turned on?

The green fee journal that you shared has the term 'correction' included in the journal header. Do you have any information what was corrected?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig, the name correction is fee journal description.

in project group accrue revenue is ticked. if you look at the other transactions with same type of fee journals it has updated Revenue and accrued both which is good. the issue comes when it updates accrued revenue but not revenue.

thank you

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello sandeep,

I tried to replicate your issue but was not successful in doing that.

Yet, I noticed that you have columns in your fee transaction form that I cannot include there via a personalization. Example: accrued amount, Vat group.

Are those fields customized fields?

If so, can you double check that there is no problem with the customization?

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

there is absolutely no customization on Fee Journal or Fee Journal postings. and even am very confused how the posting with 0 revenue got there with accrued value intact.

i failed to simulate this as well. I wonder what's the way out to correct them and avoid them in future

we did some customization to pull some additional fields in Fee Transaction report but its just read only fields not anything with data entry

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (0)

Report

to your original question, the answer is yes.

If you set the project group to "accrue revenue"

but record a fee transaction with a non-chargeable line property the revenue is going to be accrued but the line will never be part of an invoice proposal (and an invoice) - hence the accrual will not be released and not revenue is going to be recorded.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Rimalt

thanks for your support.

what you commented is logical but if you look at the Fee Transactions screenshot for a same project and same settings system is posting Revenue and Accrued Revenue both for that Fee Journal.

there is only hand full of transactions where Revenue is showing zero but amount is accrued and we are also not able to simulate this case.

if we can simulate or know in which circumstances this happens would help

thank you

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello sandeep,

What happens in your environment if you post the fee with a non-billable line property. Does AX accrue an amount or not?

In my demo system it does not do an accrual if the line property is a non-billable one.

How does your system react here?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Reinhard. it does accrue. am only thinking this is the case because the category and project group both are set to accrue

thank you

Was this reply helpful? Yes No