Skip to Content

Sales Gross Profit unit price after total document discount

Hi all

How to obtain in Query or Crystal Report Design Sales unit price amount from Gross Profit for Sales transaction after allocated total Sales Discount amount? This information is visible in Gross Profit of Order icon.

xgls4.png (51.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 20 at 11:45 AM

    Hi Kedalene,

    All this information is stored in the details table (RDR1 for sales order).

    The sales price (560 in your case) is RDR1.INMPrice

    Gross profit: RDR1.GrssProfFC - for foreign currency, RDR1.GrssProfSC - for system currency and GrssProfit - for loacl currency

    Base price (in local currency): RDR1.GrossBuyPr

    Please take a look at this field, I believe it will help you to build the necessary query

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20 at 09:48 AM

    in sales order table you have base price field you can calculate gross profit in a simple query by deduction base price from sales price

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 22 at 04:22 AM

    Hi,

    Sales price = Row total / quantity.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded