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