How to insert a new line in GL transaction with newly created account ID for AP Bill(To Replicate Retainage Logic)

Hi @ramya15  I worked on the same kind of requirement from the Payments screen.

Here is sample code, I have attached and hope this helps you!

 public PXAction<ARPayment> release;
        [PXUIField(DisplayName = "Release", MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Update)]
        [PXButton()]
        public IEnumerable Release(PXAdapter adapter)
        {
            PXGraph.InstanceCreated.AddHandler<JournalEntry>(graph =>
            {
                graph.RowInserted.AddHandler<Batch>((cache, e) =>
                {
                    var row = (Batch)e.Row;
                    graph.BatchModule.Current = row;
                    GLTran crline = new GLTran();
                    crline.AccountID = Base.Document.Current.ARAccountID;
                    crline.SubID = Base.Document.Current.ARSubID;

                    crline.TranType = ARDocType.Payment;
                    crline.RefNbr = Base.Document.Current.RefNbr;
                    crline.CuryCreditAmt = 10;
                    crline.CuryDebitAmt = 0;
                    crline.Released = true;
                    graph.GLTranModuleBatNbr.Insert(crline);
				  });
            });
            return Base.release.Press(adapter);
        }	

Hi @Naveen B,

Thank you so much. Now i can post into the newly created account, but got a issues.

Actually it is creating a extra line with Rounding Difference , how to fix this issue. Please help me on this.

@ChandrasekharM 

I have enabled Subcontract module. Also I created the AP bill from subcontract and then posted into GL accounts.

Regards,

Ramya

Hi @Naveen B,

Thanks for your response. 

Using the initial code which was shared by you was working as expected. but only problem is it created a extra line for rounding differnce. Could you please help me to reticfy this. 

//Insert LAD amount in to GL Entries
            var invoice = Base.Document.Current;
            var invoiceExt = invoice.GetExtension<APRegisterExt>();
            if (invoiceExt.UsrApplyLAD == true)
            {
                PXGraph.InstanceCreated.AddHandler<JournalEntry>(graph =>
            {
                graph.RowInserted.AddHandler<Batch>((cache, e) =>
                {
                    var row = (Batch)e.Row;
                    graph.BatchModule.Current = row;
                    GLTran crline = new GLTran();

                    BAccount bAccount = PXSelect<BAccount,
                             Where<BAccount.bAccountID, Equal<Required<BAccount.bAccountID>>>>.Select(Base, invoice.VendorID);
                    var bAccountExt= bAccount.GetExtension<BAccountExt>();

                    crline.AccountID = bAccountExt.UsrVLADAccID;
                    crline.SubID = bAccountExt.UsrVLADSubAccID; 
                    crline.TranType = Base.Transactions.Current.TranType;
                    crline.RefNbr = Base.Document.Current.RefNbr;
                    crline.TranDesc = Base.Transactions.Current.TranDesc;
                    crline.CuryCreditAmt = invoiceExt.UsrLADAmountTotal;
                    crline.CuryDebitAmt = 0;
                    crline.Released = true;
                    graph.GLTranModuleBatNbr.Insert(crline);
                });
            });
            }

Thank you,

Ramya