Apply prepayments - Accounts payable

(0) Share

Report

Posted on by Community Member

I have a problem related to the Apply prepayments feature of Accounts payable

When we use the Apply prepayments button in the Vendor invoice form and then post the invoice the tax is not properly calculated so the final voucher (invoice voucher and prepayment application voucher) and prepayment application are not correct

If we post the invoice by using the Vendor invoice form without applying any prepayment the tax calculation works properly and the voucher is OK, if we then apply the prepaymet by using the Apply button located in the Vendor form Invoice tab Prepayment section, the prepayment application and final voucher is correct

I think this is a bug or maybe i am doing something wrong

I am using AX 2012 R3 cu9

Regards

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi, if you operate within an European Vat system, the hints provided here and the related posts might help. dynamicsax-fico.com/.../vendor-prepayments-1

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

Thanks for your help

We are in Mexico so we are not using European Vat system, I read the post though and according to it the prepayment functionality does not work as expected in Europe

What I do not really understand is why this functionality works different when used in the vendor invoice form and when used in the vendor form

For us, it works as needed when we use the vendor form but it does not when we use the vendor invoice form

Best regards

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

Like (0)

Report

Hello Humberto,

I see. Can you provide some more details on your process steps, especially around the vendor form? What are you doing there exactly? Is it the open transaction editing form that you use there or something else to apply the prepayment? Probably some screenprints, etc. would help to see what you want to achieve exactly.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ludwig

Once I have a PO confirmed and its prepayment invoice posted and paid (settled):

This is the step by step procedure by using the vendor form:

1. I go to the PO - Invoice tab - Invoice - enter the vendor invoice information and post the invoice, no prepayment was applied here

Here is an screenshot of the 2 invoices of the PO, AAN-00050 voucher is the prepayment invoice (10% of the PO total) and AFP-00806 voucher is the vendor invoice i am going to apply the prepayment to in the next step

2. I go to .../Procurement and sourcing/Common/Vendors/All vendors - select the vendor - invoice tab - Apply button at the Prepayment section

3. select the prepayment and amount to apply to the vendor invoice and then click the Apply prepayment button

the prepaymet is applied and the final voucher is correct including tax calculation

Now, if i do the same by using the Apply prepayment button located in the Vendor invoice form:

1. I go to the PO - Invoice tab - Invoice - enter the vendor invoice information

2. Click Apply prepayment button in the Invoice form

3. select the prepayment and amount to apply to the vendor invoice and then click the Apply prepayment button, the prepayment line is added to the invoice

4. when i click the Financial - subledger button in order to review the final voucher before posting, you can see the voucher is not correct since tax are not correct, so when I post the invoice the final voucher is incorrect

**** What i just realized is that if i do not click neither of the subledger journal or view distributions buttons in order to review the voucher before it is posted, the final voucher is correct! so i gues these buttons do something that modifies the final voucher

Thanks

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Humberto,

When you apply the prepayment can you open the invoice line details section that shows you the sales tax group and item sales tax group Information? You might not be able to edit this information but from what you write above I believe that you will see different tax combinations defaulting that ultimately cause your problem in the second scenario.

In addition, can you check in the header what posting profile is used (Defaults) when you follow the first or second option as they might also have an influence on what gets posted.

Would be great if you could check that out and let us know.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ludwig,

I went to the invoice line details section that shows the sales tax group and item sales tax group Information and i found that the prepayment line (category and no item) does not contain any tax information and, as you said, I cannot edit this information

and that the main item line does:

this seems to be the problem so I went to the category form and i found that i have the Item sales tax groups properly configured

any advice?

I also took a look to the posting profile and i am using te same in both scenarios so I asume that is not the problem

thanks!

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Humberto,

In my opinion you can either try making a system adjustment that allows you editing - or better defaulting - the right tax information for the prepayment line that is applied for deduction. Alternatively, you can make use of one of the workarounds listed here: dynamicsax-fico.com/.../prepayments

I believe you just came a cross a shortcoming/gap in the standard application.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Ludwig

I think is a bug of the application

I will have to work with the prepayments by using the vendor form

regards

Was this reply helpful? Yes No