Part cost FKV

Epicor ERP 10
,
1

Hello,

I’m looking to create a FKV to display the standard cost either on the part master or po detail.

I kind of remember how to setup a FKV, but memory is failing me and the YT videos I have found aren’t getting it done.

I’m missing a step somewhere as I don’t recall where to link the foreign table.

image
image627×390 14.7 KB

To make it more interesting, I don’t know what table name to pull the cost from as there is a naming discrepancy, cost. in the cost adjustment module and costpart in BAQ design.

image
image630×346 12.2 KB

image
image523×192 6.2 KB

I’ll take any advice, up to and including a career change. :slight_smile:

Thank you!

2 Likes
2

PartCost is where the “current standard cost” is stored. CostPart is where your cost sets from Costing Workbench are stored.

Cost - as shown in your second image - is the name of the dataview in that form.

4 Likes
3

Thanks, Dan. One hurdle cleared, partcost it is.

2 Likes
4

I always found it frustrating how many different ways you could go about doing the same thing… usually unclear to what makes the most sense. A BAQ Dataview might be a good fit for this if you’re just looking up standard cost to display it. There should be examples on here for that. I’m not sure if you’ll find the adapter you’re looking for in the FKV to pull in the cost record associated to that part. But if it’s there, you’re halfway there.

4 Likes
5

I’m not familiar with that, FKV were my only tool, and it’s a dull one at that. I’ll do a little more digging to see if I can find some guides on baq dataviews.

Much appreciated!

2 Likes
6

Yeah, my mind was going with a ZoneBAQ for this would be the quickest way to go.

2 Likes
7

Randy, are you trying to confuse the already confused!? :rofl:

Are ZoneBAQ and BAQ Dataview one and the same?

2 Likes
8

Here’s something to confuse you more… I’m pretty sure the result of a ZoneBAQ is yet another dataview in the background :joy:. The first time I heard of a zone BAQ was from @Rich at insights like 7+ years ago and they were cool. Do you have access to documentation @rirish ?

2 Likes
9

Sorry, they are a powerful tool to pull info and we have a few. They aren’t hard to setup:

  • Step one is make a BAQ to display what you want so probably PartNum and Standard Cost fields.
  • Step two in Extended properties, DataTable ID = “Part”
    image
    image1250×720 44.2 KB

    Then find Field Name = “PartNum” and set the Zone BAQ to the BAQ ID from step 1
    image
    image1250×720 37.7 KB
  • Repeat step two for PO Detail’s partnum field.

Then in Part Entry and open a part and right-click on the Part# and select “More Info” from the list. It’ll run your BAQ and show the data. Here is an example of one we have in Order Entry for Part# info:

image
image2084×530 50.3 KB

5 Likes
10

Huge Randy, nice instructions and share.

2 Likes
11

Thank you, Randy, I will definitely bookmark this for future use! This is the first I’ve heard/seen of this feature.

I am still pursuing a method to display this data in a field without extra clicks, but this is awesome info and instruction, much appreciated!

The only example of a dataview I could find was from Carson Ripple and involved coding, so that’s out…this might be my only hope. Thanks!

3 Likes
12

I never knew what a Zone BAQ was. This is super helpful especially as we transition into a Kinetic world away from our Classic customizations.

2 Likes
13

They are a under appreciated and not often spoke of but powerful tool for certain needs.

We only had one in Classic and now we have multiple for this reason too. I liked how Classic’s version was just a mouse-hover in the field “tick mark” to trigger the ZoneBAQ over Kinetic’s click-fest to be honest… :man_shrugging:

4 Likes
14

Randy’s method on the part master is the next project. Thanks again all that assisted!

3 Likes
15

Wow… I was interested in doing this on Quote Entry for displaying a different cost from another cost site ID

1 Like
16

so say you change the part, does that all work to refresh and what not?

1 Like
17

Yes, if you click through different po lines with different parts it automagically populates the correct price.

Edit: We are a single site company so I didn’t have to worry about site/plant ID’s, but I’m sure you could modify the query to filter by site.

1 Like
18

Utah, good question…I thought I had covered most of the scenarios, but changing parts on a new po line after the price is pulled in is not working yet. Back to the drawing board, thanks for helping my poke holes in this thing!

Edit: That one looks to be solved! I’ll update the code block above.

2 Likes
19

And that’s what I was trying to get at, we still have to account for all the events that would cause the dataview that it’s joined to to change, right? I wish that it changed and inherited the same base events as the one it was joined to.

1 Like
20

The original code only ran the BAQ on grid row activation, so changing partnums on the same row didn’t trigger. We added a refresh trigger on partnum change to remedy.

1 Like