Crystal Reports monthly revenue calculation

[Former Member]

Hy I would like to create a cross tab from B1 data sources to show the monthly revenue. I use SBO 8.8 and CR 2008.

My problem is that I don't know exatly how the SBO is calculating on the sales analysis.

Normaly is working like this:

(oinv.doctotal-oinv.vatsumoinv.rounding)-(orin.doctotal-orin.vatsumorin.doctotal)-(ocsv....)-(ocsi......)

Normaly the correcting invoices has parent invoice but some times not so I have also problems to chose the right linking field between the charts.

Thank you for the help!

Regards,

Balazs

[Former Member · Accepted solution]

Balazs,

No one here would know anything about the available data columns or the internal calculations in SBO. You will have much better luck posting your question in one of the [SAP Business One|/community [original link is broken]; forums.

If you get hung up with the report design itself, come back and post your design questions here.

Jason

[Former Member]

Hi Balazs,

Welcome you post on the forum

Only few users here have correction invoice due to the availability.

My suggest is using OJDT and JDT1 tables directly, You can filter them by TransType.

Thanks,

Gordon