Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

Posted on by 350

Hi Everybody

Please, Is there any standard link between Invoice Taxes and its Payment taxes in GeneralLedger ?

Example :

Invoice1 :

Total Amount without VAT : 100

VAT (20%) : 20

Total Invoice including VAT : 120

Entries in GL (related to VAT only) : MainAccount XXXXX : +20

Payment1:

A partial payment : 60 for example

==> In GeneralLadger the VAT is 10 like that : MainAccount XXXXX : -10  MainAccount YYYYYY : +10

How Can link this +20 (in XXXXX Acount) and -10(in XXXXX Account too) ?

Thanks :)

  • JauB Profile Picture
    JauB 350 on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Hello

    Any update please ? 

  • JauB Profile Picture
    JauB 350 on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Hello Ludwig

    Please check the file attached( showing Porfile and Transaction Types) as requested.

    Posting_2D00_Trs_2D00_Type.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Hello JauB,

    The posting and transaction type fields are usually in the general tab of the voucher screens that you shared above.

    You can make a personalization of this form and add move them into the overview grid.

    Best regards,

    Ludwig

  • JauB Profile Picture
    JauB 350 on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Good Morning Ludwig

    Please can share with me the path from where I can get the posting types that you need ?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Good Morning JauB,

    Is it possible that you make new screenprints that show the posting types of the different vouchers?

    I don't know your account numbers and names and without the posting type I am not able to understand what has been recorded.

    When doing that, can you also share screenprints of the transaction origin of the different vouchers?

    Many thanks,

    Ludwig

  • JauB Profile Picture
    JauB 350 on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Hi Ludwig

    See the example attached for more details please.

    8738.VAT.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Hi JauB,

    Don't get me wrong. Technically, there is a relationship between VAT and payments that you make.

    Yet, the tax laws I am familiar with post VAT usually not at the time payments are made.

    There are some exceptions but in general, VAT is not posted with payments

    About your issue:

    I need more information on your accounts and the posting types used. A single account number does not help much. Can you share the vouchers created in AX?

    Best regards,

    Ludwig

  • JauB Profile Picture
    JauB 350 on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Hi Ludwig

    I'm very suprised to see that there is no relation between Value-added tax and the payment ! If my Item has a tax group =20% (For Sales) and I make a Sales Order on it, so the system will calculate its VAT as (LineAmount *20%) which will be in a special Account in GL (Let's say 100 $ in 44771000 account).

    When the customer pay us (partially or completly), or setting is to cancel the amount already saved in 44771000 and create the final entry in an other account (44772000 for example) with the same amount (100 $).

    For this scenario, we will have in GL these operations : 

    when posting the invoice sales order

    44771000 : 100$ 

    when posting the payment

    44771000: -100 $ 

    44772000 : 100 $

    For tax departement we check directly the total amount in 44772000 (here is 100 $ to pay to tax departement).

    I hope it's clear

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Looking for the Link between Invoice Taxes and Payment Taxes in GeneralLedger

    Hi JauB,

    What is the relationship between your VAT and the payment?

    VAT is usually not related to payments except for cash discounts.

    Can you possibly share a screenprint of the voucher including the posting types used when making the partial payment?

    Many thanks,

    Ludwig

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans