Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Tax amount not showing in Sale Transaction Smart List

(0) ShareShare
ReportReport
Posted on by 1,110

I have a problem, when from smart list I browse sale transaction, a specific invoice did not show tax amount column, but when I drill down that invoice then tax amount is showing on sales transaction inquiry zoom window. this invoice is of history (not of current open year). how can I solve this issue???

what are the tables which belongs to the smart lists???

*This post is locked for comments

  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    1,110 on at
    RE: Tax amount not showing in Sale Transaction Smart List

    running checklinks on sales, solve the problem,and now all is well...thx Mahmoud M. AlSaadi

  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    1,110 on at
    RE: Tax amount not showing in Sale Transaction Smart List

    can u guide me , on which series and tables should I run checklinks ?

  • Verified answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Tax amount not showing in Sale Transaction Smart List

    There is no logical justification behind having the tax amount not showing while it is there on the tables, it would be highly recommended to run the check links and reconcile.

    Your feedback is appreciated.

  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    1,110 on at
    RE: Tax amount not showing in Sale Transaction Smart List

    with only one transaction , tax amount for all other transactions are shown. weather checklinks solve this issue ??? or any other solution ?

  • Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Tax amount not showing in Sale Transaction Smart List

    Does this happen with a specific sales document or all documents within the Sales Transactions Smart List ?

  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    1,110 on at
    RE: Tax amount not showing in Sale Transaction Smart List

    yes, I selected Tax Amount Column, but in that amount is 0. but when I double click and sales transaction inquiry zoom window appear and tax amount is present there.

    as this is history transaction, so this transaction is present in SOP30200 and SOP30300 , and amount is present in table in SOP30200 under TAXAMNT and ORTAXAMT column. but now showing in smart list .

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Tax amount not showing in Sale Transaction Smart List

    On the Sales Transaction Smart list, go to (Columns) and add (Tax Amount) to display the tax amount associated with the sales transactions, it is not shown in the smart list as a default column.

    As for the Sales Transactions Tables; 

    • SOP10100 | Sales Transaction Work
    • SOP10200 | Sales Transaction Amounts Work
    • SOP30200 | Sales Transaction History
    • SOP30300 | Sales Transaction Amounts History

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans