BAQ for AP Invoice Entry

Epicor ERP 10
1

Hello:

I need to modify the AP Invoice Entry form. In the Header tab under the Detail tab, I need to add a new textbox that will display the name of the person that entered the PO number.
The problem is that I don’t know which BAQ this form is using. I need to modify the BAQ to include the person who created the PO. I know the information is there.
Any help on how to find the BAQ or BAQs?

Thanks.

2

This is not a BAQ. This sounds like a epiDataView in customization.

Add a column to the epiDataView

You should be able to connect to the POHeader and add the POHeader.EntryPerson.

Then bind the textbox to the new column.

3

If you want to add a textbox to the screen, it’s as easy as a standard
screen customization to AP Invoice Entry.

image.png1034×870 46.9 KB

Thanks,

Norman Hutchins
System Administrator
Howell Laboratories, Inc.

4

Thanks Knash.
The form I’m working with is the AP Invoice Entry. I went through all the fields available to bind the textbox to, but the PO Entry Person field is not there. There is a Invoice Entry Person field, but this is not the one I’m looking for.

I know all the information displayed in the form is retrieved by BAQs. I also know that you specify in the BAQ which fields will be available in the form. That is why I wanted to find the BAQs that retrieve the data in the AP Invoice Entry.

5

You can achieve this with a Foreign Key View.

6

Thanks nhutchins.
The field that I need in the AP Invoice Entry is the PO Entry Person. I did find the Invoice Entry Person, but this is different from the PO Entry Person.

7

Thanks tkoch.
Can you point me to some resources to learn more about this?

8

You can find more information about Foreign Key Views in the ‘Epicor ICE 3.0 Customization User Guide’ which is available for download as a PDF through epicweb. The section on Foreign Key Views is listed under the Advanced Customization section.

9

Thanks Tom.

10

Or you can try and do this.

https://epiusers.help/t/efficiently-adding-column-to-datagrid/36283/5?u=knash

11

Oops missed the part, (I actually questioned why you would want to put the AP Invoice entry person on the entry screen since most likely it would be the person looking at the field, but didn’t want to question you need. :wink: ) Maybe a Foreign Key View (FKV). I didn’t test this, but I’ve used it in the past on other things.

FKV are covered in the ICE Customization Guide I think. FYI, you can also use the FKV as the binding in the example to add the field to the gird.

image
image.png1475×900 97.5 KB

12

Thanks Norman for taking the time to upload images with you comments.
I’m going to do it via a Foreign Key View.

13

Thanks everyone!
I ended up using a Foreign Key View and we got the results we wanted.

1 Like