web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Sales tax codes - Exte...
Finance forum

Sales tax codes - External codes

(0) ShareShare
ReportReport
Posted on by 12

IN D365FO in the module Tax > Inderect taxes > Sales tax > Sales tax codes you find the menu item External codes

7485.jpg

The External codes form looks like this:

5658.jpg

Does anyone know if this form can be used to e.g.

  • Calculate sales tax using another value
  • Report sales tax different from the standard reporting tools in the Tax module

Best regards

Sten Baumgarten

  • Satish Panwar Profile Picture
    14,673 Moderator on at

    Hi Sten,

    External codes are mostly used for integration purposes. I don't think it will help calculate any sales tax value. Usually used for mapping between companies or external system.

    For e.g. if you have Sales Tax Code "County" and in your reporting, you want to represent it as "StateCode", you can do that via external codes but extra logic will be required in reporting to use external codes. Also take a look at link below:

    community.dynamics.com/.../external-codes-vs-external-item-descriptions

    Thanks,

    Satish Panwar

    Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

  • Sten Baumgarten Profile Picture
    12 on at

    Hi Satish

    It seems the link you inserted do not mention sales tax codes but items, intercompany.

    Since Microsoft don't describe the functionality I was hoping that a community member have used the functionality using standard functionality within D365FO or AX2012. I can see that I did not mention that when I asked my question. Sorry.  

    Best regards

    Sten

  • Verified answer
    Ties Philippi Profile Picture
    962 on at

    Hi Sten,

    External codes are used to bridge the internal code to an external code. When looking at the screen above, you have an overview field and a value field. In the overview field you enter the general External Code group, like EAN / ISBN/ whatever. In the value field you enter the specific value for your tax code / related external code group. The setup here is not specific to tax and can be used throughout other fields using the external code functionality as Satish stated.

    Although as far as I know (if someone does know please correct me) there are no default reports present for the Tax module using these external codes, you can off course make an entity export of this (relatedtable = 1472 // relation = recid of the sales tax code ). Besides this you can integrate this in the digital declarations to the VAT authority (setup under Tax --> Setup --> Electronic Messages). This uses the Electronic Reporting framework in which you can retrieve / translate the internal codes to the external code.

    This should answer your second question, in regard to your first question, the bases for tax calculation is determined by the origin dropdown. The related document is always the bases, and for all of the options except for percentage of sales tax the line amount is taken as basis. If you would like to opt for sales tax on sales tax (like for example if you have packing duties which are taxable) then you can select the origin percentage of sales tax. After selecting this the box sales tax on sales tax becomes available in which you can select the base salex tax code it should start calculating on.

    Keep in mind though, that even though the setup is sales tax on sales tax you still have to include both the original sales tax code as the sales tax on sales tax code in the same sales tax group / item tax group.

    Hope this helps!

    Best regards,

    Ties Philippi

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans