cancel
Showing results for 
Search instead for 
Did you mean: 

Customised Crystal report Query and Design?

Former Member
0 Kudos

Hi Experts,

i have attached an image of a customer's ageing analysis in SAP and the customer wants a customized report that will display exactly as it is.

the customer wants to see the cumulative balance per customer is it in the image attached with the population been on invoices and JE as well as it in the SAP ageing .

Please your urgent reply is needed.

Atleast the query to help me arrive at this and probably a sample crystal report design.

Regards

Justice

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Justice,

Please repost to the SAP B1 space.

-Abhilash

TammyPowlas
Active Contributor
0 Kudos

Abhilash - thank you - I didn't realize it was related to B1

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

Justice - the easiest and fastest way (assuming you are already on Enhancement Pack 5 in SAP) is to use the Crystal Business Suite Viewer and use the ALV report in the screen shot as a data source to Crystal.

In theory, depending on requirements, no additional new query design would be needed in Crystal.

Please see this discussion at http://scn.sap.com/thread/3470261

Tammy