Dear Sir/Madam,
My name is Herald Dsouza. I hope this e-mail finds you in good condition.
I am preparing a sales report. I have situations wherein the customers place the order in advance and we book the order by providing them the reserved invoice number.
The actual sale will be on the next day or after a day.
Now my question is, while preparing the sales report, the future dated order also gets added to the current day's total sales amount, which is incorrect.
Do you have any formulas to exclude the future dated order from the total sales of the current day? (The future order will be added to the sales report on the day when the actual sale will happen in the future.)
Your valuable suggestion on the above-mentioned query is highly appreciated.
Awaiting for your response on this mail.
Thanks & Regards,
Herald Dsouza.
View attachment 61860View attachment 61860
My name is Herald Dsouza. I hope this e-mail finds you in good condition.
I am preparing a sales report. I have situations wherein the customers place the order in advance and we book the order by providing them the reserved invoice number.
The actual sale will be on the next day or after a day.
Now my question is, while preparing the sales report, the future dated order also gets added to the current day's total sales amount, which is incorrect.
Do you have any formulas to exclude the future dated order from the total sales of the current day? (The future order will be added to the sales report on the day when the actual sale will happen in the future.)
Your valuable suggestion on the above-mentioned query is highly appreciated.
Awaiting for your response on this mail.
Thanks & Regards,
Herald Dsouza.
View attachment 61860View attachment 61860