Account Receivable retention not happening

(0) Share

Report

Posted on by Community Member

I have a project with 10% customer retention setup. A customer invoice was prepared from posted project hour journal from an AR.billable item with amount of 6000. I have noticed the same amount - 6000 flow to AR invoice. In contrast from AP invoicing the final line amount will be less than retention and the retained amount move AP account.

5141.voucher.JPG

My doubt is, if I miss something in project setup or the process is not right at all?

Moving further to Payment, the amount of 6000 was debiting to my bank account. Where I would expect the amount will be less than the retention.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jonathan,

When you create your invoice proposal, can you identify the amount to be retained in the invoice proposal form?

As far as I remember for hours transactions you need to enter the amount manually whereas for PO's/SO's the retention setup automatically defaults.

Probably try testing modifying the retention amount manually in the invoice proposal.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

Thank you for the response. After reconfiguring the project retention with 100%-10% rules, it comes with correct IPA numbers. The below shows 9000 having a sales markup and with net invoice amount of 8100.

However in AR payment journal the invoice is showing 9000 instead of 8100.

My doubt here is, 8100 need to pass manually payment journal lines?

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Hi Ludwig ,

Do you have any idea about how upload retention amount opening balances against the project and vendor & customer wise during golive in AX 2012 / AX 7 ?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Jonathan B,

The open Balance that you should see on your customer should only be for 8100$ not the 9000$. Can you verify that?

The 900$ difference should be posted to a spearate account and only release with completion/final invoice.

Would it be possible to post the Terms that you Setup and that calculate your rentention amounts?

Ludwig

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

Like (0)

Report

Hi lally,

retentions are currently not supported in beginning Balance Journal in the Project module. So, if you need to transfer them to AX, you need to think about a manual way how to realize that.

Best regards,

Ludwig

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

[quote user="Ludwig Reinhard"]you need to think about a manual way how to realize that[/quote]

Any help from your end ?

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

Like (0)

Report

Hi lally,

Do you refer to customer or vendor retentions?

I mean what is the concrete issue at your customer?

Which transaction types are you referring to? (posted POs, hours, etc.)

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

The project retention term is setup 10% retention for 100% of work completed.

I would suspect did not happen. See the below voucher details and customer balance.

----

The 900$ difference should be posted to a separate account and only release with completion/final invoice.

----

Any help where can I confirm the setup?

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Jonathan B,

This seems indeed strange.

Probably check the following:

(1) Do you have a specific project category for retentions setup?

(2) Do you have the automatic receivable account for customer retentions setup in GL?

(3) Do you have the retention assigned to either (a) the project, (b) the project contract or (c) a billing rule?

I would assume that there is something wrong with no. (3) as AX should automatically suggest the retention when creating the invoice proposal. You can manually adjust that amount but I double checked in my machine and noticed that it should automatically calculate the Retention.

Probably try to test the process once again in a demo environment and see if it works.

Would be great if you could Keep us updated.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

[quote user="Ludwig Reinhard"]

Do you refer to customer or vendor retentions?

[/quote]

I am looking for both types of retention amounts

[quote user="Ludwig Reinhard"] I mean what is the concrete issue at your customer? [/quote]

The issue is one of my client will be going live in the next month and client had retention agreement with most of the vendors and same way customers also with client against each project. It is long term project and client already posted lot of transactions purchase transactions (Items/Services ) , against these transactions client hold retention amount and same way customers retention amount also.

Now when during go live i need to upload that against each project wise , vendor wise and customer wise , how much retention amount hold and that amount need to upload in new AX system ..How to do this ?

Was this reply helpful? Yes No