Line item again contains multiple descriptions

[Former Member]

Dear Friends,

I have to print like

-

---

MAT_NO--

---

MAT_DESC

---

DELV_QTY---DELV_DATEUNIT_PRICE--TOTAL_RICE

-

---

3240A41--

---

SPRING

---

30--

---

10.06.2009

-

---

50----

---

12.06.2009

-

---

80--

---

20.06.2009

---

5.00--

---

500.00

-

---

basic_price----

---

100.00

-

---

discount----

---

10.00

-

---

Excise Duty----

---

12.00

-

---

3243CO--

---

FASTNERS

---

10--

---

13.07.2009

-

---

15----

---

17.07.2009

-

---

23----

---

05.08.2009

-

---

35----

---

10.08.2009

-

---

Basic Price--

---

10.00--

---

1000.00

-

---

discount----

---

30.00

-

---

Excise Duty----

---

50.00

-

---

How can i proceed.Plz any idiea??? Suggest me.

[Former Member · Accepted solution]

I think you can achieve this in 2 ways,

1) First collect all your unique material numbers into a internal table. Sort the main table based on material number

Now loop this internal table in the main window.

Inside this loop, loop your main table with where condition for the material and print the materials in a template.

once out of the inner loop, print the Discounts etc.

2) You can use events like AT END, AT BEGIN but you have to take care about the non-numeric fields.

Let me know if this works?

Regards,

Susanta

[Former Member]

Hi,

Get Item data and Conditions data in Smart forms.

Create Table.In that create 2 line types. One for Item data. another for item conditions.Based on Item Condition record number u can print item conditions as an iten wise.

[Former Member]

Hi Farooq,

Import your Item and conditions table with sorting on Material number and item number respectively.

Create a table for Item table with two line types. first corresponds to Delivery and second to conditions.

In the Main part add a loop on Conditions table with condition on item number in the second line type.

Here you can print condition values for Base price, discount and excise etc depending on Condition Type.

Hope this helps

Regards

Vijai

[Former Member]

Hi

In the Smart form , Follow these steps

1. In Main window create a Table then

Go to Data Tab -> mention the internal table name and work area

Under this, go to the sort criteria Give the MAT_NO and then select Event on sort End

check box.

2. In the Header Area of a table you can specify the descriptions

MAT_NO---MAT_DESC

---

DELV_QTY-DELV_DATEUNIT_PRICE--TOTAL_RICE

3. In the Main Area of a table you can specify these values like below

&MAT_NO&

&MAT_DESC&

&DELV_QTY&

&DELV_DATE&

&UNIT_PRICE&

&TOTAL_RICE&

4. In MAT_NO Event on Sort End

create text elements and display the following information

basic_price----

---

100.00

discount----

---

10.00

Excise Duty----

---

12.00

Try this once. I think it will solve your problem

Thanks

Sriiiiiiiii(Srikanth)

[Former Member]

Dear Farook,

You have to create two page-windows for this.

Header Window - For the details shown below:

MAT_NO--

---

MAT_DESC

---

DELV_QTY---DELV_DATEUNIT_PRICE--TOTAL_RICE

MAIN window - For the details shown below:

3240A41--

---

SPRING

---

30--

---

10.06.2009

-

---

50----

---

12.06.2009

-

---

80--

---

20.06.2009

---

5.00--

---

500.00

-

---

basic_price----

---

100.00

-

---

discount----

---

10.00

-

---

Excise Duty----

---

12.00

etc.

Call the header window outside the loop in calling program. So your headings will appear only once and details appear as per the loop repeates.

Regds,

Anil

[Former Member]

Hi,

Are you using Scripts or Smartforms?

[Former Member]

Hi,

I am using smart forms.and in driver program how the loops i can take.

[Former Member]

Hi ,

In smart forms no need to take loop in driver program, here driver program is just for triggering the smartform, You can make loop in the smartform itself.

regards

Hari reddy