Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Answered

Retail sales posting, tax calculated wrongly for returns

Posted on by 145

Hi AXians,

I have a very strange behaviour and i would like to know if anyone else came through some cases.

I will explain by an example.

Item I001 have a sale and return in same shift.

Now during sales posting, system created sales order and invoiced with one line of sale and one line of return.

Now the sale line got posted with tax and return sale got posted without tax.

This endup in Total zero qty sales, but gross value not equal to zero.

We checked by creating manual sales order with same item, tax group, customer - but there was no issue at all.

Can anyone guide please the way to troubleshoot this.

  • Mohammed Jabir OM Profile Picture
    Mohammed Jabir OM 145 on at
    RE: Retail sales posting, tax calculated wrongly for returns

    Yes this is for AX 2012 version.

    Thanks.

  • Verified answer
    A.Prasanna Profile Picture
    A.Prasanna 8,161 on at
    RE: Retail sales posting, tax calculated wrongly for returns

    Is this for AX Retail or D365 Commerce ?

    if it is AX2012R3 just check this out

    Issue 3741981 - Resolved

    Incorrect tax calculated for sales transactions after posting a statement including a return transaction

    Product and version: AX 2012 R3

    Release: CU11

    KB number: 3156441

    Fix type: Application update

    fix.lcs.dynamics.com/.../Details

  • Suggested answer
    Ramune Profile Picture
    Ramune on at
    RE: Retail sales posting, tax calculated wrongly for returns

    Hi Mohammed,

    please check some setup:

    - 'Marginal base' set to 'Net amount per line' on Sales tax code

    OR

    - Set ‘Tax calculation behavior’ to ‘Recalculate’ in Commerce parameters/Tab Payments

    Try the same steps and let me know if this helped.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans