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

Retriving Tax Rate information in PLD

Hi Experts,

In PLD, how to fetch the individual tax rating of one item that item tax consists of (BETCESSHDCESS+VAT)Ex: 16%,2%,1%.and 4%. i want to print all this tax rates in single row of purchase order.

Can any one help me to solve this query.

karthi..

Edited by: Darius Heydarian on Apr 19, 2008 1:27 AM.

Edited by: Philip Eller on May 19, 2008 8:41 AM

Edited by: Philip Eller on Jun 2, 2008 8:37 AM*

Edited by: Philip Eller on Jun 16, 2008 10:18 AM**

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 Apr 19, 2008 at 04:00 AM

    Hi,

    You need to follow the steps.

    1. Add one more repetitive area.

    2. Add two fields in Repetitive area and three fields in footer

    3. Repetitive area first field props. as

    Source type - Database

    Table - Sales tax authorities

    Column - Name

    4. Repetitive area second field props.

    Source type - Database

    Table - A/R Invoice - Tax amount per document

    Column - Tax amount SC

    5. Repetitive are footer field 1

    field type - Text

    Content - Source type - Formula

    SortValue()

    6. Repetitive area footer second field props.

    field type - Text

    Content - Source type - Formula

    ColSum("Field_xxx")

    7. Repetitive area footer third field props.

    Source type - Database

    Table - Sales tax authorities

    Column - Name

    Add two more fields in footer

    8. 1 st one

    Field type = Text

    Content = 0 -


    (Zero)

    9. 2 nd one

    Field type = Text

    Content =

    <Field name of zero content(8 the step filed>!=

    <Field name of colsum field(6 the step field>

    example as

    Field_176!=Field_160

    Link this field in general area of the footer fields - Sales tax authority name, colsum field ( here steps 6 and 7 th fields)

    Hide the unnecessary fields except footer - sales tax authority name field and colsum field.

    Hope this help you,

    Regards,

    Venkatesan G.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Venkatesh i seen ur reply it is useful to me also but i m having some doubts on that i hope u can explain me better than tis reply.specially the relation between the fields(i.e:Relate to) and wat u mean by Field_xxx. if it possible pls explain me all the things once again so that i can solve my issue.

      Sankar

  • author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2008 at 05:40 AM

    *NOTE : Please make where A/r Invoice there A/p Purchase order*

    1Create a new template

    Open A/R Invoice and click on Print Layout designer icon to launch the window with

    list of templates, open an existing template and save a copy with a different name.

    Set this new copy as the default layout.

    2Add Repetitive area in the template

    Open this layout for editing by clicking on OK. This will also enable the Print Layout

    Designer menu items

    Identify the Tax Category

    To retrieve the Tax amount, we need to identify the Tax Category for which we go to

    the Query generator and select table OSTT and execute

    Create Identification fields in PLD template

    Now go back to the PLD template and add a new text field in this new repetitive area.

    In the field properties enter the ID of 4 derived in the previous step

    Retrieval of Tax Amount

    Now create a data field to pick the Tax amount from the Document Tax info table. In

    the File select A/R Invoice – Document Tax Info table and select the field Tax

    Amount which will retrieve the tax value from the document

    Calculating the total Excise Amount for the document

    Now to calculate the total Excise amount for the document, create a new calculation

    field below the formula field created in step 5.

    Retrieval of other tax components from the document

    Follow Steps 4-6 to retrieve CST/ VAT and any other tax component applicable for

    the document

    Formatting

    To get the Invoice in the required format create a Calculation field in the area ‘End of

    Report’. Select Type as Column Total and in the Column field select Total, which will

    show the total value of all the line items on which the taxes are to be calculated

    (Assessable value)

    Creation of Text fields to show the headings

    Create text fields to show the headings

    Display Text only if relevant tax applicable for

    document

    Now there could be a scenario, where not all the documents have Octroi tax. In this

    scenario, you would not like to show the text field Octroi if there is no Octroi tax

    applicable for the document. For this go to the field properties of the Calculation field

    used to calculate the total Octroi for the document and note down the Exclusive No

    from the General tab.

    Final Formatting

    Hide all the information not required to be printed in the Invoice but was used to

    generate the invoice in the required format. For hiding select the field properties

    window and uncheck Visible in General tab. I hide the Tax field and the entire

    Repetitive Area 1 added in the step 2

    Gopi

    Add a comment
    10|10000 characters needed characters exceeded

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.