Dynamics Community Forum Thread Details

Hello,

Sorry, I am relatively new to X++, so apologize for asking what might have a simple solution.

We have custom code to update custom tables with a parent/child relationship when a sales order is confirmed. The code uses ttsbegin/ttscommit for inserting new records.

The issue we have is when the transaction is complete, it writes a child record before it writes the parent record, in general, not an issue, except we are also using dual write to a CE environment and the child table has a lookup to the parent table in CE. Since the parent record isn't written first, we are getting an error in dual write on the lookup in CE.

Is there a way to make sure that the parent record is written first?

Thank you for your response. It is not writing any of the records to the table until the transaction is complete. We had the process in debug, and when it does the insert for the parent record, it is not in the parent table. It inserts all of the child records first, before actually writing to the tables, but it seems as if it is writing the child records first since dual write sync happens as the records are being written.

Here is the code:

[ExtensionOf(tableStr(CustConfirmTrans))]
final class MazCustConfirmTransTable_Extension
{
   
    /// 
    /// mca Srikrishna sallam  12-2-2021 - 12096 Sync Asset Tables COC for Insert method
    /// 
    public void insert()
    {
        next insert();
        this.SyncAssetandAssetAccesoriesTable();
    }

    public void update()
    {
        next update();
        this.SyncAssetandAssetAccesoriesTable();
    }

    public void SyncAssetandAssetAccesoriesTable()
    {
        SalesTable                  salesTable;
        SalesLine                   salesLine;
        InventTrans                 inventTrans;
        InventDim                   inventDim;
        InventTable                 inventTable;
        EcoResProduct               ecoResProduct;        
        EcoResProducttranslation    ecoResProducttranslation;
        InventTransOrigin           inventTransOrigin;
        MazSOTableAttributes        mazSOTableAttributes;
        MazInventTableAttributes    mazInventTableAttributes;
        SalesTotals                 salesTotals;
        MazCommissionAmount         mazSumCommissionAmounts;


        select firstonly salesTable where salesTable.SalesId == this.SalesId
            join mazSOTableAttributes where mazSOTableAttributes.SalesId == salesTable.SalesId;

        if(salesTable.RecId)
        {
            select firstonly inventTable where inventTable.ItemId == this.ItemId
                join    mazInventTableAttributes where mazInventTableAttributes.ItemId == inventTable.ItemId
                join    ecoResProduct where ecoResProduct.DisplayProductNumber == mazInventTableAttributes.ItemId
                join    ecoResProductTranslation where ecoResProductTranslation.Product == ecoResProduct.Recid;


            select firstonly inventTransOrigin
                where inventTransOrigin.InventTransId  == this.InventTransId
                join inventTrans where inventTrans.inventTransOrigin == inventTransorigin.RecId
                join inventDim where inventDim.inventDimId == inventTrans.inventDimId;

            
            //no check needed for serial number as this is sales order shipping status and by now we will have the Serial Number
            if(mazSOTableAttributes.RecId)
            {
                MazAssetMasterTable mazAssetMasterTable;
                switch(mazInventTableAttributes.MazItemType)
                {
                    case MazItemType::Machine :
                      
                        /// check Asset record exists, if record exists update it not create.
                        if(inventDim.RecId &&
                            inventDim.inventSerialId &&
                            inventTrans.StatusIssue == StatusIssue::ReservPhysical)
                        {
                            ttsbegin;
                            select firstonly forupdate  RecId, CustAccount , mazSerialNum
                                from                    mazAssetMasterTable
                                where                   mazAssetMasterTable.MazSerialNum == inventDim.inventSerialId
                                &&                      mazAssetMasterTable.CustAccount == salesTable.CustAccount;

                            if(mazAssetMasterTable.RecId &&
                                mazAssetMasterTable.CustAccount &&
                                mazAssetMasterTable.mazSerialNum)
                            {
                               
                                //mazAssetMasterTable.InItFromMazInventTableAttributes(mazInventTableAttributes, salesTable, inventDim);
                                mazAssetMasterTable.InItFromMazSOTableAttributes(mazSOTableAttributes, salesTable, inventDim);

                                // MCA Connect - Justin Tibbetts - 02/17/2022 - Mazak_12096_CEAssetTableIntegration
                                mazAssetMasterTable.MazSalesPoolId = salesTable.SalesPoolId;
                                mazAssetMasterTable.MazModelCode = mazSOTableAttributes.ModelCode;

                                salesTotals = SalesTotals::construct(salesTable);

                                mazSumCommissionAmounts = salesTable.MazCommissionAmount1   salesTable.MazCommissionAmount2   
                                    salesTable.MazCommissionAmount3;

                                mazAssetMasterTable.MazSalesAmtLessDistComm = salesTotals.totalBalance() - mazSumCommissionAmounts;
                                
                                if (salesTable.ShippingDateConfirmed == dateNull())
                                {
                                    mazAssetMasterTable.MazEstimatedShipDate = salesTable.ShippingDateRequested;
                                }
                                else
                                {
                                    mazAssetMasterTable.MazEstimatedShipDate = salesTable.ShippingDateConfirmed;
                                }
                                // MCA Connect - Justin Tibbetts - 02/17/2022 - Mazak_12096_CEAssetTableIntegration

                                mazAssetMasterTable.MazProductNumber = this.itemId;
                                mazAssetMasterTable.MazProductDescription = ecoResProducttranslation.Name;

                                if(mazAssetMasterTable.ValidateWrite())
                                {
                                    mazAssetMasterTable.update();
                                }
                            }
                            else
                            {
                                mazAssetMasterTable.InItFromMazSOTableAttributes(mazSOTableAttributes, salesTable, inventDim);

                                // MCA Connect - Justin Tibbetts - 02/17/2022 - Mazak_12096_CEAssetTableIntegration
                                mazAssetMasterTable.MazSalesPoolId = salesTable.SalesPoolId;
                                mazAssetMasterTable.MazModelCode = mazSOTableAttributes.ModelCode;

                                salesTotals = SalesTotals::construct(salesTable);

                                mazSumCommissionAmounts = salesTable.MazCommissionAmount1   salesTable.MazCommissionAmount2  
                                    salesTable.MazCommissionAmount3;

                                mazAssetMasterTable.MazSalesAmtLessDistComm = salesTotals.totalBalance() - mazSumCommissionAmounts;

                                if (salesTable.ShippingDateConfirmed == dateNull())
                                {
                                    mazAssetMasterTable.MazEstimatedShipDate = salesTable.ShippingDateRequested;
                                }
                                else
                                {
                                    mazAssetMasterTable.MazEstimatedShipDate = salesTable.ShippingDateConfirmed;
                                }
                                // MCA Connect - Justin Tibbetts - 02/17/2022 - Mazak_12096_CEAssetTableIntegration

                                mazAssetMasterTable.MazProductNumber = this.itemId;
                                mazAssetMasterTable.MazProductDescription = ecoResProducttranslation.Name;
                                mazAssetMasterTable.insert();
                            }
                            ttscommit;
                        }
                        break;

                    case MazItemType::Other :

                        MazAssetAccessoryTable mazAssetAccessoryTable;

                        SalesTable                  salesTable1;
                        SalesLine                   salesLine1;
                        InventTrans                 inventTrans1;
                        InventDim                   inventDim1;
                        InventTransOrigin           inventTransOrigin1;
                        MazInventTableAttributes    mazInventTableAttributes1;

                        ttsbegin;
                        /// check Asset accessory record exists, if record exists update it not create.                        
                        select firstonly    salesline1
                                where           salesline1.SalesId == this.SalesId
                                join            mazInventTableAttributes1
                                where           mazInventTableAttributes1.itemId == salesline1.itemId
                                &&              mazInventTableAttributes1.MazItemType == MazItemType::Machine
                                join            inventTransOrigin1
                                where           inventTransOrigin1.InventTransId  == salesLine1.InventTransId
                                join            inventTrans1
                                where           inventTrans1.inventTransOrigin == inventTransorigin1.RecId
                                join            inventDim1
                                where           inventDim1.inventDimId == inventTrans1.inventDimId;
                        

                        // add the exists or find method to the table move this query there
                        select firstonly forupdate  RecId
                            from                    mazAssetAccessoryTable
                            where                   mazAssetAccessoryTable.MazSerialNum == inventDim1.inventSerialId
                            &&                      mazAssetAccessoryTable.MazPartNumber ==  this.ItemId;



                        if(mazAssetAccessoryTable.RecId && inventDim1.inventSerialId)
                        {
                           
                            mazAssetAccessoryTable.InItFromInventTables(inventDim1, inventTable);
                            mazAssetAccessoryTable.MazName = ecoResProducttranslation.Name;
                            mazAssetAccessoryTable.SalesId = this.SalesId;
                            if(mazAssetAccessoryTable.ValidateWrite())
                            {
                                mazAssetAccessoryTable.update();
                            }
                          
                        }
                        else if(inventDim1.inventSerialId)
                        {
                            mazAssetAccessoryTable.InItFromInventTables( inventDim1 , inventTable);
                            mazAssetAccessoryTable.MazName = ecoResProducttranslation.Name;
                            mazAssetAccessoryTable.SalesId = this.SalesId;
                            mazAssetAccessoryTable.insert();
                        }
                        ttscommit;

                        break;
                }
            }

        }
    }

}