Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales Tax reporting in...
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 72camaross 281

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:
Dynamics 365 Finance
  • 72camaross Profile Picture
    72camaross 281 on at
    Sales Tax reporting in trial balance is different between Vendor Invoice Journals and PO Invoices
    Thanks Andre. I was able to explain why an the difference. They could summarize the journal, but choose not to.
     
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,001 Super User 2025 Season 1 on at
    RE: Sales Tax reporting in trial balance is different between Vendor Invoice Journals and PO Invoices

    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
    72camaross 281 on at
    RE: Sales Tax reporting in trial balance is different between Vendor Invoice Journals and PO Invoices

    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?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,001 Super User 2025 Season 1 on at
    RE: Sales Tax reporting in trial balance is different between Vendor Invoice Journals and PO Invoices

    HI J D,

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

  • 72camaross Profile Picture
    72camaross 281 on at
    RE: Sales Tax reporting in trial balance is different between Vendor Invoice Journals and PO Invoices

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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,001 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,837 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans