Microsoft Dynamics AX (Archived)

Vendor retention - posting error

(0) Share

Report

Posted on by Pierre-Olivier Lacasse

112

Hello,

I have created vendor retention plan

100%, 10%, 0

When i create a purchase order the vendor retention plan is attached to my line items and when i invoice the purchase order the retention is probably done.

My problem is when I want to invoice the retention itself. I generate a new invoice for that purchase order select the default quantity to "ordered quantity" and select my line item and click the checkbox "release all retention". When i try to post i receive the error message "Account number for transaction type Sales tax does not exist."

However all my tax setup is done, i am able to post AR and AP invoices with the same tax groups and item tax groups.

Does anyone have any solution lead for me?

thank you and have a nice day.

*This post is locked for comments

All responses (7)

Answers (1)

Miselle 10 User Group Leader on at

Like (0)

Report

RE: Vendor retention - posting error

Hi Ludwig, where is the setup for getting retention to be automatically transferred to the ordinary vendor account after the last invoice has been posted ?
Verified answer

Pierre-Olivier Lacasse 112 on at

Like (0)

Report

RE: Vendor retention - posting error

After opening a ticket with Microsoft, we have identified that CU09 has a bug which is fixed by KB3076383. According to Microsoft CU11 is not affected by the same bug and as Ludwig mentioned AX7 is working as well.

Thank you.

Pierre-Olivier
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor retention - posting error

Hi Pierre-Olivier Lacasse,

I checked the functionality in AX2012 where I got the same error message that you showed above and compared it with AX7 where I could post the release of the retention without problems.

From your screenprint above I can see that you are using CAD. So, can you probably check whether the following hotfix resolves the issue?

KB 3057384Sales tax is not calculated on a retention invoice when a vendor invoice is posted that is required by Canadian law

Would be great if you could keep us updated here.

Many thanks and best regards,

Ludwig
Pierre-Olivier Lacasse 112 on at

Like (0)

Report

RE: Vendor retention - posting error

Hello Ludwig,

yea i can see the tax distribution in the distribute section of the invoice line.

Here is the result

I can see the tax account and the tax code used for the calculation.

the only way i can achieve proper validation is if i remove the tax group and item tax group.

thank you.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor retention - posting error

Hi Pierre-Olivier Lacasse,

When you are in the invoice form and select the financials tab and then say 'view distributions' can you identify the tax line and the missing account?

If so, can you change the sales tax and item group tax settings in the invoice form in a way that it results in a valid tax combination for which an account has been setup?

Ludwig
Pierre-Olivier Lacasse 112 on at

Like (0)

Report

RE: Vendor retention - posting error

Hello Ludwid,

I actually don't want to release the vendor retention automatically since there are many dependancies in the business processes. This is why i created the vendor retention plan as Units completed 100, units retained 10, units released 0.

As for the error. I created a PO with X units, created the reception for X units. I then invoice the receipt with taxes. The invoice was reduced by the configured 10% retention which is as expected.

I then go back to the purchase order to create another invoice. since the PO is fully received and invoiced, the only way i can get the manual button in the line details to release the vendor retention is by selection the default quantity for lines = to order quantities.

This creates a line for the full quantity and price. When i select the line detail check box "release all retained amounts" the invoice total shows only the previously retained amount and the taxes for that amount. Then i try to post but i get the error message "Account number for transaction type Sales tax does not exist."

Like i said, all my tax setup is done and i am able to post all other taxable transaction in the system..

thank you for your help.
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Vendor retention - posting error

Hi Pierre-Olivier Lacasse,

Can you provide some Details on how you want to invoice the the vendor retention?

Depending on your setup it should automatically be transferred from the retention account to the ordinary vendor account typically when the last invoice ist posted.

Yet, when and how this transfer occurs depends on your retention schedule setup.

Can you possible show how this has been setup and provide some more information on the steps you took before the error was triggered?

Ludwig