Query PLD

[Former Member]

Hi,

I have a specific requirement from my client, where i have to get the batch no. and serial no in my invoice print layout. I did this using query pld.

When i did that using query pld i'm getting result in row level. But my client requires bill to address, customer name and document id, document date should be in header level. I tried with giving link to ... but it is not working. Is there any method by which i can get the output.

[former_member186095]

Hi,

I have tested the query PLD I created by adding some fields in the header and it is excluded in the query. It is as same as your current problem. The result is not as same as standard PLD. In B1 2007A or B, it is resolved. Temporarily it must still be separated or try to use crystal report.

Rgds,

<http://tech.groups.yahoo.com/group/SBO_Knowledge_Village/>

[former_member583013]

Query PLD would purely print what is in the results of your query. If you want the Customer and other information..they also need to be added in your SELECT statement which forms your query

[Former Member]

(Hi,

I have a specific requirement from my client, where i have to get the batch no. and serial no in my invoice print layout. I did this using query pld.

When i did that using query pld i'm getting result in row level. *But my client requires bill to address, customer name and document id, document date should be in header level.* I tried with giving link to ... but it is not working. Is there any method by which i can get the output.)

Sorry my question was not clear!!!

I included customer name and other information...in my SELECT query but the problem is out put is in row level. I want some of the fields in Header Level.. as query output is row level only

[Former Member]

Hi

The simplest way to do this is to create few UDF's in Invoice and ask the customer to manually enter the Serial Nos/ Batches in the UDF. Now print this UDF in PLD.

Note: I suppose this shortfall of Printing Batch/ Serial nos in Invoice is overcome in SAP B1 2007B release.

[former_member583013]

Try this..

Add a Formula Type field on the Header for each Field from the row that you want to print on the Header....

For bill to address, customer name and document id, document date ...you will need 4 formula fields on the Header

On the content Tab of the Formula field just selec the related Field from the Row.

Let us say your Bill to Address field on the row is Field_204....you will Select this field in the Forumula field 1 on the Header.

This way you will select one field for each formula field

[Former Member]

Thank you,

I tried that also but it is giving error message as

*+'Printing Error: Field is not evaluaed yet (RPT-6718)(Field: Field227) [Message 200-38]'+*_

[former_member583013]

Forgot to mention ..the Formula field would only work on the Repetitive area Header.. you would need to work around with the Area sizing so that it can print like the Header. Since the Repetitive area values are not evaluated..at the page Header stage you are getting the Error

[Former Member]

Thank You Very Much

Please give more details about the same.

[former_member583013]

What more do you need..Just move the field from Page Header to R A Header (just where you see the column headings)

Go the RA Header properties and increase the Height

the move the col heading to the Bottom for that block and Keep your formula field on the Top