Skip to Content
author's profile photo Former Member
Former Member

Tax Amount not print in PLD - Purchase Order

Hi

I am trying to print the Tax Breakup in Purchase Order PLD . But i am unable to get the results. Following is my approach. Can any body guide me where i had made mistake.

PLD for Purchase Order

Step - 1

Created on Repetitive Area (Repetitive Area1)

Step - 2

Created Text field (F_192)--------------------------- for VAT (-7)

Created DB Field (F_193)------------------- Table - Sales Tax Authorities Type

Columnb - ID of NOTA Fiscal Tax Category

Created DB Field (F_194)-------------- Table - Purchase Order - Tax Amount per document

Column - Tax Amount

Created Formula Field(F_195) --------- "F_192==F_193"

Created Formula Field (F_196)------- "F_195*F_194"

Step - 3

End of Report

Created Text Field (F_198) - Content - vat amount (linked to field f_196)

Created Formula Field (F_197) - ColSum("F_196")

The Issue is:

If I link F_196 to the text field in end report i didn't get any output (it doesn't even displays the text field or formula field output in the end of report)

If i didn't link the any formula field the text field it simply prints the text field and not the tax amount.

I have made the repetitive are 'Invisible" as well

Am using SAP B1 9.0 PL-4

Can anybody guide me on this Issue.

thanks & regards

L.Sriram

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 08:52 AM

    Hi Sriram,

    Please share your email so that I can send a document to you on how to tax break up in PLD.

    Also, an easy option would be to create udf's at header level and use fms to capture the tax amount and map these udf's in the PLD.

    Thanks,

    Joseph

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 01:09 PM

    Hi Sriram,

    Plese find mentioned below the query to get tax break up on udf of purchase order:

    Declare @TaxAmt Decimal(16,3)

    Set @TaxAmt = ( SELECT Sum(T0.[TaxSum]) FROM POR4 T0 Where Docentry = (Select Docentry from OPOR

    Where DocNum = $[OPOR.DocNum] and Series = $[OPOR.Series]) and statype = 4 )

    Select @TaxAmt

    Run the query Select * from OSTT to get the Statype and replace to get break up of different tax types and attach it to the udf, refresh on doctotal.

    Please note that the values are updated once the document is added.

    Hope this helps.

    Thanks,

    Joseph

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Joseph

      I have one more clarification on this PO PLD requirement

      UDF's created at Marketing Document Level. I had made the FMS in PO screen and getting the output in the PO PLD.

      What should I do to get the tax components in other document PLD's (grpo, invoice etc.,)

      regards

      sriram

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.