PriceLst Code to Display on BAQ

Epicor ERP 9
1

Hello Everyone,

I created a open sales order report and was asked to display the price list used on the sales order so I added Price Lst to the table and now the field is displayed, yet only about half the sales orders now appear. If I change the PriceLst with Outer Join, I get all the sales orders but now nothing is displayed under the Price List?

Below is my Setup.

image
image718×403 15.6 KB

Thanks in Advance.

Miguel Lopez

2

Try to use Customer Price Lst table. It might help.

3

Hello,

It’s better but I am still missing plenty. What esle can you suggest.

image
image1037×395 28.1 KB

I have the price list on the sales order, yet nothing prints on my BAQ (See Below)

image
image383×505 17.8 KB

image

Thanks in Advance.
Miguel

4

What are you linking on?

I usually use PriceLstParts

5

Hello I tried your suggestion, I got information listed but many codes but didn’t tie out.

Thanks for your help.

Miguel Lopez

6

You want the join to be an outer with OrderDtl.BreakListCode = PriceLst.ListCode

You can use field help to find the bindings you need.