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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to get the Tax det...
Microsoft Dynamics GP (Archived)

How to get the Tax detail % to print on SOP invoices?

(0) ShareShare
ReportReport
Posted on by Community Member

Is there a way to add the Tax percent on the SOP Invoice depending on the Tax detail ID?

What about the Report Writer User-Defined function: RW_TXGetPercentOrAmountString        I can't find any info in SDK about this function and parameters required. 

Anyone knows and could help me?

Thanks,

Sylvie

 

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: How to get the Tax detail % to print on SOP invoices?

    Hi Sylvie

    Granted this is a really old post, do you recall if you ever found any information on this RW function?

    If so, please could you share.

    Many thanks.

    Ana

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to get the Tax detail % to print on SOP invoices?

    Hi,

    I believe this function returns a string and requires 3 parameters to be passed to it in this order:

    in 'Tax Detail Base' 
    in 'Tax Detail Percent'   
    in 'Tax Detail Amount'  

    I don't know if this will get you what you want, but I think I have the parameters correct. Give it a shot and see what you get.

    Kind regards,

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to get the Tax detail % to print on SOP invoices?

    Sylvie,
    Are you looking for each line to have the taxdetail ID and Tax % charged each line? There would be a 'sub' line equal to each of the tax details assigned to the tax schedule. Or, do you just want the taxschedule ID and the sum of the percentages of each detail. This won't give you an accurate number because the tax base is still unknown. Alternatly, you could just do the math and figure out the tax percentage using simple arithmatic divide the total tax amount for that line to the price of that line.
    What are you looking for?
    Kind regards,
    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: How to get the Tax detail % to print on SOP invoices?

    Another question:

    How do want to handle serial or lot numbered items. If you don't have any, the solution is straightforward. If you do have serial or lot numbered items, it gets more complicated.

    Leslile

  • Community Member Profile Picture
    Community Member on at
    RE: How to get the Tax detail % to print on SOP invoices?

    Hi Leslie

    Do you know of a way to display the Tax Detail Percent on the RM Blank Document report footer?  This is required for a UK customer where there is only one tax rate applied per transaction.  The fallback position is do a calculation as you mentioned above, however, this can lead to rounding errors/discrepancies.

    I've added the Sales/Purchases Tax Master table to the report and added the applicable field, but it just displays as 0% even though the transaction has a 20% tax rate applied...

    Thanks in advance.

    Regards

    Ana

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: How to get the Tax detail % to print on SOP invoices?

    You can create a formula field to get the percentage of tax

    'SOP_LINE_WORK'.'Tax Amount' *  100  )   /   (  'SOP_LINE_WORK'.'Extended Price' -  'SOP_LINE_WORK'.'Trade Discount Amount' 

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans