Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

(0) Share

Report

Posted on by Sunil G Kurup

130

Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin).

Enabled Margin alert in AR parameters, and we can see margin alert in Sales Order line, but if provide the lesser value , system will accept.

As per the organizations rules, below cost invoice ( zero margin) should be restricted. So How can we enable the validation message to inform users before posting like storage/tracking dimension validation

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Sunil G Kurup 130 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Not yet solved, because if we have running Sales Agreement we need to omit the validations. We are working on the customization, once its finished will update the status

Was this reply helpful? Yes No
RaviRaj 530 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Hi Sunil,

Issue resolved means verified the answer,its useful to some other users.

Was this reply helpful? Yes No
Sunil G Kurup 130 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Informed our programmer to do the validation.

Was this reply helpful? Yes No
guk1964 10,886 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Its a little more tricky in that the default functionality sets the margin for the whole sales order. Which is fine when you are only concerned with 0 margin threshold. However if you have a different minimum margin by item then customisation is needed. The order can then be set to hold or you can customise further for the system to do this and for an approval processes to be followed.

We typically have to do this for most customers.

Was this reply helpful? Yes No
RaviRaj 530 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Its working now ..??

Was this reply helpful? Yes No
Sunil G Kurup 130 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Thanks willl try

Was this reply helpful? Yes No
RaviRaj 530 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Hi Sunil,

Use the below code to salesline table -->validatefield method :-

CostPrice costPrice;

InventQty costInventQty;

AmountCur costInventValue;

InventTable inventtable;

[costInventQty, costInventValue] = InventTrans::calcCostValue(InventTransOrigin::findByInventTransId(this.InventTransId).RecId);

if (costInventQty)

{

costPrice = costInventValue/costInventQty;

}

else

{

costPrice = inventTable.costPcsPrice(updatesalesline.InventDimId);

}

if(costPrice < this.salesprice)

{

error("unit price less than cost price");

}

Was this reply helpful? Yes No
Sunil G Kurup 130 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Cost Validation message if entered unit price under cost. After manager approval need to post

Was this reply helpful? Yes No
RaviRaj 530 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

You need only validation message or get approve from manager tell me..

Was this reply helpful? Yes No
Sunil G Kurup 130 on at

Like (0)

Report

RE: Restrict the sales order Packing slip & Invoice post if the item price below cost ( zero margin)

Thank your for your reply. Could you please explain, how can we configure

Was this reply helpful? Yes No