Skip to Content
0
Former Member
Dec 03, 2008 at 08:02 AM

Monthly report

33 Views

Hai Forum,

I need a report that automatically send email each date 5 for result of total last month revenue period

with assumption

GL Account

41111 Sales Product A

41112 Sales Product B

41113 Sales Product C

41114 Sales Product D

42111 ....42114 Sales Return Product A ... D

43111 ...43114 Sales Discount Product A... D

51111.....51114 Cost of Goods Product A.....D

The result report ;

GL Account - GL Name Description - Net Sales - Budget Sales - % Profit Margin

41111 Product A 10000 9000 10%

41112

41113

41114

Profit margin = (( Sales -S Return - S discount) - COGS) / COGS)

Thanks