SO Error : Document out of Balance

Here is the updated code below

 APPaymentEntry paymentGraph = PXGraph.CreateInstance<APPaymentEntry>();
 APInvoice fetchedDebitAdj = PXSelect<APInvoice,
     Where<APInvoice.docType, Equal<Required<APInvoice.docType>>,
     And<APInvoice.refNbr, Equal<Required<APInvoice.refNbr>>>>>
     .Select(Base, APDocType.DebitAdj, debitAdj.RefNbr); // Ensure using the correct type

 APPayment newPayment = paymentGraph.Document.Insert(new APPayment
 {
     VendorID = apinvoice.VendorID,
     DocType = APDocType.Check, 
     Hold = true // Set on hold initially
 });

 newPayment.RefNbr = fetchedDebitAdj.RefNbr; 
 paymentGraph.Document.Update(newPayment);

 APAdjust adjustment = new APAdjust
 {
     AdjgDocType = newPayment.DocType,
     AdjgRefNbr = newPayment.RefNbr,
     AdjdDocType = apinvoice.DocType,
     AdjdRefNbr = apinvoice.RefNbr,
     CuryAdjgAmt = fetchedDebitAdj.CuryOrigDocAmt,
     CuryAdjdAmt = fetchedDebitAdj.CuryOrigDocAmt,
     AdjAmt = fetchedDebitAdj.OrigDocAmt
 };

 paymentGraph.Adjustments.Insert(adjustment);
 newPayment.Hold = false; // Remove hold status
 paymentGraph.Actions.PressSave(); // Save the payment document
 PXLongOperation.WaitCompletion(paymentGraph.UID);

@Naveen Boga  Any thoughts.

Hi @Sagar Greytrix ,

Try the code sample below. 

Assign the correct value for each field.

APPaymentEntry docgraph = PXGraph.CreateInstance<APPaymentEntry>();

            try
            {
                APInvoice fetchedDebitAdj = PXSelect<APInvoice,  Where<APInvoice.docType, Equal<Required<APInvoice.docType>>,
                                            And<APInvoice.refNbr, Equal<Required<APInvoice.refNbr>>>>>.Select(docgraph, APDocType.DebitAdj, debitAdj.RefNbr);

                    APPayment payment = new APPayment()
                    {
                        DocType = paymentType,
                    };

                    payment = docgraph.Document.Insert(payment);
                    payment.VendorID = invoice.VendorID;
                    payment = docgraph.Document.Update(payment);
                    payment.PaymentMethodID = PaymentMethodID;
                    payment.ExtRefNbr = "Assign the RefNbr";
                    payment.BranchID = invoice.BranchID;
                    payment.Hold = false;                  
                    payment.CashAccountID = CashAccountID;                 
                    payment.DocDesc = invoice.DocDesc;
                    string AdjDate = Convert.ToDateTime(invoice.DocDate).ToString("yyyy-MM-dd");
                    payment.AdjDate = Convert.ToDateTime(AdjDate);                   
                    payment.CuryOrigDocAmt = Paymentprice;
                    payment = docgraph.Document.Update(payment); // Update payment here

                    APAdjust adj = new APAdjust()
                    {
                        AdjdDocType = DocType,
                        AdjdRefNbr = RefNbr,
                    };

                    docgraph.Adjustments.Insert(adj);
                    docgraph.Persist();              
                    docgraph.release.Press();                
            }
            catch (Exception ex)
            {
                throw new PXException(ex.Message?.ToString());

            }

Hi jinin,

Thank you for looking into it.

I have modified some of the code and now it is not getting the reference number in the detail section.

APInvoice fetchedDebitAdj = PXSelect<APInvoice, Where<APInvoice.docType, Equal<Required<APInvoice.docType>>,
                            And<APInvoice.refNbr, Equal<Required<APInvoice.refNbr>>>>>.Select(docgraph, APDocType.DebitAdj, debitAdj.RefNbr);

APPayment payment = new APPayment()
{
    DocType = APDocType.DebitAdj,
};

payment = docgraph.Document.Insert(payment);
//payment.VendorID = apinvoice.VendorID;
//payment = docgraph.Document.Update(payment);
//payment.PaymentMethodID = 
payment.DocType = APDocType.DebitAdj;
payment.RefNbr = fetchedDebitAdj.RefNbr;
payment.BranchID = apinvoice.BranchID;
payment.Hold = false;
//payment.CashAccountID = CashAccountID;
payment.DocDesc = apinvoice.DocDesc;
string AdjDate = Convert.ToDateTime(apinvoice.DocDate).ToString("yyyy-MM-dd");
payment.AdjDate = Convert.ToDateTime(AdjDate);
payment.CuryOrigDocAmt = fetchedDebitAdj.CuryOrigDocAmt;
payment = docgraph.Document.Update(payment); // Update payment here

APAdjust adj = new APAdjust()
{
    AdjgDocType = payment.DocType,
    AdjgRefNbr = payment.RefNbr,
    AdjdDocType = apinvoice.DocType,
    AdjdRefNbr = apinvoice.RefNbr,
};

docgraph.Adjustments.Insert(adj);

docgraph.Persist();
docgraph.release.Press();

Regards,

Sagar Gadge

Is the payment number you are trying to add loading the screen? Did you check that?

Yes, It is loading the screen.

Hi ​@Sagar Greytrix were you able to find a solution? Thank you!