Update SalesLine Unit price on changing the size in Microsoft Dynamics AX 2012 R2

Question

how to approach this? Change the value of unit price in the Sales line on changing its size, As far as I know the default unit price comes from trade agreements. In this case there would be no size, but for my requirement I should assign value from trade agreements for sizes 1,2,3,4 and for 5 and 6 the the value from trade agreements should be incremented with 1. i.e

For example sizes 1,2,3,4 -> 13$ and sizes 5,6 -> 14$

I am thinking to approach this making changes in the modified field method on InventSizeid in SalesTable form, is this the right approach or is there a better way to do this. Any help appreciated, thanks in advance

Your task doesn't require any development. AX has standard functionality for this. — Aliaksandr Maksimau, Apr 25 '17 at 14:48

score 0 · Answer 1 · answered Apr 24 '17 at 22:39

Check SalesTable form go to Data Sources/InventDim/Fields/InventSizeId/Methods/Modified open modified method, you need add your logic in the end of this method.

For example (this is standar method modified):

public void modified()
{
    SalesCalcAvailableDlvDates salesCalcAvailableDlvDates;

    super();

    salesLine.modifyInventDim(inventDim, fieldNum(InventDim,InventSizeId), !salesLine.MatchingAgreementLine);

    if (salesLine.DeliveryDateControlType)
    {
        salesCalcAvailableDlvDates =  SalesCalcAvailableDlvDates::newCommonSalesDlvDateType(salesLine,0,inventDim);
    salesCalcAvailableDlvDates.modifiedFieldBeforeInsert(salesLine);
    }
    salesLine_DS.cacheCalculateMethod(tableMethodStr(SalesLine,itemName));

    //Your logic
    ...
    ...
    ...
    SalesLine.SalesPrice = 999; //Your new sales price.
    //Your logic END
}

you probably need to perform salesLine_DS.reread(); or salesLine_DS.refresh(); to see new price (else press F5 in form).

@Aliaksandr Maksimau the value 999 Clearly should not be it's only example, Must be replaced by the value calculated in their logic. — Jonathan Bravetti, Apr 25 '17 at 14:48
Just think that there can be thousands of products and any price change will require the participation of a programmer — Aliaksandr Maksimau, Apr 25 '17 at 16:05

score 0 · Answer 2 · answered Apr 25 '17 at 14:34

0

You can specify prices for product variants based on size, color etc. using the trade agreements. Please check the following link.

answered Apr 25 '17 at 14:34

Aliaksandr Maksimau

2,251
12
21

Update SalesLine Unit price on changing the size in Microsoft Dynamics AX 2012 R2

2 Answers2