Showing results for 
Search instead for 
Did you mean: 

Crystal Reports Template : Data for Cash-Flow Analysis

Former Member
0 Kudos

Dear Experts,

We are working on cash flow forecasting model, i.e going forward 12 months, which in written in MS Excel. We update it with actual data recorded in SAP B1 (Ver 8.8 PL18)  A manual process.

Was wondering if we can get a crystal report template which contain the following data:

Sales, Purchases, Collections and Payments by BP in a given time (user specified)

  • BP Code
  • BP Name
  • Sales Invoice #
  • Sales Invoice Date
  • Sales Invoice Value (total)
  • Sales Credit Memo #
  • Sales Credit Memo Date
  • Sales Credit Value (total)

  • Purchase Invoice #
  • Purchase Invoice Date
  • Purchase Invoice Value (total)
  • Purchase Credit Memo #
  • Purchase Credit Memo Date
  • Purchase Credit Value (total)

  • BP Receipt #
  • BP Receipt Date
  • BP Receipt Value
  • BP Payment  #
  • BP Payment Date
  • BP Payment Value

Thank you to all who have answered this question posted earlier under queries, I am hoping we can get a combined report using CR, a feat not possible using SAP B1 Query function. I look forward to your advice.



Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos


I am not familiar with crystal report. But using queries (that already answered) you can create crystal report.

You can also refer how to guide for creating crystal report in sap b1.

Thanks & Regards,