PO Form Part Number Calculation

Epicor ERP 10
1

Hello All,

I am trying to understand how the partnum1 field works on the base po form. Can anyone tell me where the Fields.VendorPartOpts.Value is coming from???

image
image1529Ă—652 39.9 KB

Thanks in advance for any help.

Respectfully,

Utah

2

So I found it in po detail using data dictionary and @skhan 's help … but this is what it says:

Vendor Part Print Options. Determines what is printed.
M = Main Part Reference (Default)
S = Secondary Part Reference
O = Only Part Reference
A = All Supplier Parts Referenced
N = No Supplier Parts Referenced

Are these defaulted from somewhere? I don’t see this field as a maintainable field in PO entry.

3

It’s most likely a field created by the magic of the RDD.

But if it is just a proxy for a real table field, you could examine the Query expression to see its source in the dataset.

4

I used the help file based “data dictionary” that @hkeric.wci posted, and the only table that refers to that field is Erp.PODetail

Same goes for the similar MfgPartOpts field in PODetail.

5

So it is a magical field only recorded at the time of a po detail creation… that is what we know so far. I wish there was a little more documentation. I asked for some from Epicor, we will see what they say. I can’t seem to find any mention of it in the app user guide or tech ref guides. Thanks for your help @ckrusen !

6

Just curious … if you make a BAQ of the PODetail table, does that field have differing values? or is it always the same? If it differs, you could work backwards to see what drives it.

Things’d I’d look at:

  • PO line type (Buy to Inv, Buy to Order, Buy to Job)
  • if BTI, look at the part file, and any vendor that part is related to.
  • if BTO, the order line and the vendor specified on the line
  • if BTJ, the MOM it was bout agains
7

Always the same. “M”

8

what about for you?

9

POSuggestion Process sets it to “M”.

While the RowRule shows that if you have a VendPart (probably a Part X Ref) then the field becomes maintanable on the PO in the Cross Ref Options Dialog.

1 Like
10

Every PODetail record has:

  • VendPartOpts = M
  • MfgPartOpts = O
  • SubPartOpts = O

We don’t go very deep in our use of E10 (no labor tracking, no subcontractors, no approved vendors, no mrp, no scheduling, etc…) So it’s not uncommon for us to have lots of “unused” fields in various tables.

1 Like
11
And how can someone learn this?

And “Not from a Jedi…” is not an acceptable answer :wink:

1 Like
12

Trace

1 Like
13

Thanks for tracing it or however you found it @hkeric.wci ! There is a supplier price list set up, but I don’t know where the cross ref options dialog is… In other words, I don’t know what options cause this field to be set differently in the Po Suggestion process. I would think it would run when putting in a new part on PO detail as well… Would have to trace it to find out.

14

Part Cross Reference Options (Purchase Order Entry > Lines > Detail > Part Cross Reference Options)

image

Use the Part Cross Reference Options dialog to specify part cross reference printing options for supplier, manufacturer or substitute parts selected for the purchase order line. This determines the level of part cross-reference detail that should print on supplier-facing documents such as the purchase order form.

Mfg / Manufacturer Part

Specifies how qualified manufacturer’s part numbers should print on supplier-facing documents such as the purchase order form. This field is unavailable if no qualified manufacturer’s part numbers have been selected for the internal part number being ordered on this purchase order line. Select one of the following options:

  • Print Manufacturer’s Part only - Prints only the qualified manufacturer’s part number that is selected for a purchase order line prints on supplier-facing documents.
  • Print all Manufacturer Parts - Prints all qualified manufacturer’s part numbers associated with your internal part number on supplier-facing documents.
  • Not printed - Skips printing of the qualified manufacturer’s part number on supplier-facing documents.

Substitute Part

Specifies how substitute part numbers should display in Purchase Order Entry, and print on supplier-facing documents such as the purchase order form. This field is unavailable if no substitute part number have been selected for the internal part number being ordered on this purchase order line.Select one of the following options:

  • Print as a cross reference. - Prints the selected substitute part number as a cross-reference on supplier-facing documents. The substitute part number displays in the Cross Referenced Part field in the Purchase Order Entry - Lines Detail sheet. Your original internal part number displays in the Part/Rev field.
  • Original part not printed - Prints only the substitute part number, and skips printing of the original part number on supplier-facing documents. This is the default value for this field.
  • Print original as a cross reference. - Prints the original part number as a cross-reference on supplier-facing documents. The original part number in the Cross Referenced Part field in the Purchase Order Entry - Lines Detail sheet, and the substitute part number displays in the Part/Rev field.

Supplier Part

Specifies how supplier part numbers should print on supplier-facing documents such as the purchase order form. This field is unavailable if no supplier part numbers have been selected for the internal part number being ordered on this purchase order line. Select one of the following options:

  • Print as a Secondary Reference - Prints the supplier part number selected on the purchase order line as a secondary reference (along with your internal part number) on supplier-facing documents.
  • Print as main part reference - Prints the supplier part number as the main reference, along with your internal part number, on supplier-facing documents. This is the default value for this field.
  • Print only the Supplier Part - Prints only the supplier part number selected on the purchase order line on supplier-facing documents, and skips printing of your internal part number.
  • Print all Supplier Parts - Prints all supplier part numbers associated with your internal part number on supplier-facing documents.
  • Not printed - Skips printing of the supplier part number on supplier-facing documents.
5 Likes
15

Apparently one can learn from a Jedi

Thanks Haso!

16

That is a button I have never ventured to press. I will check it out. I’m now assuming that means if our purchasing department doesn’t want to use the default setting, they will always have to modify the part cross reference settings… is that true?

1 Like