Financial Statement -net profit calculation

Finance and Operations/AX User Forum
1

Hi,

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

Thanks

2

Hi Kola,

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.

Cheers.

3

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

4

I am going with Range and that helped. Thanks a lot.

5

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?

Thanks,

Ifat

6

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?

Thanks,

Ifat