Inventory Attributes to the Purchase Order Details Line Items

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

@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!

@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

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

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

@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.

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

@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.";

        }