‘Customer Test Customer (£)’ is buying Milk.
In March he has bought Milk for £1,500.00 (+VAT), invoice MILK001 has been issued, but then changed mind end returned Milk for £500 (+VAT) back.
Credit Note has been issued for this transaction, and PL statement shows right income amount £1,000
but ‘Sales Invoice by Item’ report still shows Milk £1,500.00, what is not right and obviously is not taking into account Credit Note, what is incorrect, because item has been refunded.
Both Invoice and CN has got the same item MILK in form: