web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / To update CustPackingS...
Finance | Project Operations, Human Resources, ...
Answered

To update CustPackingSlipJour table using SalesLine

(1) ShareShare
ReportReport
Posted on by Dineshkarlekar 1,836
hi , 
i was trying to update the custpackingslipjour table with sales line , but i am not able to pass the value from salesline ,can anyone one guide me on this .
below is my code .
 
thanks ,
Dinesh
I have the same question (0)
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,836 on at 
    [ExtensionOf(tableStr(CustPackingSlipTrans))]
final class DTReturnOrderPackingSlipCustPackingSlipTrans_Extension
{
    public void initFromSalesLine(SalesLine _salesLine,
                                  boolean   _isExtensionIntrastatEnabled )
    {
        CustPackingSlipJour     custPackingSlipJour;
      
        next initFromSalesLine(_salesLine,
                                  _isExtensionIntrastatEnabled );

        if(_salesLine.DTReturnOrderPackingSlip)
        {
            select firstonly  custPackingSlipJour
              where custPackingSlipJour.SalesId == this.SalesId
               && custPackingSlipJour.PackingSlipId == this.PackingSlipId
               && custPackingSlipJour.DeliveryDate == this.DeliveryDate;

            if(custPackingSlipJour)
            {
                ttsbegin;
                custPackingSlipJour.selectforUpdate(true);
                if(custPackingSlipJour.DTReturnOrderPackingSlip)
                {
                    custPackingSlipJour.DTReturnOrderPackingSlip += ", ";
                }
                custPackingSlipJour.DTReturnOrderPackingSlip += _salesLine.DTReturnOrderPackingSlip;
                custPackingSlipJour.Update();
                ttscommit;
            }
        }
    }
}
    please let me know what is have to change .
     
  • Martin Dráb Profile Picture
    Martin Dráb 238,782 Most Valuable Professional on at
    Please explain your problem to us. It's not clear to me what you mean by "i am not able to pass the value from salesline".
     
    By the way, putting a list of comma-separate values to a field violates the very basics of a meaningful design of relational databases. The correct approach is creating a separate table (with 1:N relation) and putting values as records there.
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,836 on at
    hi martin 
    thanks for reply 
    i am having field on salesline named original packing slip , which i want to flow to  Custpackingslip jour table when the post packing slip so i use initfromsalesline() of custpackingsliptrans  , how can i flow the field from salesline to custpackingslipjour , i have custom field on custpackingslipjour , i am getting value in if(_salesLine.DTReturnOrderPackingSlip) but not able to update record in  custpackingslipjour.can you please guide me on this . i will remove that comma seperator part .
     select firstonly  custPackingSlipJour
              where custPackingSlipJour.SalesId == this.SalesId
               && custPackingSlipJour.PackingSlipId == this.PackingSlipId
               && custPackingSlipJour.DeliveryDate == this.DeliveryDate;
    i need to pass the value of sales line i am getting in to select query but not getting how to do it .
  • Martin Dráb Profile Picture
    Martin Dráb 238,782 Most Valuable Professional on at
    I'm sorry, but "not able to update record" says merely that you have a problem, but it doesn't describe the problem.
     
    Please tell us what prevents you from updating the record. For example, are you getting an exception? If so, at which line of code it is and what does the error message says? Or do you mean that your code doesn't even call update? Then use the debugger to find which condition is to blame.
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,836 on at
    hi 
    martin 
    thanks for reply ,
    when i use debugger the value in , is null ,
     
                if(custPackingSlipJour)
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,836 on at
    so i am not getting value in, i n need to pass the sales line in here to get if (custpackingslipjour)  
     
    select firstonly  custPackingSlipJour
              where custPackingSlipJour.SalesId == this.SalesId
               && custPackingSlipJour.PackingSlipId == this.PackingSlipId
               && custPackingSlipJour.DeliveryDate == this.DeliveryDate;
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,836 on at
    i have tried new select statement , but not getting value in here also sale line cannot pass record into related table, i have tested the query in sql it is working 
      select salesLine.InventTransId,salesLine.DTRETURNORDERPACKINGSLIP,custPackingSlipJour.PackingSlipId,* from custPackingSlipJour
	              join CustPackingSlipTrans
                   on  CustPackingSlipTrans.SalesId = custPackingSlipJour.SalesId  
                  and  CustPackingSlipTrans.PackingSlipId = custPackingSlipJour.PackingSlipId 
                  and  CustPackingSlipTrans.DeliveryDate = custPackingSlipJour.DeliveryDate
               join SALESLINE
                on  custPackingSlipTrans.SalesId  = salesLine.SalesId
               and  custPackingSlipTrans.InventTransId = salesLine.InventTransId
			     where salesLine.SalesId = '10188466'
				 and   salesLine.InventTransId = '04080278'
    but this is not getting values from sales lines. 
    select firstonly   custPackingSlipJour
                where custPackingSlipJour.SalesId == this.SalesId
                  && custPackingSlipJour.PackingSlipId == this.PackingSlipId
                  && custPackingSlipJour.DeliveryDate == this.DeliveryDate
                join custPackingSlipTrans
                where custPackingSlipTrans.OrigSalesId == _salesLine.SalesId
                  &&  custPackingSlipTrans.InventTransId == _salesLine.InventTransId;
     
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,836 on at
    hi ,
    i have simplyfy my code , hope you are getting my doubt .
    [ExtensionOf(tableStr(CustPackingSlipTrans))]
final class DTReturnOrderPackingSlipCustPackingSlipTrans_Extension
{
    public void initFromSalesLine(SalesLine _salesLine,
                                  boolean   _isExtensionIntrastatEnabled )
    {
        CustPackingSlipJour     custPackingSlipJour;
      
        next initFromSalesLine(_salesLine,
                                  _isExtensionIntrastatEnabled );

        if(_salesLine.DTReturnOrderPackingSlip)
        {   
             // i need to pass the value from sales line to get the record in custPackingSlipJour
            select firstonly  custPackingSlipJour
              where custPackingSlipJour.SalesId == this.SalesId
               && custPackingSlipJour.PackingSlipId == this.PackingSlipId
               && custPackingSlipJour.DeliveryDate == this.DeliveryDate;

           // here custPackingSlipJour is null  in debugger so i am not getting inside if 
            if(custPackingSlipJour)
            {
                ttsbegin;
                custPackingSlipJour.selectforUpdate(true);
                custPackingSlipJour.DTReturnOrderPackingSlip = _salesLine.DTReturnOrderPackingSlip;
                custPackingSlipJour.Update();
                ttscommit;
            }
        }
    }
}
     
     
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 238,782 Most Valuable Professional on at
    Are you saying that the actual problem is that the following query doesn't return any record (and the rest of code isn't relevant at the moment)? 
    select firstonly custPackingSlipJour
    where custPackingSlipJour.SalesId == this.SalesId
       && custPackingSlipJour.PackingSlipId == this.PackingSlipId
       && custPackingSlipJour.DeliveryDate == this.DeliveryDate;
    If so, I would start by checking whether this.SalesId, this.PackingSlipId and this.DeliveryDate contain expected values. If so, the explanation must be that the CustPackingSlipJour record doesn't exist. Then you should look again where you're using the code from.
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,836 on at
    yes 
    you r right  this. sales id is not getting any values and other fields too

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 514 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 390

#3
Adis Profile Picture

Adis 266 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans