Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Posting a purchase inv...
Microsoft Dynamics NAV (Archived)

Posting a purchase invoice for an EU supplier (LCY is GBP)

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi everyone

I'm new to the forum and was hoping you could help with a query. I am using NAV 2013 R2 and the local currency of the company is GBP. I want to post a Purchase Invoice for a non stock cost, carriage in, from an EU supplier.

I have created a new GL code called Carriage In EU and I have the Gen. Busn. and Prod Posting groups set to EU codes that have a default VAT Prod. Posting group of EU. The Vendor has VAT & Gen. Busn. Posting group of EU.

However, when I try to enter the Purchase Invoice, I select the type of G/L Account, but when I enter new newly created GL code I get the error message, "VAT Bus. Posting Group cannot be EU. EU can only be used for domestic customers and vendors."

I cannot see what I am missing in my posting groups setup and would be grateful for any help.

 

*This post is locked for comments

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Posting a purchase invoice for an EU supplier (LCY is GBP)

    maybe following helps.

    it seems that there is a condition in table purchase line, when setting/changing the "VAT Prod. Posting Group" value in the line (normally not shown; is automatically set, when the No. field is set; "VAT Prod. Posting Group" gets the value from the current G/L Account):

    if the value of "VAT Bus. Posting Group" in purchase line is the same value as of "Reverse Charge VAT Posting Gr." in purchase setup

    AND

    the value of field "VAT Bus. Posting Group" in the purchase header is not the same as value "Domestic Vendors" in the purchase setup

    THEN

    you get that error.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Posting a purchase invoice for an EU supplier (LCY is GBP)

    Hi Jonathon - wish i could post screen shots. A bit more information - our company uses very little of the NAV functions as we have a separate product for sales order processing, purchase order processing and inventory.

    I have a new customer that wants to use NAV to post supplier invoices that are not stock/item related. I had no problems testing this until they wanted to post an invoice for an EU supplier. The VAT Busn. Posting group on the vendor card is EU. I have a similar set up as Cronus for VAT Posting Group - VAT Busn. = EU is linked to VAT Prod. = VATE, reverse charge VAT.

    The GL codes however have a default VAT group of Normal/VATS.

    I have kept the General Posting Groups as Normal because the inventory invoices won't be done in NAV.

    In the Purchasing Setup I have tried to have Reverse Charge VAT Posting group set to EU and Domestic Vendors set to both EU and Normal and I have tried leaving these fields blank. Either way I get some kind of error message.

    The only way I have been able to get EU supplier invoices to post is to have a VAT setup of VAT Busn = EU, VAT Prod = VATS (20%) with reverse charge VAT setup.

    I know this problem willbe something to do with my setup but I am at loss of what to change.

    p.s. thank you for taking the time to reply

  • Suggested answer
    keoma Profile Picture
    keoma 32,675 on at
    RE: Posting a purchase invoice for an EU supplier (LCY is GBP)

    do you mean, you created a new G/L Account, then made a new purchase line with type G/L Account and selected that new G/L Account?

    if yes, what is the value of the "VAT Bus. Posting Group" of that (new) G/L Account?

    what did you set in the field "vat bus. posting group" of the purchase invoice header (fasttab invoice)?

    check the purchase setup:

    do you have there fields "Reverse Charge VAT Posting Gr." and "Domestic Vendors"? if yes, what are the values of these fields?

    in general: the error message is specific for the UK localised version of NAV.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Posting a purchase invoice for an EU supplier (LCY is GBP)

    Hi Jonathan - i thought i would need a new GL Code with different posting groups as the existing GL code has posting groups that point to standard rate vat of 20%. But because the Vendor is EU with a rate of VAT0, i get an error message each time i try to post an invoice to the EU supplier. I get the following error message "VAT Bus. Posting Group cannot be EU. Eu can only be used for domestic customers and Vendors.

  • keoma Profile Picture
    keoma 32,675 on at
    RE: Posting a purchase invoice for an EU supplier (LCY is GBP)

    why do you need a new GL Code "Carriage in EU"? do the standard values not fit for your purpose?

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans