Project management and accounting - Estimates

(0) Share

Report

Posted on by Community Member

Good day

I am trying to do an estimate and elimination on an Investment Project in AX2012. I have created the WBS and linked Items and hours, I have also posted 2x POs for the project - both POs are Approved status = Finalised and Status = Invoiced.

On creation of the estimate, I allow sufficient time on the Estimate date, but the Percentage complete remains = 0,00. When I check under Control>Payment retained from vendors>By PO, I see the two POs there. I assume that is the reason?

What setup do I miss or what is the reason for the Elimination percentage issue?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Hannes,

When you created the estimate, have you selected the 'set costs to complete to zero' method?

This should set the POC to 100% and show you the amounts recorded in the other tabs of the estimate form.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig

Yes, I have used 'set costs to complete to zero'...

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Hannes,

Can this be related to a calendar issue?

Your estimate date is 30 July while the July has 31 days.

Can you check that?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig

I assume the date range started on a date <>beginning of a month. The weeks still increment with 7 days, i.e. 2017-07-30 + 7 = 2017-08-06.

Is this an issue that the estimate needs to be done on the very last calendar day of the month? Surely I could have picked 2017-07-23 if I did the estimate on the 21st of July?

Thanks

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Hannes,

Depending on the project setup, some transactions might be posted at the end of the month. Can you try creating a new estimate as of 6 August?

Can you also check that the PO invoice is posted?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig

I will ask my finance colleague to confirm the postings of the PO invoice.

With regards to the estimate on 6 Aug - I have run for 6 Aug but still 0%. Let me check-out the postings on the PO first...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi guys

I am still having issues to get Purchase Order costs transferred with the estimate and illumination.

Is there maybe a tick in Project management and accounting to accommodate POs' costs to be considered for estimates, etc?

As per screenshots, I have a fully Finalised, Invoiced PO, #195. Logically one would not need to do a payment journal before the costs are considered for the Project to be actual costs? Surely an Invoiced PO is enough commitment for costs to be allocated to a Project? When does the PO entry become removed from the Payments retained from vendors list? The Invoice amount also does not reflect on the Enquiry for vendor retained payments form, under the Invoice amount column? This Vendor is set to be COD, thus it cannot be issues on payment being outside the elimination cycle.

I do the new estimate with the Cost to complete method = Set cost to complete to zero

and the Estimate date = 25/03/2018

Thanks people!

Was this reply helpful? Yes No