Small and medium business | Business Central, N...

Sales Line customization

(0) Share

Report

Posted on by Community Member

Guys, i have an issue.

I was asked to make a customization so that if certain payment terms are selected, the unit prices on lines are increased. i've been trying to do this for a few days now and no success.

Categories:

Dynamics 365 Business Central

All responses (2)

Answers (0)

Sort by

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

What is the user process likely to be? Take default payment terms from customer most of the time? Or do they need to review it and make changes per quote/order/invoice?

Have you tried OnAfterValidate of the header field with an event subscriber yet?

Is the % uplift static and set against the payment terms? Does the standard pricing logic override your previous attempts?
Suggested answer

Tabrez Ajaz 789 on at

Like (0)

Report
Copy link

Link copied!

Hi @Yan,

As we know "Payment Terms Code" field is available in "Sales Header" table so make sure to update all the "Sales Lines" records related to the Sales Order, so you must have to write your code in OnAfterValidate trigger of "Payment Terms Code" field by extending the "Sales Header" Table something like this:

tableextension 50120 SalesHeaderExtn extends "Sales Header"

{

    fields

    {

        modify("Payment Terms Code")

        {

            trigger OnAfterValidate()

            var

                recSalesLine: Record "Sales Line";

            begin

                if xRec."Payment Terms Code" <> Rec."Payment Terms Code" then begin

                    // Wrote your logic here ...................................

                end;

            end;

        }

    }

}

You can also achieve this by creating a page extension for your "Sale Order" page like below:

pageextension 50130 SalesOrderExtn extends "Sales Order"

{

    layout

    {

        modify("Payment Terms Code")

        {

            trigger OnAfterValidate()

            var

                recSalesLine: Record "Sales Line";

            begin

                if xRec."Payment Terms Code" <> Rec."Payment Terms Code" then begin

                    // Wrote your logic here

                end;

            end;

        }

    }

}

I recommend you to write your code in table extension because the code written in Table will execute first.

Tested in Extension: