Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Is it possible to post...
Finance forum
Answered

Is it possible to post VAT only supplier invoice?

Posted on by

Is it possible to post VAT only supplier invoice using Supplier invoice form?  We receive VAT only invoice relating to import. I know it is possible to post VAT only invoice using Invoice journal by populating VAT group, Item VAT group, and VAT code fields. I would like to find out whether it can also be achieved using Supplier invoice form. I work for a company in UK. 

  • mumuthu Profile Picture
    mumuthu on at
    RE: Is it possible to post VAT only supplier invoice?

    It is unlikely for my customer to receive £5m import VAT. I just testing with few sample numbers. 

  • Eugen Glasow Profile Picture
    Eugen Glasow 6,345 on at
    RE: Is it possible to post VAT only supplier invoice?

    Of course, the maximal precision you can achieve is LineAmount/Tax%/100 <= 0,01 where 0,01 is the rounding in the GL.

    Consequently, LineAmount <= Tax%

    How probably is it, to receive an import duty or import VAT of 5 mio GBP? Is your customer a high volume, low margin manufacturer or reseller?

  • mumuthu Profile Picture
    mumuthu on at
    RE: Is it possible to post VAT only supplier invoice?

    I have to refresh my memory on Lim mathematics function, but it appears to make sense.

    As I was testing further, I came across the following limitations. Although unlikely for VAT only invoice to have such a large invoice amount but something to consider I suppose.

    • If VAT Code set to 9,999,999,999.00 then maximum Invoice amount is £500,000.00
    • If VAT Code set to 99,999,999,999.00 then maximum Invoice amount is £5,000,000.00. Refer to example below.
    • Anything over this limit will add a value to Invoice Net amount which is not desirable.
    • 2019_2D00_06_2D00_07_5F00_12_2D00_02_2D00_57.png

    So, am I right to think there is no standard option (excluding the above workaround) available to achieve VAT only Pending supplier invoice in AX/D365? Similar to posting VAT only supplier invoice using journal.

    Thanks for your help. 

  • Eugen Glasow Profile Picture
    Eugen Glasow 6,345 on at
    RE: Is it possible to post VAT only supplier invoice?

    Well, it's the pure math:

    (Origin*100% + Origin*Tax%)/100% = LineAmount

    Origin = LineAmount /(1+Tax%/100)

    Lim(Origin, Tax% --> inf) = 0

  • mumuthu Profile Picture
    mumuthu on at
    RE: Is it possible to post VAT only supplier invoice?

    Thanks Eugen for you response.

    Yes, it is an ingenious way, and it works as expected. Do you know why VAT (tax) code is set to 9999999999 for this to work? It would be interesting to know. 

    I followed the steps below to post VAT only invoice via Pending supplier invoice form in AX2012 environment:

    1. Amended VAT code: 100% > Value to 9999999999
    2. Created a new Pending supplier invoice
    3. In Header view > Setup fast tab > Set Prices include VAT field to TRUE
    4. Entered Procurement category line
    5. In Line details, I selected values Item VAT group and VAT group fields that would result in VAT code: 100% selected by the system.
    6. In Totals form, I only have VAT field populated and Subtotal amount field is 0 as expected2019_2D00_06_2D00_06_5F00_22_2D00_58_2D00_44.png
    7. Successfully posted Pending supplier invoice. 

    Posted VAT entry only contains VAT amount and Amount origin is 0 as expected.

    2019_2D00_06_2D00_06_5F00_22_2D00_58_2D00_44.png

    Only minor downside to this method is, it creates an additional Voucher transaction for 0 amount.

    2019_2D00_06_2D00_06_5F00_23_2D00_06_2D00_32.png

  • mumuthu Profile Picture
    mumuthu on at
    RE: Is it possible to post VAT only supplier invoice?

    Hello Ludwig,

    Thanks for your response.

    Am I right to think, the above noted steps are to post VAT only invoice via Supplier invoice journal and General journal? As tax (VAT) code field is not available in Pending supplier invoice form.

    Regards

    Muthu

  • Verified answer
    Eugen Glasow Profile Picture
    Eugen Glasow 6,345 on at
    RE: Is it possible to post VAT only supplier invoice?

    I have seen a crazy solution once. We also needed to post the invoice from the customs broker, and we did not want to divert the process flow to GL journals because of all the good workflows and OCR built around the Pending supplier invoices. A colleague of mine activated the Tax included mode and created a tax code with the % of 9999999999. Ingenious, isn't it?

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: Is it possible to post VAT only supplier invoice?

    Hi Mumuthu,

    I concur with Ludwig. The procedure to fill the Tax code directly works in invoice and general journals. You have to check also settings on the main account. Do not set the option to block manual posting. The Posting type should be set to 'Sales tax'. This will prevent using this account manually without the Tax code. As result, it will create a Tax transaction with the full amount as Tax amount which then can also be included on Sales tax reporting.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Is it possible to post VAT only supplier invoice?

    Hi mumuthu,

    In the past I often received invoices from DHL, UPS, Fedex that included some tax amounts that we directly had to pay.

    To get them posted correctly you have to enter the tax code directly into the tax code field - no need to enter the VAT group / item VAT group fields.

    As account, you have to select the tax account directly. What I posted were regularly import taxes or something alike for which we used a separate account. This is the account that you have to select in the journal.

    Please test in a demo/test version first and carefully check the voucher.

    Best regards,

    Ludwig

  • Suggested answer
    Sten Baumgarten Profile Picture
    Sten Baumgarten 8 on at
    RE: Is it possible to post VAT only supplier invoice?

    Hi Mumuthu

    Do you receive an invoice when you make an import?

    If yes i guess you have to pay the invoice to the authorities?

    Can you get the import invoice amount refunded from the authorities?

    If yes, to get the refund, do you have to include the import amount when you report vat to the authorities?

    If yes, i will create a vat code for that purpose and include the code when you post the import invoice. Debit can be in P&L or balance and credit a seperat main account in the part of your vat main account.

    Kind regards

    Sten

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans