Crystal Reports Template : Data for Cash-Flow Analysis

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.

Regards

Raj