Importing a Crystal Report file in SAP B1

[Former Member]

Hi All,

I am using Crystal Report Basic 2008 and was able to create a rpt file and connect to the SAP B1 (through import option in Admin-> Setup -> General -> Report and Layout Manager) Purchase order screen,But i am not getting a series wise records.

i.e. i have 2 series in PO screen as Primary and PO and both starts from DocNum 1 (have diff period indicator) but when i use it in CR as Parameter is ask series as input every time. So pls guide me with proper method.

hope u all will do the needful

Thank u,

[Former Member · Accepted solution]

In the report you have to insert a parameter that allow to display the correct document.

You have to create a paremeter named

DocKey@

and then you have to create the follow filter

{[table name].DocEntry} = {DocKey@}

example for a/r invoice

{OINV.DocEntry} = {DocKey@}

Regards

Paolo

[bhavank_gajjar]

Hi..

I Think you can not go with DocEntry as user dont knows DocEntry so try to Go with Three Parameters on Crystal Report.

1. Posting Period

2. Document Series

3. Document Num

Regards,

Bhavank

[Former Member]

@Paolo Orlando and @Bhavank ,

thank u for your time. As u all have suggested i have created 3 parameters as DocKey@,Series@ and Date@ and it works fine in CR Preview mode. But when i import it in SAP B1 and try to preview the report then it ask for series and posting date as input parameter but where as DocKey is automatically picked from PO Form.

So pls can u all correct me where i m wrong.

Thank u,

[bhavank_gajjar]

Hi..

Please Check that the all three parameters you have Created are Static or Dynamic!!

Make Proper Selection of parameters using Dynamic Parameter Creation

Regards,

Bhavank

[Former Member]

@Bhavank,

I have created parameter as static. y dynamic is required here? (as it is mentioned in help doc as dynamic is required when we want to fetch data from db). but i am assigning my CR as layout it so it should take docnum, posting date from current instance which is open and show the respective CR.but in my case docnum will take from screen but posting date and series is asking as input!!!

correct me if i m wrong somewhere.

thank u,

[bhavank_gajjar]

Hi..

Try one thing do not open PO Document on SAP and just run crystal report from SAP and check it is asking for all three parameters or not??

Regards,

Bhavank

[Former Member]

Yes it ask for the values as input.

[bhavank_gajjar]

Hi..

you got your o/p on Crystal Report from SAPBO as you are getting in Crystal Report Developer??

Regards,

Bhavank

[Former Member]

yes i am getting proper o/p as i can see in CR preview.

[bhavank_gajjar]

Hi..

Please Close the Thread and mark the Question as Answered and Give Proper Points

Regards,

Bhavank

[Former Member]

But when i open my CR as layout with PO form it still ask for posting date n series!!!!!

[bhavank_gajjar]

Hi..

Remove that parameter of Series & Date i think SAP will automatically pass for you to Crystal Report.

Regards,

Bhavank

[Former Member]

No if more than 1 series starts with same DocNum (eg 1) then report will show 2 records in CR

[Former Member]

Have you checked the filter in the report?

SAP need an only token (DocKey@) to shown the correct document.

The type of DocKey@ parameter is "number"?

Regards.

Paolo

[bhavank_gajjar]

Hi..

Then You might Require to Change Document Series Numbering make unique numbering series.

Regards,

Bhavank

[Former Member]

@Paolo,

I have created DocKey@ as number but my problem is, in table DocNum is not unique i.e i have 2 series and both DocNum starts from 1! so when ever i pass only DocNum to CR it takes 2 records from both of the series.

[Former Member]

In the filter is used the dockey and not the docnum.

The series linked to a document type cannot have identical number.

I don't understand your problem.

Regards.

Paolo

[bhavank_gajjar]

Hi Shraddha,

Exactly i agree with Paolo its not possible to apply same document numbering to different different series in SBO. i also not getting how you have define same document numbering to both different different series??

Regards,

Bhavank

[Former Member]

Hi,

i have a data as below (OPOR table)

DocKey DocNum Series and other details.........

1 1 Primary(i.e any numeric value)

2 2 Primary(i.e any numeric value)

so on..................

3 1 User Defined(i.e any numeric value)

4 2 User Defined(i.e any numeric value)

so on.................

Now both the series have different period indicator (i.e primary is of default(sap one) and User defined is of 2010-11).

and now whenever i want to show the report for PO No 1 from any of the series it takes both the records!!!

i hope its clear for u all!

Thanks and Regards,

Edited by: Shraddha P on Sep 24, 2010 3:42 PM