How to work with sales analysis?

[#1]

I have tables below

Delivery (This serves as your sales)

    Date               DR#     Item     Qty     Unit Price     Total Amount

    4/5/2012          1          A          2          10.00               20.00

    4/6/2012          2          C          5           5.00                25.00

Sales Return (This will be LESS to the Delivery to get the total sales)

     Date               DR#          Item          Qty

     4/10/2012       1                  A             1

Here's my question, How much is my Sale on April 2012? April 5, 2012, April 6, 2012?

I got puzzled.

[#2 · Accepted solution]

Hi,

You should always show it as on date.

So, your total sales should come as Delivery - Sales Return

Since, your return is on 10 April but you are not aware of it before 10 April. So, before 10 April you should show as

for Item A

Total sales = 20.00

on or After 10 April

for Iteam A

Total sales = 10.00

That way, you will always show the correct data which is as is available.

If needed you can also show it in 3 columns

Delivery  |   Sales Return | Effective Sales

..

Ashutosh

[#3]

Thanks Ashutosh. Got your point!