PLD Freight in Repetative Area

[Former Member]

Hi Experts,

I have 20 items in A/R Invoice, and have 1 Freight amount say at 1500/-

I am trying to give detail in the A/R Invoice PLD, for this I added one more Repetative Area, but the Freigt details are appearing 21 times (as many times the number of items there are in the invoice).

How can I make the detail appear only once in the another repetative area.

Is there any way to group the freight field, and prevent it from appearing more than 1 number of times

Regards,

Murtaza R.E.

[Former Member · Accepted solution]

If you only need the summary of the freight, you can hide the detail. Only show summarized freight in repetitive area footer for the new area.

Thanks,

Gordon

[Former Member · Accepted solution]

Thanks Gordon,

This works perfectly if I have only 1 Additional Expense, now what do I do if I have more than 1 additional expense, say 500.00 for Handling Charges and 1500.00 for Transportation Charges.

I Tried a silly thing by having 2 repetative areas, and as you suggested placing the field from INV3 into the Repetative Footer, but I get the only 1 additional expense, repeating twice

At present I have only 2 types of additional expenses, tomorrow it could me more.

[Former Member · Accepted solution]

I had sent you a document Printing Additional Expenses (Freight) in PLD.pdf to your mail

murtaza1972@gmail

Please check this

[gagan_thareja · Accepted solution]

Hi,

Could you please try out the following:

1. Create UDFs on Marketing Document header level - number of UDF

depending on the max number of Additional Expenses from the OEXD

2. Use query like below for UDF1:

SELECT T2.EXPNSNAME + ' ' + STR(T1.LINETOTAL) + ' ' +

STR(T1.VATSUM) + ' ' + STR(T1.VATPRCNT)

+ ' ' + STR(T1.LINEVAT)

FROM OINV T0

INNER JOIN INV3 T1

ON T0.DOCENTRY = T1.DOCENTRY

INNER JOIN OEXD T2

ON T1.EXPNSCODE = T2.EXPNSCODE

WHERE T0.DOCNUM = $[OINV.DocNum]

AND T1.LINENUM = 0

Use query like below for UDF2:

SELECT T2.EXPNSNAME + ' ' + STR(T1.LINETOTAL) + ' ' +

STR(T1.VATSUM) + ' ' + STR(T1.VATPRCNT)

+ ' ' + STR(T1.LINEVAT)

FROM OINV T0

INNER JOIN INV3 T1

ON T0.DOCENTRY = T1.DOCENTRY

INNER JOIN OEXD T2

ON T1.EXPNSCODE = T2.EXPNSCODE

WHERE T0.DOCNUM = $[OINV.DocNum]

AND T1.LINENUM = 1

and so on.

3. Add the UDF to the Layout.

NOTE: The line number is important as there can be more than

one additional expense for the same Document Number;

Note that the query draws the details of one single record per

from the Add Expenses Table. You can make the amendments in the

query as required by either removing or adding more fields;

like increase space between the fields etc

Hope this will help.

Regards,

Gagan Thareja

SAP Business One Forums Team

[Former Member · Accepted solution]

Thanks Gagan,

You query explained what to do, however I have not created any UDF's, instead I have added another Repetative Area and getting the details from INV3, and OEXD approriately.

Thanks agains

Regards,

Murtaza

[Former Member]

I had sent you a document Printing Additional Expenses (Freight) in PLD.pdf to your mail

murtaza1972@gmail

Please check this

[jitin_chawla]

Hi,

Please check the following thread if it helps :

Regards,

Jitin Chawla