Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Return Order VAT not i...
Finance | Project Operations, Human Resources, ...
Answered

Return Order VAT not inline of Sales Order !

(0) ShareShare
ReportReport
Posted on by csteenbe2 30

Hi,

After that Germany decreased the VAT % per 01-07-2020, we have the strange behaviour of Return Orders where the Sales Order was before 01-07-2020 so the old VAT%, the VAT% as of 01-07-2020 on Invoice Line of the Return Order is taken - so now we have difference between Return Order and Sales Order :-(.

In my thoughts the VAT% should be the same of the Return Order as of Sales Order, it should take the values considering the dates in the TaxData.

For normal invoicing it is taking the right VAT%, values are set in the TaxData with the from to date(s).

In our parameters is set that the VAT is calculated per line.

Any one a idea ?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Return Order VAT not inline of Sales Order !

    Hi Cees,

    Many thanks for your confirmation and feedback.

    I got the same information and would like to suggest opening a support case with MS to get this fixed for the future.

    It might not help you with the already recorded transaction though but at least with the next change that we get in January 2021 things should work fine then.

    I think that's all what the community can help you with here.

    If there is nothing else left open / not answered then please be so kind, verify the answer to get this thread completed and once you get a feedback from the MS support keep us updated here, how things are going.

    Many thanks and best regards,

    Ludwig

  • csteenbe2 Profile Picture
    csteenbe2 30 on at
    RE: Return Order VAT not inline of Sales Order !

    Hello Ludwig,

    Thanks for your effort and response!

    Talked to the DEV person, myself ;-) and I have debugged and looked at all VAT functionality and came to the conslusion that in case of a return order from the past before the VAT was changed and you have a VAT calculation on line level and have prices including VAT it goes wrong.

    I changed the methods what are wrong and now it is working as it should, but it is definitly a bug!

    Thank to all for thinking with me.

    Best regards,

    Cees.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Return Order VAT not inline of Sales Order !

    Hello csteenbe2,

    I have a talk with some dev experts and got the information that - depending on the case that you have - the tax correction might not always result in the correct outcome.

    That is, especially when you have partial deliveries that are spread across months, partial returns or differences in the date of the packing slip and invoice/credit note postings then I would suggest that you have a chat with a dev expert as well to have a look into your specific case to resolve it.

    Best regards,

    Ludwig

  • csteenbe2 Profile Picture
    csteenbe2 30 on at
    RE: Return Order VAT not inline of Sales Order !

    Have created a fix for this bug, that calculates the VAT according the original sales order invoice date.

    The root cause of the bug is that we have prices including VAT and calculation is done on Line level.

  • csteenbe2 Profile Picture
    csteenbe2 30 on at
    RE: Return Order VAT not inline of Sales Order !

    Did search LCS, and found one - for what I could see we have implemented this, we are on R2CU9.

    I think the problem lies in the fact that we calculate VAT per Invoice line.

    Thanks for your help!

  • nunomaia Profile Picture
    nunomaia 10,684 Super User 2024 Season 1 on at
    RE: Return Order VAT not inline of Sales Order !

    I personally prefer to create new vat codes for VAT changes ( with date ranges ), it improves traceability of changes.

    Regardless of that, I think there were a correction in AX2012 for Sales Order return in VAT date determination.

    Did you search in LCS ?  

  • csteenbe2 Profile Picture
    csteenbe2 30 on at
    RE: Return Order VAT not inline of Sales Order !

    Invoice Date is set in Calculation date Type of the GL parameters.

  • nunomaia Profile Picture
    nunomaia 10,684 Super User 2024 Season 1 on at
    RE: Return Order VAT not inline of Sales Order !

    In general ledger parameters, in Calculation date type option, what value do you have ?

  • csteenbe2 Profile Picture
    csteenbe2 30 on at
    RE: Return Order VAT not inline of Sales Order !

    I did change only the values of the TAX % of the code's, with the dates from to.

    Old Tax % from 01011990  to 30062020 - 7%

    New Tax % from 01072020 to 31122020 - 5%

    So a return order from so order of lets say 01032020 should take the 7% of VAT% but it doesn't on line level - it takes the new VAT% 5% and that is not ok!

  • nunomaia Profile Picture
    nunomaia 10,684 Super User 2024 Season 1 on at
    RE: Return Order VAT not inline of Sales Order !

    Did you created new tax codes for the new VAT % or reused the same VAT code, by changing only the % ?  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans