How-TO: Import Sales Order Lines custom field with Commerce Connector

Acumatica Commerce Connector does not allow mapping of the custom fields for the Sales Order Lines using Entity mapping screen, however, you can use customization engine and include custom fields.

To do so, you can create an extension for the Sales Order Processor and include the SO Line custom fields in the API Object.

//BCSalesOrderProcessor is the main class that does synchronization of the Sales Orders
public class BCSalesOrderProcessorExt : PXGraphExtension<BCSalesOrderProcessor>
{
    public delegate void MapBucketImportDelegate(BCSalesOrderBucket bucket, IMappedEntity existing);

    //MapBucketImport is mapping the eCommerce API object to Acumatica API Object.
    [PXOverride]
    public void MapBucketImport(BCSalesOrderBucket bucket, IMappedEntity existing, MapBucketImportDelegate baseMethod)
    {
        baseMethod(bucket, existing);

        foreach (var detrow in (IEnumerable<SalesOrderDetail>)bucket.Order.Local.Details)
        {
            detrow.Custom = new CustomField[]
            {
               new CustomStringField()
               {
                    ViewName = "Transactions", //Dataview name for the sales order details
                    FieldName = "UsrField", //Custom field name
                    Value = "Test1" // Custom field value
               }
            }.ToList();
        }
    }
}

Hope it helps!