Skip to Content
author's profile photo Former Member
Former Member

How to achieve Item wise net profit ?

Dear Expert,

Is there anyway to find out Item wise net profit/lss ?

By net profit/loss I mean Sales Price - (Purchase cost + Direct Expense + Indirect Expenses)

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Dec 12, 2014 at 12:17 PM

    Hi Chintan
    Create a UDF in chart of accounts. Field Name "subject to net Profit" Valid values Yes \ No
    default value "N"
    for your selected indirect expense GL account codes, please make it YES

    You can directly take 1) Sales Price after discount 2) Item cost 3 ) gross profit from Sales table.

    To get the proportionate value of indirect expenses for a particular sales row, please use the following formulae

    Total Indirect expenses (sum of Debit & credit during the period) / Total Value of sales during the peiod * Line Total

    Hope above idea may help you

    Thanks

    Unnikrishnan Balan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 12, 2014 at 11:28 AM

    Hi Chintan


    Will u please tell me currently how do u post your Direct and Indirect expenses for Purchase, do u post at the same level of Invoice or separately

    Please provide us with the detail.


    Regards,

    Bhushan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.