web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics GP (Archived) / Tax amount not showing...
Microsoft Dynamics GP (Archived)

Tax amount not showing in Sale Transaction Smart List

(0) ShareShare
ReportReport
Posted on by c4c4571f00c7433e841... 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

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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
  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    c4c4571f00c7433e841... 1,110 on at

    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 .

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

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

  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    c4c4571f00c7433e841... 1,110 on at

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

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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
    c4c4571f00c7433e841... 1,110 on at

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

  • c4c4571f00c7433e8415e0e1141719d2 Profile Picture
    c4c4571f00c7433e841... 1,110 on at

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

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans