Sales Analysis - Gross Profit

[Former Member]

Hello,

I have a question regarding Gross Profit from Sales Analysis when a Credit Note is issued. For demostration purposes I use a dummy database and items

Let's say I buy this item for 10 EUR

and then I sell it for 100 EUR

but I also create an AR Credit Note like this

When I run a Sales Analysis report for that item I get this result

Shouldn't the Gross Profit in this case be 800 EUR?

Since I bought the item for 100 EUR, I sold it for 1000 EUR and gave a credit note for another 100EUR

So far I tried the following and the sales analysis report is the same

- I used a Credit Note with the "Without Quantity Posting" option both enabled and disabled

- Made sure that in the Document Settings the Base Price is set as the Last Purchase Price and I tried both Profit / Sales and Profit / Base

Thanks in advance for your answers

[former_member308222]

Hi,

Calculate Gross profit difference between COGS (accounting at the time of delivery) and sales invoice amount.

Now you create a credit note or debit note without delivery but with reference of the Invoice number so you have reference number of invoice for calculation.

Calculation like

(Sales Invoice + Debit note - Credit note ) - COGS amount

If any query or have any help msg I will.

- Rajkumar Mane