Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sub Totals in PLD

Hi,

Can any one tell how can i calculated the sub totals regarding a column in PLD

Thanks & Regards

Ravi.K

Functional Consultant for SAP B1

New Horizons Cybersoft Ltd.

Hyd, AP, India.

replied

Hi,

I have taked an example of sales quotation here. Request you to please

follow the following steps in case you are using A cluster of Business one:

In addition to field "Field_025" which is part of the Systemtemplate,

and located in the Repetitive Area, add the following fields to the

template.

Create following field on PAGE HEADER

1. Field_Datafield1

General Tab

Left = 0 / Width = 0 / Top = 0 / Height = 0

Content Tab

Source Type = Database

Table = Sales Quotation

Column = Document Currency

Create following fields in REPETITIVE AREA

2. Field_Datafield 2

GENERAL TAB

Left = 0 / Width = 0 / Top = 0 / Height = 0

CONTENT TAB

Source Type = Database

Table = Sales Quotation-Rows

Column = Row Type

3. Field_Textfield 1

GENERAL TAB

Left = 0 / Width = 0 / Top = 0 / Height = 0

CONTENT TAB

Source Type = Free Text

(empty)

4. Field_Formula1

GENERAL TAB

Left = 0 / Width = 0 / Top = 0 / Height = 0

CONTENT TAB

Source Type = Formula

Field_Datafield 2 != Field_Textfield 1

5. Field_Formula2

GENERAL TAB

locate directly above field "Field_025"

Link to =Field_Datafield 2

CONTENT TAB

Source Type = Formula

Concat(Amount(Field_025)," ",Field_Datafield1)

6. Field_025

ID = Field_025

Link to = Field_Formula1

Hope this will help.

Regards,

Gagan Thareja

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question