Retriving Tax Rate information in PLD

[Former Member]

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**

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Hi Venkatesan Govindan ,

I have tried already triyed this ... any thanks a lot..

Here am using preprinted sheet, while am printing there is an huge gap from one field to other ... i need it in very closely.... if u r not getting ... i will again explain to you..

[Former Member · Accepted solution]

Hi,

I understood you requirement. But it is beyond the explanation thru' remoute. Eventhough I can give you the little bit tips.

1. Define multiple repetitive area for each tax type viz. BED, Cess etc.,

2. Try to filter and get the tax by using sortvalue and colsum.

3. Fix the lables in End of report area for Each tax.

4. Get the value for relevant lables.

hide the repetitive area fields.

I hope this will help you????!!!!

Regards,

Venkatesan G.

[Former Member · Accepted solution]

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

[Former Member]

*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