UDFs from Purchase Receipt (PO302000) not refleced in IN Receipt (IN301000)

Hi @mrhoades,

It’s amazing hear you find the community helpful.!

To copy the UDF from PO302000 to IN301000, you might have to do a bit of coding. As you might have noticed, the IN Receipt is copied when we release the Purchase Receipt. Below is a graph extension you can try to copy the UDF from PO302000 to IN301000.

In the below example, I am copying AMBATLEN attribute during the Release process. Similarly you can copy one or more UDFs,

    public class POReceiptEntry_Extension : PXGraphExtension<PX.Objects.PO.POReceiptEntry>
    {
        #region Event Handlers
        public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);
        [PXOverride]
        public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod)
        {
            PXGraph.InstanceCreated.AddHandler<INReceiptEntry>((graphINReceiptEntry) =>
            {
                graphINReceiptEntry.RowPersisting.AddHandler<INRegister>((sender, e) =>
                {
                    INRegister currentINRegister = (INRegister)e.Row;
                    var AttributeAMBATLEN = Base.Document.Cache.GetValueExt(Base.Document.Current, "AttributeAMBATLEN");
                    graphINReceiptEntry.receipt.Cache.SetValueExt(currentINRegister, "AttributeAMBATLEN", AttributeAMBATLEN.ToString());

                });
            });
            return baseMethod(adapter);
        }
        #endregion
    }

Feel free to post if you have any questions.

Good Luck.!

Vignesh,

My fields are “customized” fields (Add Data Fields Tab) created within PO302000.  The first set are found in PO302000, Grid: Transactions:

Room Number (PO Recpt MainGrid); MAC Address (PO Recpt MainGrid); and IP Address (PO Recept MainGrid)

The second set are found in PO302000, Dialogs, Dialog: Line Details, Grid: splits:

Room Number (PO Recpt LnDet Split); MAC Address (PO Recpt LnDet Split); and IP Address (PO Recpt LnDet Split)

I’ve attached an export of my project for your review.  I appreciate your attempt to help.  From my reading and understanding, these data fields are not contained within the ATTRIBUTE table, which I believe is part of the code your provided.  We did not create attributes because I’m not sure how I would iterate those through the Line Details Split.  Thanks for any additional help/insight you can provide.

Michael

@mrhoades,

Thanks for the clarification.

In that case, to display the custom fields in the IN301000 screen detail line, you have to create custom fields respectively in INTrac DAC. Then like below you need to copy the field from POReceiptLine to INTran,

        public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);
        [PXOverride]
        public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod)
        {
            PXGraph.InstanceCreated.AddHandler<INReceiptEntry>((graphINReceiptEntry) =>
            {
                graphINReceiptEntry.RowPersisting.AddHandler<INTran>((sender, e) =>
                {
                    INTran currentINTran = (INTran)e.Row;
                    INTranExt TranExt = PXCache<INTran>.GetExtension<INTranExt>(currentINTran);
                    POReceiptLine currentPOReceiptLine = PXSelect<POReceiptLine, Where<POReceiptLine.receiptNbr,
                        Equal<Required<POReceiptLine.receiptNbr>>, And<POReceiptLine.lineNbr,
                        Equal<Required<POReceiptLine.lineNbr>>>>>.Select(Base, currentINTran.POReceiptNbr,currentINTran.POReceiptLineNbr );
                    POReceiptLineExt ReceiptLineExt = Base.transactions.Cache.GetExtension<POReceiptLineExt>(currentPOReceiptLine);
                    TranExt.UsrPORecptMainGridRoomNbr = ReceiptLineExt.UsrPORecptMainGridRoomNbr;
                    TranExt.UsrPORecptMainGridMACAdd = ReceiptLineExt.UsrPORecptMainGridMACAdd;
                    TranExt.UsrPORecptMainGridIPAddress = ReceiptLineExt.UsrPORecptMainGridIPAddress;
                });
            });
            return baseMethod(adapter);
        }

I have also attached the updated customization custom fields and the Release override to copy them to the IN301000 fields. You can test the update package and use it as reference, 

Hope that helps.! Good Luck,

I figured it was the same process, just needed the additional info on where!  I’ll try this and get back to you.  I appreciate your very quick response.

Yours,

Michael

Vignesh – I’ve taken the information you provided and attempted to build upon it.  However, like I’ve mentioned – I am not a Developer by training or trade.  Therefore, although I believe I am making progress and learning as I go, I am currently receiving an error message when I process a Purchase Order.  Here is what I see:

• Create a PO (PO301000) – No Problem
• Release PO -> Purchase Receipt created.  Details entered in Main Grid using an inventory item that is a Serial Number Required type.  Qty of 2.  Lot/Serial Nbr shows <SPLIT>.  Enter Line Details for SPLIT.  No problem here either.  The workflow modification for the Custom Fields performs as desired.  From Balanced status, I try to RELEASE the POR.
• Upon RELEASE of the PO Receipt, I receive this error: “Unable to cast object of type ‘PX.Objects.IN.INTran’ to type ‘PX.Objects.IN.INTranSplit’

In the project you provided, the IN.INTran Custom fields were included.  I’ve added the IN.INTranSplit Custom fields following your example for those used in IN.INTran by the POReceiptEntry graph.  I’ve attempted to add the additional code for IN.INTranSplit as well.  Although the graph does VALIDATE and PUBLISH, the error is thrown.  Not sure what I’m missing.  I’ve commented the code so you can see where I’ve inserted additional lines to try and get the POR Line Split Detail Custom Fields to populate the IN.INTranSplit Custom Fields.  I’ve actually tried many variations trying to figure the issue out myself.  Just not successful yet.

Exported my Project File and attached for your review/suggestions.  Thank you in advance for any help you can provide.

I appreciate your response.  I’ll modify my project and see if I can move it forward.

Vignesh,

I’ve been banging my head on the wall trying to get both pieces of the INTran and INTranSplit to copy the data for my custom fields from the PO Receipt to the INReceipt.  Each piece will work independently.  However, none of my attempts to combine both to a single graph work.  I constantly receive an “ Unable to cast object of type 'PX.Objects.IN.INTran' to type 'PX.Objects.IN.INTranSplit' error.  Can you review the attached and tell me what you see that I’m doing wrong.  Again, newbee to C# and trying to get some work done and learn at same time.

namespace PX.Objects.PO
{
    public class POReceiptEntry_Extension : PXGraphExtension<PX.Objects.PO.POReceiptEntry>
    {
        #region Event Handlers
        protected void POReceiptLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected baseHandler)
        {
            baseHandler?.Invoke(cache, e);
            var row = (POReceiptLine)e.Row;
            if (row != null)
            {
                Base.Document.Cache.AllowUpdate = true;
                cache.AllowUpdate = true;
                /* My Custom User fields for the PO Receipt Main Grid */
                PXUIFieldAttribute.SetEnabled<POReceiptLineExt.usrPORecptMainGridRoomNbr>(cache, row, true);
                PXUIFieldAttribute.SetEnabled<POReceiptLineExt.usrPORecptMainGridMACAdd>(cache, row, true);
                PXUIFieldAttribute.SetEnabled<POReceiptLineExt.usrPORecptMainGridIPAddress>(cache, row, true);
            }
        }
        protected void POReceiptLineSplit_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected baseHandler)
        {
            baseHandler?.Invoke(cache, e);
            var row = (POReceiptLineSplit)e.Row;
            if (row != null)
            {
                Base.Document.Cache.AllowUpdate = true;
                cache.AllowUpdate = true;
                /* My Custom User Defined fields for the PO Receipt Line Details (Split) Grid */
                PXUIFieldAttribute.SetEnabled<POReceiptLineSplitExt.usrPORecptLnDetSplitRoomNbr>(cache, row, true);
                PXUIFieldAttribute.SetEnabled<POReceiptLineSplitExt.usrPORecptLnDetSplitMACAdd>(cache, row, true);
                PXUIFieldAttribute.SetEnabled<POReceiptLineSplitExt.usrPORecptLnDetSplitIPAdd>(cache, row, true);
            }
        }

/*     BEGIN Inserting INTran and INTranSplit graph here. This will validate and publish without errors.              */
        public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);
        [PXOverride]
        public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod)
        {
            PXGraph.InstanceCreated.AddHandler<INReceiptEntry>((graphINReceiptEntry) =>
          {
                 graphINReceiptEntry.RowPersisting.AddHandler<INTran>((sender, e) =>
             {
                    INTran currentINTran = (INTran)e.Row;
                    INTranExt TranExt = PXCache<INTran>.GetExtension<INTranExt>(currentINTran);
                    POReceiptLine currentPOReceiptLine = PXSelect<POReceiptLine, Where<POReceiptLine.receiptNbr,
                        Equal<Required<POReceiptLine.receiptNbr>>, And<POReceiptLine.lineNbr,
                        Equal<Required<POReceiptLine.lineNbr>>>>>.Select(Base, currentINTran.POReceiptNbr,currentINTran.POReceiptLineNbr );
                    POReceiptLineExt ReceiptLineExt = Base.transactions.Cache.GetExtension<POReceiptLineExt>(currentPOReceiptLine);
                    TranExt.UsrPORecptMainGridRoomNbr = ReceiptLineExt.UsrPORecptMainGridRoomNbr;
                    TranExt.UsrPORecptMainGridMACAdd = ReceiptLineExt.UsrPORecptMainGridMACAdd;
                    TranExt.UsrPORecptMainGridIPAddress = ReceiptLineExt.UsrPORecptMainGridIPAddress;
                    INTranSplit currentINTranSplit = (INTranSplit)e.Row;
                    INTranSplitExt TranSplitExt = PXCache<INTranSplit>.GetExtension<INTranSplitExt>(currentINTranSplit);
                    POReceiptLineSplit currentPOReceiptLineSplit = PXSelect<POReceiptLineSplit, Where<POReceiptLineSplit.receiptNbr,
                        Equal<Required<POReceiptLineSplit.receiptNbr>>,
                        And<POReceiptLineSplit.receiptType,
                        Equal<Required<POReceiptLineSplit.receiptType>>,
                        And<POReceiptLineSplit.inventoryID, Equal<Required<POReceiptLineSplit.inventoryID>>,
                        And<POReceiptLineSplit.qty, Equal<Required<POReceiptLineSplit.qty>>
                        >>>>>.Select(Base, graphINReceiptEntry.receipt.Current.POReceiptNbr,
                        graphINReceiptEntry.receipt.Current.POReceiptType, currentINTranSplit.InventoryID,
                        currentINTranSplit.Qty); //Query to Get the mathcing POReceiptLineSplit.
                    POReceiptLineSplitExt ReceiptLineSplitExt = PXCache<POReceiptLineSplit>.GetExtension<POReceiptLineSplitExt>(currentPOReceiptLineSplit);
                    TranSplitExt.UsrPORecptLnDetSplitRoomNbr = ReceiptLineSplitExt.UsrPORecptLnDetSplitRoomNbr;
                    TranSplitExt.UsrPORecptLnDetSplitMACAdd = ReceiptLineSplitExt.UsrPORecptLnDetSplitMACAdd;
                    TranSplitExt.UsrPOReceptLnDetSplitIPAdd = ReceiptLineSplitExt.UsrPORecptLnDetSplitIPAdd;
/*   END of attempt to get Custom Fields in Purchase Order Receipt Main Grid and Line Detail Split to cast to INReceipt Main Grid and Line Detail Split */
                });
              });
            return baseMethod(adapter);
        #endregion
        }
    }
}

Thanks,

Mike

Vignesh,

Would you be able to review my response about 10 days ago and provide your review?

Thanks,

Mike

Vignesh,

I figured out the issue causing the graph to fail.  I wanted to thank you for your time in responding.  I would not have been successful without your assistance.

Mike

@mrhoades, Nice to hear that, sorry I wasn’t able to get to you on this.

Good Luck.!

Vignesh,

I identified an issue I had missed.  Could you take a look at the attached notes w/screenshots and the  project file and let me know if you can point out the issue.

Simply put, when I create a PO and process through a RELEASED POR for an item that requires serial numbering, the POReceipt LineDetails (SPLIT) is not functioning correctly.  Although the Lot/Serial Number for each Line Detail (SPLIT) row is correctly copied to the INReceipt, the CUSTOM fields for Line1 of the Line Detail (SPLIT) are copied to Line2 and any subsequent line(s).

Your review and guidance would be greatly appreciated.

Michael