adding discount field to project quotation!!!

(0) Share

Report

Posted on by Faqruddin

1,909

Dear Experts - I added fields Discount and Discount percent in Project Quotation Line Tab, but when I enter the values in both fields the Discount is not affected in Net amount. Please let me know whats going wrong with both fields...

Thanks in advance!!!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

5400 7,162 on at

Like (1)

Report
Copy link

Link copied!

Net amount won't get calculate automatically Only adding fields. you have write logic for same. In standard it is getting calculated through MAP. you can check salesline or pucrhline discount scenario and API. if you want to calculate through standard procedure you have mapped your field in standard flow with your custom code.

Was this reply helpful? Yes No
Sohaib Cheema 49,677 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

SalesQuotataion or ProjectQuotation are same technically

behind the scene, both share same Tables.

Now for Lines for Project quotation or for lines of Sales Quotation, table that is used is named as SalesQuotationLine

already this table has fileds LineDisc and LinePercent

if you will create a SalesQuotataion, these fields are visible

if you will create a ProjectQuotation these fields are hided.

so,

1) you should not add your customized fields without deep analysis [if existing fields can be enabled for case or ProjectQuotation]

2) I believe these can be enabled and you should try towards that, there are methods on SalesQuotationLine (Table) which behave differently based on quotation type

you need to go through those and fix it.

Note: if you will try to ask more deep things such as coding, very few people will be interested to do your job. you have to come back with some work and point if you are stuck somewhere during journey

Was this reply helpful? Yes No
Faqruddin 1,909 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply Sir. I need to calculate through standard procedure, but i don't know how to map my fields..

Was this reply helpful? Yes No
Faqruddin 1,909 on at

Like (0)

Report
Copy link

Link copied!

Dear Sohaib - I don't understand why this fields LineDisc and LinePercent not enabled on project quotation. Coming to sales it was fine, but both forms design with same data sources except methods in project quotation Form. I don't think there is no way to enabled this fields through methods. I customized the methods and code from sales quotation form to project quotation form, but no luck!

Thanks!!!

Was this reply helpful? Yes No
Abhijeet Kr 60 on at

Like (0)

Report
Copy link

Link copied!

Hi Faqru,

I have a similar requirement to implement discount and discount percentage in Project Quotation. Getting this field on form simply didnt enabled its working , as in case of sales quotation so i used the same code that they used in salesquotation for Disc and disc percentage modified but even after that it didnt work.

My question to you is have you found any work around for this issue you faced.

Any inputs will be highly helpfull

Thanks in advance,

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Here the unit discount is calculated:-

unitDiscountAmount =qty!=0.0?discountAmount/qty:0.0;

Here the discount is set on the sales line.Only the discount is set:-

salesLine.SalesPrice=price;

salesLine.LineDisc=unitDiscountAmount:

salesLine.LineAmount=salesLine.calclineAmountForced();

salesLine.update();

For discount percentage try to use retail discount rule.

Was this reply helpful? Yes No