Displaying a field from customer entry

Is it possible to do a BAQ lookup in one single field?

Basically, I need to display data from a drop down selection on the customer entry on the Sales Order Entry screen.

Customer Maintenance field: Dropdown = Supplier_c

Whatever is selected for that customer, I need to display it when the “Sold To” changes on Sales Order Entry is that doable?

BAQ Data views work good for this type of thing, Check this post out

Thanks!

That’s creating a grid view. I want to populate a single column with the data from Customer Maintenance.

You can still do it with a baq dataview, I’ve done it a few times, it’s 9:30pm here so I’m not firing up my computer to find you an example, have a look at some of @Carson Ripples examples, he’s good at them

Ok,
I added this field

and subscribed it to my BAQ Dataview

my BAQ dataview

 public void PartPriceManBAQDV()
    {

        partPriceManBAQDV = new BAQDataView("TWG_Quote_Part_Price_DV");
        oTrans.Add("TWG_PartPriceMan", partPriceManBAQDV);
        string pub16Binding = "JobMtl.PartNum";
        IPublisher pub16 = oTrans.GetPublisher(pub16Binding);
        if (pub16 == null)
        {
            string pubName = Guid.NewGuid().ToString();
            oTrans.PublishColumnChange(pub16Binding, pubName);
            pub16 = oTrans.GetPublisher(pub16Binding);
        }
        if (pub16 != null)
            partPriceManBAQDV.SubscribeToPublisher(pub16.PublishName, "Part_PartNum");
	}

EDIT
Create a BAQ with 2 columns, one with CustNum and another with the other field that you want to return
Then publish the OrderHed.CustNum to the BAQ
Disclaimer: Field names may not be correct…

2 Likes

Sorry for keeping you up and thank you for powering up your computer.

I owe you a pint!

No problems, glad I could help!!

What am I doing wrong?

private void CreateSupplierSourceBAQDV()
	{
        supplierSourceBAQDV = new BAQDataView("TEAGLE-CustomerSupplier");
        oTrans.Add("SupplierSourceBAQDV", supplierSourceBAQDV);
        string pub1Binding = "OrderHed.CustNum";
        IPublisher pub1 = oTrans.GetPublisher(pub1Binding);
        if (pub1 == null)
        {
            string pubName = Guid.NewGuid().ToString();
            oTrans.PublishColumnChange(pub1Binding, pubName);
            pub1 = oTrans.GetPublisher(pub1Binding);
        }
        if (pub1 != null)
            supplierSourceBAQDV.SubscribeToPublisher(pub1.PublishName, "Customer_CustNum");
	}

All I’m getting back is a blank text box?

image

The BAQ is Shared :confused:

Fixed it… I mistyped my BAQ

image