At the time of creating the , Profit & Loss account , In row structure how to get the net profit and where the + and - calculation are going means (exactly in row structure where the total income and expenses are deducted ) is there any calculation setup in row structure for getting net profit and finally how to add these net profit to balance sheet
You have two options within financial statements either: -
1. Use calculations or;
2. Use a range
So, to calculate the net profit you can either use (1) above and use a calculation to take the total sales, less direct costs, less over heads, or use (2) a range that includes all of the profit and loss accounts.
For the balance sheet, I would suggest you use a range of all the profit and loss accounts.
It is always a good idea to check any calculations against a range to ensure that the calculations are valid and you haven’t missed out any accounts.
Hi John, on a related note, how could we show net sales in P&L supposing that I have
Net Sales = Sales - Discounts
Sales include a range of accounts say 3000 to 3100
Discounts include say 3200..3280
I am able to show the totals for sales and disounts, However, how to show the net? Appreciate your thoughts. Could we use a calculations if so, how? thanks
I am going with Range and that helped. Thanks a lot.
The rande is not helping me because it alredy appears in the financial statement, I cant use the same range more then one time.
I think the calculation might help me, but i dont know how to use it. can any body help me with that? how can i use the argument
table in the calculation? how can i add argumants to the table?
© 1995-2013 Dynamics User Group, all rights reserved.