Dynamics Community Forum Thread Details

How to get the location updated on one go for all SalesLine

Hi ,

I have written a piece of code - when you change the order class, the salesline site and warehouse should also be updated. Thats working fine. Now issue is if I just click the save the location of the sales line doesnt get update. Now if i select any particular salesLine then its location gets updated. The tester wants that if i click save without selecting any salesline, the location should get updated for all the salesline at once. What am I missing? this is the piece of code i have written to update site and warehouse which is working fine.

SalesLine salesLine;
InventDim inventDim;

// Update all sales lines for this order with the specified field value
while select forupdate salesLine
    where salesLine.SalesId == _salesId
{
    // Use transaction control to ensure data consistency
    ttsbegin;
    
    // Load the related inventory dimension record
    inventDim = salesLine.inventDim();
        
    // Update the inventory dimension field
    inventDim.(_salesLineFieldId) = _fieldValue;                
        
    // Update the inventory dimension record
    salesLine.InventDimId = InventDim::findOrCreate(inventDim).inventDimId;     
        
    salesLine.doUpdate();
    ttscommit;

  }

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL