Solved

Pass a value from Bills and Adjustment to Journal Transactions

7 months ago
September 10, 2024
5 replies
80 views

orlandonegron43
Varsity I
12 replies

Good day,

I need to pass values from a custom field in APTran in Bills and Adjustment at the moment when the Bill is released and the Journal Transaction is created, I need to pass the values to GLTran to a custom field, but when I use the Actions.PressSave I get a null error, Object reference not set to an instance of an object. I can't find which is the value I am missing or which another field appears as null and is required, I compared between the null fields on cache and the fields in the database that say that are required, but all the fields that appear as null are allowed to be null so I can't find the problem.

I would appreciate some assistance please.

public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry>
    {
        #region Event Handlers
        public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);
        [PXOverride]
        public virtual IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod)
        {
            var adapters = adapter.Get();
            APInvoice api = Base.Document.Current;
            APInvoice finance = Base.CurrentDocument.Current;
            if (finance != null)
            {
                baseMethod(adapter);
                if (finance.BatchNbr != null)
                {
                    var journalgraph = PXGraph.CreateInstance<JournalEntry>();
                    int? acct = finance.APAccountID;

                    // Iterate through each APTran line
                    foreach (APTran apTran in PXSelect<APTran, Where<APTran.tranType, Equal<Required<APTran.tranType>>, And<APTran.refNbr, Equal<Required<APTran.refNbr>>>>>.Select(Base, api.DocType, api.RefNbr))
                    {

                        APTranExt apTranExt = PXCache<APTran>.GetExtension<APTranExt>(apTran);

                        GLTran journaltran = SelectFrom<GLTran>.Where<GLTran.refNbr.IsEqual<@P.AsString>.And
                            <GLTran.tranType.IsEqual<@P.AsString>.And
                            <GLTran.module.IsEqual<@P.AsString>.And
                            <GLTran.tranLineNbr.IsEqual<@P.AsInt>>>>>.View.SelectSingleBound(journalgraph, null, apTran.RefNbr, apTran.TranType, "AP", apTran.LineNbr);
                        if (journaltran != null)
                        {
                            GLTranExt glTranExt = PXCache<GLTran>.GetExtension<GLTranExt>(journaltran);
                            //string journaldesc = apTranExt.UsrOptionalDesc;
                            //journalgraph.GLTranModuleBatNbr.Cache.SetValue<GLTranExt.usrOptDescription>(journaltran, journaldesc);
                             glTranExt.UsrOptDescription = apTranExt.UsrOptionalDesc;
                            journalgraph.GLTranModuleBatNbr.Cache.Update(journaltran);
                        }

                    }

                    // Save the changes
                    journalgraph.Actions.PressSave(); //Error

                }
            }
            return adapters;
        } #endregion
    }

Best answer by taras

Hi @orlandonegron43 in your case I would suggest to override ReleaseDocProc method of APReleaseProcess graph.

Sample code:

public class APReleaseProcessExt : PXGraphExtension<APReleaseProcess>
{
    public delegate List<APRegister> ReleaseDocProcDelegate(JournalEntry je, APRegister doc, bool isPrebooking, out List<INRegister> inDocs);

    [PXOverride]
    public virtual List<APRegister> ReleaseDocProc(JournalEntry je, APRegister doc, bool isPrebooking, out List<INRegister> inDocs, ReleaseDocProcDelegate baseMethod)
    {
        var result = baseMethod(je, doc, isPrebooking, out List<INRegister> inDocsLocal);
        foreach (APTran aptran in Base.APTran_TranType_RefNbr.Select(doc.DocType, doc.RefNbr))
        {
            GLTran gltran = je.GLTranModuleBatNbr.Select().FirstTableItems.Where(t => t.TranLineNbr == aptran.LineNbr).FirstOrDefault();
            if (gltran != null)
            {
                gltran.TranDesc = "Test";
                je.GLTranModuleBatNbr.Update(gltran);
            }
        }
        je.Persist();
        inDocs = inDocsLocal;
        return result;
    }
}

View original

Did this topic help you find an answer to your question?

pojik7
Freshman I
1 reply
7 months ago
September 11, 2024

Can you attach call stack, please?

aiwan
Captain II
388 replies
7 months ago
September 11, 2024

@orlandonegron43

Have you tried including a

if(Base == null)

{ return adapter.Get()}

Aleks

taras
Jr Varsity I
24 replies
Answer
7 months ago
September 11, 2024

Hi @orlandonegron43 in your case I would suggest to override ReleaseDocProc method of APReleaseProcess graph.

Sample code:

public class APReleaseProcessExt : PXGraphExtension<APReleaseProcess>
{
    public delegate List<APRegister> ReleaseDocProcDelegate(JournalEntry je, APRegister doc, bool isPrebooking, out List<INRegister> inDocs);

    [PXOverride]
    public virtual List<APRegister> ReleaseDocProc(JournalEntry je, APRegister doc, bool isPrebooking, out List<INRegister> inDocs, ReleaseDocProcDelegate baseMethod)
    {
        var result = baseMethod(je, doc, isPrebooking, out List<INRegister> inDocsLocal);
        foreach (APTran aptran in Base.APTran_TranType_RefNbr.Select(doc.DocType, doc.RefNbr))
        {
            GLTran gltran = je.GLTranModuleBatNbr.Select().FirstTableItems.Where(t => t.TranLineNbr == aptran.LineNbr).FirstOrDefault();
            if (gltran != null)
            {
                gltran.TranDesc = "Test";
                je.GLTranModuleBatNbr.Update(gltran);
            }
        }
        je.Persist();
        inDocs = inDocsLocal;
        return result;
    }
}

Taras Vynar | Sprinterra | https://www.sprinterra.com/

orlandonegron43
Author
Varsity I
12 replies
7 months ago
September 11, 2024

taras wrote:

Hi @orlandonegron43 in your case I would suggest to override ReleaseDocProc method of APReleaseProcess graph.

Sample code:

public class APReleaseProcessExt : PXGraphExtension<APReleaseProcess>
{
    public delegate List<APRegister> ReleaseDocProcDelegate(JournalEntry je, APRegister doc, bool isPrebooking, out List<INRegister> inDocs);

    [PXOverride]
    public virtual List<APRegister> ReleaseDocProc(JournalEntry je, APRegister doc, bool isPrebooking, out List<INRegister> inDocs, ReleaseDocProcDelegate baseMethod)
    {
        var result = baseMethod(je, doc, isPrebooking, out List<INRegister> inDocsLocal);
        foreach (APTran aptran in Base.APTran_TranType_RefNbr.Select(doc.DocType, doc.RefNbr))
        {
            GLTran gltran = je.GLTranModuleBatNbr.Select().FirstTableItems.Where(t => t.TranLineNbr == aptran.LineNbr).FirstOrDefault();
            if (gltran != null)
            {
                gltran.TranDesc = "Test";
                je.GLTranModuleBatNbr.Update(gltran);
            }
        }
        je.Persist();
        inDocs = inDocsLocal;
        return result;
    }
}

Amazing! it worked! I totally forgot to consider the screen of releasing ap documents and that's why I could not find the method that creates the journal entries when the bill is released, thank you so much!

Dmitrii Naumov
Acumatica Moderator
648 replies
7 months ago
September 11, 2024

@orlandonegron43 there are actually special methods for that.

APReleaseProcess class:

		/// <summary>
		/// The method to insert invoice details GL transactions
		/// for the <see cref="APTran"/> entity inside the
		/// <see cref="ReleaseInvoice(JournalEntry, ref APRegister, PXResult{APInvoice, CurrencyInfo, Terms, Vendor}, bool, out List{INRegister})"/> method.
		/// <see cref="GLTranInsertionContext"/> class content:
		/// <see cref="GLTranInsertionContext.APRegisterRecord"/>,
		/// <see cref="GLTranInsertionContext.APTranRecord"/>.
		/// </summary>
		public virtual GLTran InsertInvoiceDetailsTransaction(
			JournalEntry je,
			GLTran tran,
			GLTranInsertionContext context)
		{
			return je.GLTranModuleBatNbr.Insert(tran);
		}

		/// <summary>
		/// The method to insert invoice details schedule GL transactions
		/// for the <see cref="APTran"/> entity inside the
		/// <see cref="ReleaseInvoice(JournalEntry, ref APRegister, PXResult{APInvoice, CurrencyInfo, Terms, Vendor}, bool, out List{INRegister})"/> method.
		/// <see cref="GLTranInsertionContext"/> class content:
		/// <see cref="GLTranInsertionContext.APRegisterRecord"/>,
		/// <see cref="GLTranInsertionContext.APTranRecord"/>.
		/// </summary>
		public virtual GLTran InsertInvoiceDetailsScheduleTransaction(
			JournalEntry je,
			GLTran tran,
			GLTranInsertionContext context)
		{
			return je.GLTranModuleBatNbr.Insert(tran);
		}

		/// <summary>
		/// The method to insert invoice details POReceiptLine GL transactions
		/// for the <see cref="POReceiptLine"/> entity inside the
		/// <see cref="ReleaseInvoice(JournalEntry, ref APRegister, PXResult{APInvoice, CurrencyInfo, Terms, Vendor}, bool, out List{INRegister})"/> method.
		/// <see cref="GLTranInsertionContext"/> class content:
		/// <see cref="GLTranInsertionContext.APRegisterRecord"/>,
		/// <see cref="GLTranInsertionContext.APTranRecord"/>,
		/// <see cref="GLTranInsertionContext.POReceiptLineRecord"/>.
		/// </summary>
		public virtual GLTran InsertInvoiceDetailsPOReceiptLineTransaction(
			JournalEntry je,
			GLTran tran,
			GLTranInsertionContext context)
		{
			return je.GLTranModuleBatNbr.Insert(tran);
		}

You just need to override those and populate the value of the custom field before inserting of the GL Tran.

Reply

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

Cookie settings

We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.

Basic
Functional

Normal
Functional + analytics

Complete
Functional + analytics + social media + embedded videos + marketing

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Reply

Related topics

Is there a way to get current weekID in a Generic Inquiry?icon

How we can get WeekID from a Date?icon

Share a formula to get the current FinPeriod to be used in Generic inquiryicon

Share ways to manipulating on "FinPeriod"

Ask a Question, Get an Answer - June 27 - July 1, 2022 - A lot of open questions needing answers!

Most helpful members this week

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings