Dynamics Community Forum Thread Details

Class not getting next line when trieng to insert in my table

I was trying to insert data using while loop in my new table but it is not getting next line , when i use debugger i shows previous line in line number but i am inserting new line it should show line no 2 but it shoes line 1 in debugger. here is my code below.

internal final class DTCustomerNonPostedInV
{
  
	void NonPostedInv()
    {
        CustInvoiceTable                                 custInvoiceTable;
        DTInvoicesLineTmp                                dtInvoicesLineTmp;
        TaxRuntimeDocComponent                           taxRuntimeDocComponent;
        taxDocumentRowTransaction_IN                     taxDocumentRowTransaction_IN;
        taxDocumentRowTransaction                        taxDocumentRowTransaction;
        CustInvoiceLine                                  custInvoiceLine;
        TaxDocumentComponentTransaction                  taxDocumentComponentTransaction;
        TaxRuntimeLookup                                 taxRuntimeLookup;
        CustInvoiceJour                                   custInvoiceJour;
        TaxTrans                                          taxTrans;
        CustInvoiceTrans                                  custInvoiceTrans;
        TaxTable                                          taxTable;
        TaxComponentTable_IN                              taxComponentTable_IN;
        TaxAmountCur                                      sSgst,sIGST,sCGST;
        InvoiceId                                         invoiceId;
        //ParentRecId1                                     parentId;
        LogisticsPostalAddress                           logisticsPostalAddress;
        InventLocationId                                 inventLocationId;
        TransTaxInformation                              transTaxInformation;
        CustTable                                        custTable;
        LogisticsAddressStateId                          companyLocation,customerlocation;
        real                                             GSTRate = 0;
        HSNCodeTable_IN                                  hsntable_IN;
      
        ttsbegin;

        delete_from dtInvoicesLineTmp ;

        ttscommit;
      
        while select * from custInvoiceTable
            where 
                 custInvoiceTable.Posted == NOYES::No
                //&&  custInvoiceTable.InvoiceId == invoiceId
            join  custInvoiceLine
            where custInvoiceLine.ParentRecId == custinvoicetable.RecId
   
        {
            ttsbegin;
            dtInvoicesLineTmp.CustomerAccount = custInvoiceTable.OrderAccount;
            dtInvoicesLineTmp.Name            = custInvoiceTable.Name;
            dtInvoicesLineTmp.InvoiceId       = custInvoiceTable.InvoiceId;
            dtInvoicesLineTmp.LineNum         = custInvoiceline.LineNum;
            dtInvoicesLineTmp.MainAccount     = custInvoiceline.LedgerDimension;
            dtInvoicesLineTmp.Quantity        = custInvoiceline.Quantity;
            dtInvoicesLineTmp.AmountCur       = custInvoiceline.AmountCur;
            dtInvoicesLineTmp.DTChargeCode    = custInvoiceline.DTChargeCode;
            dtInvoicesLineTmp.DTInvoiceId     = custInvoiceline.DTInvoiceId;
            dtInvoicesLineTmp.DTItemId        = custInvoiceline.DTItemId;
            dtInvoicesLineTmp.DTInvoicedate   = custInvoiceline.DTInvoicedate;
            dtInvoicesLineTmp.DTSchemeCharge  = custInvoiceline.DTSchemeCharge;
            dtInvoicesLineTmp.DTInventLocationId  = custInvoiceline.DTInventLocationId;
            dtInvoicesLineTmp.DTInventSiteId  = custInvoiceline.DTInventSiteId;
            dtInvoicesLineTmp.insert();
            ttscommit;;
        }
        
   }
}

Quick Links