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 :
Small and medium business | Business Central, N...
Suggested Answer

The VAT GL Posting using the same dimension as the Sales Line

(2) ShareShare
ReportReport
Posted on by 2,510

Hi,

 

The client would like the dimension analysis for the VAT GL code to always be a certain value. However it seems when you post a Sales Invoice the dimension analysis is always taken from the line. Is there anyway to change this behaviour using core functionality?

 

For example:

The GL code for VAT has a default dimension as per below:

 

pastedimage1657698322484v1.png

 

 You then select a different dimension on the line:

 pastedimage1657698333339v2.png

 Then when you post the transaction the dimension on the VAT GL line is taken from the Sales Line rather than the default on the GL VAT code setup:

 pastedimage1657698372942v4.png

 

I’ve tried using “Same Code” on the VAT GL dimension setup but this gives an error:

 pastedimage1657698410894v6.png

I suspect there’s no way of changing this behaviour but would appreciate anyone's thoughts on this in case I've missed something.

I suppose the answer is if you are always going to use the same dimension code than analysing to one single dimension code doesn't really matter as you can just take the total value of the GL code. (this is my immediate thoughts anyway however there may be other reasons for this) . However if anyone knows of a method using core functionality to I'd be interested to hear.

 

Many thanks for your help

Gavin

 

 

 

 

I have the same question (0)
  • Suggested answer
    Marco Mels Profile Picture
    Microsoft Employee on at

    Hello,

    What is the dimension for the Sales Line itself, (Related Information, Dimensions)?

    Thank you.

  • Suggested answer
    JAngle Profile Picture
    157 on at

    The VAT G/L is a by product of the revenue/expense posting. It can’t be overlooked in core way of working. A modification could achieve what you require

  • Suggested answer
    Andri Wianto Profile Picture
    406 on at

    Hi Gavin,

    I assume you input G/L Account No. 10100 (Income Services) on Sales Line. Am I correct?

    VAT account is dependent of the Sales Account or Expense (Sales Line). You do not direct posting to that VAT account. That's why, the dimension used in Sales Line,  is used as the VAT account dimension value.

    You cannot use different dimension on Sales account (10100) and VAT account (56100). Because IMHO it will be confusing when you have dimension value OFFICE for Sales Account, but HOME for the VAT account.

    VAT is related/dependent of Sales account.

    With regards to Default Dimension Priorities, this setup will not work, because like I stated above, this is about account that is dependent of other account. So, you can't control the dimension value of the VAT account.

    Hope it helps.

    Kind Regards,

    Andri Wianto

  • Ruslans Klimovs Profile Picture
    10 on at

    Hi!

    Is it possible to BLOCK dimension applying to VAT records?

    For mentioned above example we would like to have the following records:

    - Sales of goods (10100) - OFFICE

    - VAT account (56100) - no dimensions ... because it is Balance sheet account

  • Suggested answer
    IB-29041624-0 Profile Picture
    1,177 Moderator on at

    No, that is not possible without customization.

  • Ruslans Klimovs Profile Picture
    10 on at

    Thanks!

  • NA-18060854-0 Profile Picture
    20 on at
    Hi 
     
    I have the exact same issue
     
    did you manage to work around this?
     
    if yes then how? :)
     
    many thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,825 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 967 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 652 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans