Hi @Shurtugal98, your new field is not in the POLine table in the database, you need to add it through the customization editor.

I think that you’re missing the part of your project that actually adds the UsrAttribute1 to the table. In your customization project, on the left, click Database Scripts.  Then find the Add Customer Column to Table action. Select the POLine table and then add in the properties of your field.

When you publish next, the process will add the column to the database table if it is not already there.

Edit: I took too long to write this. zfebert56 has your answer.

@Django @zfebert56 

I have added it the way you mentioned and i now get at least not an error. Thanks so far this has definitely helped! But i am now dealing with the problem that in the POLine it doesnt show the value of the attribute. Do you have any idea what i could be doing wrong besides from that?

Here my POLine:

and here is the stock item attributes on the top:

I looked up the DAC of the CSAnswers and the AttributeID = “GROESSE”
I changed the Attribute to make it more clearly for me which attribute i am trying to get.

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using PX.Common;
using PX.Data;
using PX.Objects.GL;
using PX.Objects.CM.Extensions;
using PX.Objects.CS;
using PX.Objects.CR;
using PX.Objects.TX;
using PX.Objects.IN;
using PX.Objects.EP;
using PX.Objects.AP;
using PX.Objects.AR;
using PX.Objects.SO;
using SOOrder = PX.Objects.SO.SOOrder;
using SOLine = PX.Objects.SO.SOLine;
using PX.Data.DependencyInjection;
using PX.Data.ReferentialIntegrity.Attributes;
using PX.LicensePolicy;
using PX.Objects.PM;
using CRLocation = PX.Objects.CR.Standalone.Location;
using PX.Objects.AP.MigrationMode;
using PX.Objects.Common;
using PX.Objects.Common.Discount;
using PX.Data.BQL.Fluent;
using PX.Data.BQL;
using PX.Objects.Common.Bql;
using PX.Objects.Extensions.CostAccrual;
using PX.Objects.DR;
using PX.Data.WorkflowAPI;
using PX.Objects.Extensions;
using PX.Objects.Common.DAC;
using PX.Objects.Common.Scopes;
using PX.Objects.IN.Services;
using PX.Objects.Extensions.MultiCurrency;
using PX.Data.Description;
using PX.Objects;
using PX.Objects.PO;

namespace PX.Objects.PO
{
  public class POOrderEntry_Extension : PXGraphExtension<PX.Objects.PO.POOrderEntry>
  {
    #region Event Handlers
    protected virtual void POLine_InventoryID_FieldUpdated(PXCache sender, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler)
        {
            InvokeBaseHandler?.Invoke(sender, e);
            POLine row = (POLine)e.Row;
            if (row == null) return;
            CSAnswers CSAns = PXSelectJoin<CSAnswers,
                              InnerJoin<InventoryItem, On<InventoryItem.noteID, Equal<CSAnswers.refNoteID>>>,
                              Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>,
                              And<CSAnswers.attributeID, Equal<Required<CSAnswers.attributeID>>
                              >>>.Select(Base, row.InventoryID, "GROESSE");
            if (CSAns != null)
            {
                POLineExt rowExt = row.GetExtension<POLineExt>();
                rowExt.UsrGroesse = CSAns.Value;
            }
        }
}
    #endregion
}

Thanks for any further help and thank you so much again for helping me!

Hi @Shurtugal98,

I tried your code and it does what you need on my instance, when I added a new line to the PO it copied the attribute value. Maybe you don’t find your attribute?

Try to use this in your FieldUpdated event handler:
 

POLineExt rowExt = row.GetExtension<POLineExt>();
if (CSAns != null)
{
    rowExt.UsrAttribute1 = CSAns.Value;
}
else
{
    rowExt.UsrAttribute1 = "Attribute note found.";    
}

@zfebert56 Thank you so much! I realized that but i made a mistake. I misclicked when setting up the column. Now i have an conversion error but the i will fix right now. Thanks

@Django @zfebert56 Guys please help me out one last time. I try to save the PO when adding a stock item but i get the error “Conversion failed when converting the nvarchar value 'XL' to data type smallint.” I know that the VSAnswers.Value Field is a nvarchar and my UsrAttribute1 is a string so there should be no problem at all. Why does the PO try to convert it to a smallint and how can i avoid this? So sorry and i really owe you one!

@Shurtugal98 Can you confirm that your new field in the database is nvarchar?

@zfebert56 I added it like this: 

I thought this would work because a nvarchar contains string values. 

But in the POLine Data Table ist like this:

@Shurtugal98 Drop the field from the SQL table and try to republish your customization package.

@zfebert56 Thanks for the reply! I am sorry i dont know exactly what to do. Can you give me an advice?

@Shurtugal98 You need to drop the field with SQL Server Management Studio or any other SQL tool, using this command:

ALTER TABLE POLine DROP COLUMN UsrGroesse;

Once it is done, you can publish your package again and it will create UsrGroesse with the correct type.

@zfebert56 Thanks i got it now! Just one last question and i will be thanking you forever. What if i want multiple custom fields to be inserted? How would i have to extend my code? 

@Shurtugal98 I am not sure what you need, can you clarify your question?

@zfebert56 I am trying to add another Custom Field where i can store another attribute value. How would i need to extend my code for the POOrderEntry GraphExtension if i need more than 1 Attribute?

@Shurtugal98 I would use something like this:

        protected virtual void POLine_InventoryID_FieldUpdated(PXCache sender, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler)
        {
            InvokeBaseHandler?.Invoke(sender, e);
            var row = (POLine)e.Row;
            if (row == null) return;

            var rowExt = row.GetExtension<POLineExt>();
            rowExt.UsrGroesse = GetAttributeValue(Base, row, "GROESSE");
            rowExt.UsrSpieler = GetAttributeValue(Base, row, "SPIELER");
            rowExt.UsrStyle = GetAttributeValue(Base, row, "STYLE");
        }

        protected static string GetAttributeValue(PXGraph graph, POLine row, string AttributeName)
        {
            CSAnswers CSAns = PXSelectJoin<CSAnswers,
                InnerJoin<InventoryItem, On<InventoryItem.noteID, Equal<CSAnswers.refNoteID>>>,
                Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>,
                    And<CSAnswers.attributeID, Equal<Required<CSAnswers.attributeID>>
                    >>>.Select(graph, row.InventoryID, AttributeName);

            return CSAns?.Value ?? "Attribute note found.";

        }