cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Business One/Crystal reports

0 Kudos

Hi,

Kindly assist. I have created a crystal report displaying group/subtotals of customers invoices and credit notes. When i preview my report, I am not getting an accurate summary as the credit note totals are not subtracted from the invoice totals.

Accepted Solutions (1)

Accepted Solutions (1)

former_member205766
Active Contributor
0 Kudos

Hi

Can you post the screen shots for more clarity ?

With Regards

Balaji Sampath

0 Kudos
Former Member
0 Kudos

Right now you're summing the totals of the invoices and credit notes. You'll have to make Crystal realize that the credit notes should be deducted. You could accomplish this by creating a formula that checks if the document is a credit note and then multiply it's DocTotal by -1. You should then be able to summarize that formula for the correct total.

0 Kudos

ok. I will try it out and let you know.

0 Kudos

I am not well vast with crystal reporting. Kindly guide me on how to go about this.

Former Member
0 Kudos

What is the name of the field displaying "Credit Note" or "Invoice"?

0 Kudos

I created a view in SQl hence name of the filed is

EIM2_invoiced_n_credited.Description(string)......

Former Member
0 Kudos

Create a formula and use something like the following then sum the formula in your group footer.

if EIM2_invoiced_n_credited = "Credit Note" then

     ORIN.DocTotal * -1

else

     OINV.DocTotal

Answers (0)