Finance | Project Operations, Human Resources, ...

How to make lowest sales price item value zero of sales order lines ?

(1) Share

Report

Posted on by JJDunaid

226

I am building a scenario where i have 2 lines in sales order .The scenario is that we have to compare the price of both lines with each other. The item with the lower sales price price will be updated to sales price = "0" by code. Can anyone provide me guidance on this ???

For example these are the given lines the item with 36 sales price will be updated as zero.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 306,640 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi JJDunaid,

What exact guidance do you need? Do you need help with coding to find the line with the lowest unit price? Is there any dependency on the quantity? What in case the line with unit price of 36 has a quantity of 500 where the line with price 240 has a quantity of 1?

Do you need the logic to be executed automatically, e.g. upon confirming the order or do you have a button for the user to click? Please let us know with more details where and how you need help.

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report
Copy link

Link copied!

Hi André ,
Yes, I have a trigger point from where the functionality will work on secondly, for instance there is no scope for quantity and Yes i need logic as i'm facing issue developing one.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 306,640 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi JJDunaid,

Thanks for the clarification you can try some coding like the next example.

public void setZeroPriceForLine(SalesTable _salesTable) { SalesLine salesLine; ttsbegin; select firstonly forupdate salesLine order by salesLine.SalesPrice asc where salesLine.SalesId == _salesTable.SalesId; if (salesLine.RecId != 0) { salesLine.SalesPrice = 0; salesLine.ModifiedField(fieldNum(SalesLine, SalesPrice)); salesLine.update(); } ttscommit; }

Was this reply helpful? Yes No