Solved

Copy UDF from PO Line to AP Invoice when entering AP Bill from PO

Forum|Forum|1 year ago
August 6, 2024
28 replies
418 views

lnd74
Freshman I

Could someone please help in providing a solution of moving the UDF from PO into AP Invoice?

I am new to developing in acumatica. I have created the user defined fields in POLine and APTran.

While reviewing the source of APInvoiceEntry, I looked at overriding the method CopyCustomizationFieldsToAPTran.

Code I added is below.

public void CopyCustomizationFieldsToAPTran(APTran apTranToFill, IAPTranSource poSourceLine, Boolean areCurrenciesSame, CopyCustomizationFieldsToAPTranDelegate baseMethod)
  {

  baseMethod(apTranToFill,poSourceLine,areCurrenciesSame);

  var portID = poSourceLine.GetExtension<POLineExt>()?.UsrPortID;
  var tranline = apTranToFill?.GetExtension<APTranExt>()?.UsrPortID;

  if (tranline != null && portID != null ) tranline.UsrPortID = portID;

  }

I am getting validation errors when I try to publish.

error CS1929: 'IAPTranSource' does not contain a definition for 'GetExtension' and the best extension method overload 'PXCacheEx.GetExtension<POLineExt>(IBqlTable)' requires a receiver of type 'IBqlTable'

error CS1061: 'string' does not contain a definition for 'UsrPortID' and no accessible extension method 'UsrPortID' accepting a first argument of type 'string' could be found (are you missing a using directive or an assembly reference?)

error CS1929: 'IAPTranSource' does not contain a definition for 'GetExtension' and the best extension method overload 'PXCacheEx.GetExtension<POLineExt>(IBqlTable)' requires a receiver of type 'IBqlTable'

Am I using the correct method to accomplish the task?

Best answer by Vignesh Ponnusamy

Hi @lnd74,

Adding to @darylbowman suggestions.

You can also override the CreateAPInvoice method and add the RowInserting event handler for APTran DAC like below copy the custom fields,

 public class POOrderEntry_Extension : PXGraphExtension<PX.Objects.PO.POOrderEntry>
    {
        #region Event Handlers
        public delegate IEnumerable CreateAPInvoiceDelegate(PXAdapter adapter);
        [PXOverride]
        public IEnumerable CreateAPInvoice(PXAdapter adapter, CreateAPInvoiceDelegate baseMethod)
        {
            PXGraph.InstanceCreated.AddHandler<APInvoiceEntry>((invoiceEntryGraph) =>
            {
                invoiceEntryGraph.RowInserting.AddHandler<APTran>((sender, e) =>
                {
                    APTran apTran = (APTran)e.Row;
                    APTranExt apTranExt = apTran.GetExtension<APTranExt>();
                    POLine poLine = PXSelect<POLine, Where<POLine.orderType, Equal<Required<APTran.pOOrderType>>,
                        And<POLine.orderNbr, Equal<Required<APTran.pONbr>>,
                        And<POLine.lineNbr, Equal<Required<APTran.pOLineNbr>>>>>>.Select(Base, apTran.POOrderType, apTran.PONbr, apTran.POLineNbr);
                    if (poLine != null)
                    {
                        POLineExt poLineExt = poLine.GetExtension<POLineExt>();
                        apTranExt.UsrPortID = poLineExt.UsrPortID;
                    }
                });
            }
            );
            return baseMethod(adapter);
        }
        #endregion
    }

Feel free to post back if you have any questions. Happy coding.!

Show first post

Forum|pagination.label 2 / 2

lnd74
Author
Freshman I
Forum|Forum|1 year ago
August 8, 2024

@darylbowman @Vignesh Ponnusamy

We installed the customization into Acumatica 2023 R2 Build 23.212.0024 and It now works, thank you to both of you!

+16

darylbowman
Forum|Forum|1 year ago
August 8, 2024

Happy to help. Could you mark Vignesh’s post as the best answer?

Daryl⚡Freelance Acumatica developer (MVPx3🏆) 🛒store.deftstrokesdev.com ⏩linkedin.com/in/darylbowman

tigrantunyan08
Freshman I
Forum|Forum|8 months ago
May 15, 2025

@lnd74

Hello, I’ve faced a task like yours, and here is my code, maybe it will be useful:

We can convert IAPTranSource object to POReceiptLineS one, and find either POLine and POReceiptLine objects.

#region Copy Customization Fields To APTran
public delegate void CopyCustomizationFieldsToAPTranDelegate(APTran apTranToFill, IAPTranSource poSourceLine, bool areCurrenciesSame);

[PXOverride]
public virtual void CopyCustomizationFieldsToAPTran(APTran apTranToFill, IAPTranSource poSourceLine, bool areCurrenciesSame,
CopyCustomizationFieldsToAPTranDelegate baseMetod)
{
UpdateAPTranFields(apTranToFill, (POReceiptLineS) poSourceLine);
baseMetod(apTranToFill, poSourceLine, areCurrenciesSame);
}
#endregion

private void UpdateAPTranFields(APTran aPTran, POReceiptLineS recLine)
{
if (recLine != null)
{
POReceiptLine poreceiptLine = GetReceiptLine(recLine.ReceiptNbr, recLine.ReceiptType, recLine.LineNbr);
if (poreceiptLine != null)
{
var poReceiptLineExt = PXCache<POReceiptLine>.GetExtension<VEPOReceiptLineBExt>(poreceiptLine);
UpdateAPTranFields(aPTran, poReceiptLineExt);
}
else
{
POLine poLine = GetPOLine(recLine.PONbr, recLine.POType, recLine.POLineNbr);
if (poLine != null)
{
var poLineBOLExt = PXCache<POLine>.GetExtension<VEPOLineBOLExt>(poLine);
UpdateAPTranBOLFields(aPTran, poLineBOLExt);
}
}
}
}

TTunyan

Forum|pagination.label 2 / 2

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.

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded