PUR-UKN transactions on a stock Item

Epicor ERP 10
, , ,
1

Hi all,
I am having an issue with a single part that has been setup like all others, but when receiving it goes nowhere.
We have a minimum on hand as well that produces a PO suggestion all the time, but we cannot receive it.
In the latest transaction it is possible to see a bin being used but the transaction was still PUR-UKN and stock remains to 0.
I have finished the usual checks and I do not know where else to look

2

Is the PO line you’re receiving against setup as ‘inventory’ or ‘other’?

3

It is on Other and I cannot change it.
The part is setting it, but I cannot see where the part setup went wrong

4

If there are transactions against the PO Line then I don’t think you can change it. You’ll need to create a new PO Line as ‘inventory’.

5

I would like to change the part in order to have a chance to have future purchasing going in stock

6

Are NonStock and Qty Bearing set correctly (NonStock = false, Qty Bearing = true) for the Part and all Part Plant records?

7

Yes, check, check, and triple check

8

Hi Valentina,

Any chance user typed the part number in incorrectly and it is very similar to the one in the part master? If not that, any chance the part setup got changed to look all “a ok” after the PO was already cut?

Nancy

9

Unluckily no. I have just tried to recreate the issue in the Test environment and with the same part, same settings, same etc. it created an Other line, just as the original issue.

10

Check the Part → Sites → Detail tab in part maintenance. It can be set different from the values on Part → Detail

11

Are you specifying an Order line in the PO? That may force it to be “Buy To Order” which uses the “Other” purchase line type

12

Part Detail: image

Part Plant: image

13

@ckrusen I am creating the PO, selecting New Line, selecting the part no. and it goes on Other.

14

Does this part have a PartClass assigned? If so, do other parts of that class do the same?

15

It is a consumable part, and all other parts with consumable class are going into stock.

16

Does the issue happen if you were to select a different supplier?

17

Yes, I have tested with the proper one and a couple of other random ones

18

I ran a trace of creating a new PO line for a Qty Bearing part, and see:

<changedValue tableName="PODetail" rowState="Added" rowNum="0" colName="CalcTranType"><![CDATA[PUR-STK]]></changedValue>

That’s from BO PO.ChangeDetailPartNum

Which is what I would expect, except for the fact that the PODetail table doesn’t have a column named CalcTranType. And that the TranType isn’t even stored in PODetail. It is stored in PORel.

The Data Diction for PORel.TranType:

image

If you do a trace, does it show “PUR-UKN” ?

19

AND just curious, is there currently any QOH of the part?

20

FOUND!
the trace was showing PUR-STK and all past transactions were PUR-UKN.
Apparently it wasn’t a new item set up last November as believed at the beginning, but an older one that used to be non-stock and all orders have been raised while the part was using these settings.

Thanks everyone!

1 Like