Sales Gross Profit unit price after total document discount

[kedalenechong]

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.

[former_member390407 · Accepted solution]

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

[kothandaraman_nagarajan]

Hi,

Sales price = Row total / quantity.

Regards,

Nagarajan

[Abdul]

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