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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Sales Tax reporting in trial balance is different between Vendor Invoice Journals and PO Invoices

(2) ShareShare
ReportReport
Posted on by 320

Hey, 

 

I was running a trial balance for our sales tax payable main account and looking at the transactions. When it is a Vendor Invoice Journal the tax is split out on the voucher into the 3 sales tax codes we have, one line per sales tax code [blue brack group in pic]. When I look at a Purchase Order Invoice, it is one line for the sales tax [highlighted in red], and then I need to click the Posted Sales Tax on the top ribbon to see the split. 

 

Is it possible to have the Vendor Invoice Journal report in the same manner? Is there a setting I can use to do this?

6204.Screenshot_5F00_1.png

 

Thanks!

 

 

 
Categories:
I have the same question (0)
  • 72camaross Profile Picture
    320 on at

    Does anyone know where this configuration exists if it is a configuration issue?

  • André Arnaud de Calavon Profile Picture
    301,075 Super User 2025 Season 2 on at

    HI J D,

    For the purchase order invoice, there is no setting to change this behavior. It is summarizing the transactions.

  • 72camaross Profile Picture
    320 on at

    Thanks, Andre.

    That is what I am seeing. Do you know if it is possible to configure the Vendor Invoice Journal to behave in the same manner? Roll up the sales tax into 1 line?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,075 Super User 2025 Season 2 on at

    Hi J D,

    There is a setting on the journal name called 'Detail level'. If you set this to summary, it will cumulate the entries by voucher, account, dimensions, date and transaction text.

  • 72camaross Profile Picture
    320 on at
    Thanks Andre. I was able to explain why an the difference. They could summarize the journal, but choose not to.
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 434 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans