Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Actual Sales tax amount

(0) ShareShare
ReportReport
Posted on by 10

Hi

When I create a General journal with two lines (Ledger and Project) I get an error with sales tax direction and a discrepancy between General ledger and subledger Tax. 

First I create a line where I want to post a VAT amount on a main account for manual VAT. I add the relevant Sales tax code under the General pane.  

pastedimage1632396144168v1.png  

Under Sales tax menu I have the following information about the calculated VAT and Tax direction:

pastedimage1632396325385v2.png

Then I add the amount on the lene with Account type Project. This is the only addition to the journal. 

pastedimage1632396407653v3.png

This change the Actual tax amount but the Sales tax direction is the same´. 

pastedimage1632396516892v4.png

It seems that the same issue exist when I use Customer instead of Project, but not if my offset account is another main account. 

Have one of your experts experienced the same issue and do you have a solution where the Actual sales tax amount does not change based on the offset Account type?

Best regards

Sten

  • Sten Baumgarten Profile Picture
    10 on at
    RE: Actual Sales tax amount

    Hi Saurabh

    I thought the same as you but the feature "Enable independent sales tax calculation of general journal" that previous was not enabled solved the issue after I enabled it.

    Best regards

    Sten

  • Sten Baumgarten Profile Picture
    10 on at
    RE: Actual Sales tax amount

    Hi Alireza

    The version is 10.0.18 PU42.

    I did not use Sales tax group and Item sales tax on the line in the journal but sales tax code. This to be able to post directly on the main account for manual VAT.

    The feature you mention was not enabled. After I enabled the feature I got the result I was hoping for. This means that your suggestion solved the issue.

    Thank you for your help :-)

    Best regards

    Sten  

  • Suggested answer
    saurabh bharti Profile Picture
    15,033 Super User 2025 Season 1 on at
    RE: Actual Sales tax amount

    Hi Sten,

    We faced this issue earlier where system was taking sales tax receivable as direction instead payable.

    That looks to be bug but now in current version, we don't see the issue.

  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    13,668 Super User 2025 Season 1 on at
    RE: Actual Sales tax amount

    Hei Sten,

    Which product version have you done this test? Have you added tax setup for the journal line with project type also?

    I have just done this test on standard 10.0.21 while i cannot find the same behaviour.

    pastedimage1632410534927v1.png

    I have checked the journal line with "Ledger" account type and I cannot find that the Actual sales tax amount changes based on offset account.

    pastedimage1632410843534v2.png

    Have you tried to activate the following feature? Nice if you can activate this and test again the same scenario

    pastedimage1632410929477v3.png

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,219 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,980 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans