Validation on sales line sales price is not less then average cost price in x++

(0) Share

Report

Posted on by DEEPAKNONU

207

Hi Experts,

I need to give the validation on the sales line when users enter the sales price less than the average cost price. The message shows them " the sales price is less then Item price."

Thanks in advance.

All responses (7)

Answers (0)

Kariem El Sayed 10 on at

Like (0)

Report

RE: Validation on sales line sales price is not less then average cost price in x++

Hey Mr. DeepPanknonu

How did you solve it as i have similar requirement.
DEEPAKNONU 207 on at

Like (0)

Report

RE: Validation on sales line sales price is not less then average cost price in x++

Hey Mr. Will, thanks for your valuable solution but I'm using 2012 R3 version of AX and also I solved my issue thanks.
DEEPAKNONU 207 on at

Like (0)

Report

RE: Validation on sales line sales price is not less then average cost price in x++

Hey Mr. Spike, thanks for your valuable suggestion I solved my issue with put the validation on validate write method on sales line table.
WillWU 22,352 on at

Like (0)

Report

RE: Validation on sales line sales price is not less then average cost price in x++

Hi DEEPAKNONU,

You could try to use form datasource field event "onValidating" to validate the salesprice.

Go to SalesTable(form)->DS->SalesLine->salePrice->events.
Gao Lu Wang 180 on at

Like (0)

Report

RE: Validation on sales line sales price is not less then average cost price in x++

Hi Deepaknonu,

can you add the validation code in the table salesline's validateFieldValue method?
DEEPAKNONU 207 on at

Like (1)

Report

RE: Validation on sales line sales price is not less then average cost price in x++

Hey Dr.Ludwig, I really appreciate your response and your suggestion . I already use this standard feature but my client need that, If the user gave the less cost then the item average cost price in sales price. Then user cannot proceed for further steps. That's why I need to put validation in X++ as I mention in my question.
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Validation on sales line sales price is not less then average cost price in x++

Hi,

Would this standard feature do the job?

organicax.com/.../

Best regards,

Ludwig