# Different quantities in part transaction history tracker to part tracker?

**Category:** [Epicor ERP 9](https://www.epiusers.help/c/e9/7)
**Created:** 2017-01-17 16:45 UTC
**Views:** 5125
**Replies:** 30
**URL:** https://www.epiusers.help/t/different-quantities-in-part-transaction-history-tracker-to-part-tracker/36922

---

## Post #1 by @Rowley150

Epicor version 9.05.401

Something odd has just happened, my colleague did an inventory transfer moving 26 x part number H1817 from the Main warehouse to Obsolete warehouse.
You can see the transaction in the part transaction history tracker and it has a TranID................however, the part tracker numbers haven't updated and the 26 are still in Main??

I ran conversion 6480, but it hasn't fixed it.

Any help would be much appreciated.

Thank you in advance.

<img src="/uploads/default/original/2X/f/fca9ab9c82596877481141e8c5cfa26be34897de.png" width="690" height="350">

---

## Post #2 by @Dora

Have you verified on the Advanced Material Management under Material Request Q if the transaction is there?

---

## Post #3 by @Rowley150

Dear Dora,

the transactions are not in the Material Request Queue...........

<img src="/uploads/default/original/2X/6/6d346acec0efceb9983eea7e689bab26c17c8e32.png" width="690" height="281">

---

## Post #4 by @Rowley150

I also looked in Material Queue Manager...............they weren't in there either.

---

## Post #5 by @ckrusen

What does running the Stock Status Report say?

---

## Post #6 by @Rowley150

Hi,
The stock status says the 26 are still in main.

---

## Post #7 by @ckrusen

Double check the Transaction date?  I've often got tripped up looking at SysDate in Part Transaction History, thinking it was the TranDate.

---

## Post #8 by @Rowley150

Hi,
Tran Date and Sys Date are both the same, 17/01/2017

<img src="/uploads/default/original/2X/b/be889552c730acaea548178a31caca9d94aba2dd.png" width="690" height="181">

---

## Post #9 by @Rowley150

This is the 26 in the stock status report, still in the Main Warehouse.

<img src="/uploads/default/original/2X/c/c5e11c2050e9b7ab946733e8c693440c8bd39595.png" width="690" height="170">

---

## Post #10 by @Rowley150

Just ran the "Material transaction detail report" in Inventory Management/Reports .........and as you can see the transactions are there.

<img src="/uploads/default/original/2X/4/41aa99fb880df7f085d4c0239802bad257369dd3.png" width="690" height="372">

---

## Post #11 by @Rowley150

When my colleage tried to do the transaction...........he said he go this error message:

<img src="/uploads/default/original/2X/1/1c041c93f659ff158f3957c976341dc16e022093.png" width="392" height="178">

---

## Post #12 by @Rowley150

Here is the detail behind the error:

<img src="/uploads/default/original/2X/2/269bfdc9d7f3b0319afc6ed9ffc25f2dcb4577fd.png" width="655" height="500">

---

## Post #13 by @Rowley150

I'm going to try a full server reboot later tonight and see if that realigns everything

---

## Post #14 by @Randy

We were getting that same error in one of our Bins last week. Epicor sent a
SCR fix on Monday we had to apply. It worked on our test server, but I
can't put it on production until weekend maintenance. (IIS reset required)

---

## Post #15 by @Rowley150

Update...........i've rebooted the server.......no change at all.

**Randy:** do you have the name of the fix that epicor sent you so that i can request the same?

Many thanks.

Mark

---

## Post #16 by @Randy

Not on me, but I can look it up at work tomorrow.

---

## Post #17 by @Rowley150

I got to say when epicor do send me the fix, ..........usually we'd test it in the TEST database first, but the problem doesn't occur in the TEST database......i would just be a bit reluctant to apply it straight to the LIVE database.

---

## Post #18 by @Randy

We're on E10.0.700.4 the SCR is 165979

---

## Post #19 by @Rowley150

thank you

---

## Post #20 by @Nancy

The conversion we used to need to run in earlier versions (we're on 905702a now) was 6430.

I found this in my old email with Phil Berglund Epicor support:

 "  The 7195 is very similar to the 6430, it resynchronizes tables and fields that are out of synch with each other.  It addresses the PlantWhse, PartPlant and PartWhse tables that hold part quantity related information.  
   General Information Page 8994mps enclosed below explains how to run the 6430 conversion in the Admin tools, these same steps also apply to the 7195; it's located a little further down this same list of
conversions the 6430 is located in.   "

---

## Post #21 by @Rowley150

Hi Nancy
I just ran conversion 6430 and 7195 but it didnt change anything i'm afraid.

Thanks.
Mark

---

## Post #22 by @Nancy

I think I'd do a query and pull the parttran records associated with your problem child above and also with a part inventory transfer that went smoothly and see if/how data looks different.. see if system has something "half baked" in there.

---

## Post #23 by @Jim_Lutz

Check the Bins tab of the tracker; it really should be there even if it isn't right in the other tabs. Sometimes there are issues with Epicor and conversion 6430 with summarizing allocations and on-hand data for the bins, warehouses, and plants; I have a ticket open concerning both with E9.05.702A. However, the on-hand number for the bin is authoritative. If that doesn't reflect the transaction, you'll need a program from Support to recalculate that bin.

---

## Post #24 by @Rowley150

Nope, its still in MAIN in the bins tab.

<img src="/uploads/default/original/2X/2/2bd3dcad8d4b883c9ca42c89578bebce6d668f58.png" width="690" height="238">

---

## Post #25 by @Jim_Lutz

Interesting. It seems to me that since there is a transaction record but no change in partbin records, maybe there is a BPM interfering, probably a data directive on the partbin table. Can you verify?

I notice that you say this warehouse is named "Obsolete". Do you have some feature that would disable a warehouse, and might include a BPM as above?

Also, if a PartWhse record or PlantWhse record was removed via SQL or something, it may cause an error like this; can you verify these records for this Part, Plant, and both Warehouses?

---

## Post #26 by @Rowley150

your right i do have a bpm data directive on PARTBIN............the directive is to basically stop any bin going less than 0 quantity.

if i disable it and re-run the conversions?

---

## Post #27 by @Rowley150

<img src="/uploads/default/original/2X/9/95dc762ebcd0d2b83c8d266c3b1a02c71cf1e888.png" width="690" height="433">

---

## Post #28 by @Rowley150


ok its fixed.
1. i disabled the BPM
2. i reran conversion 6430 and then got the below results........

thank you everybody so much for your comments, i really appreciate it!


<img src="/uploads/default/original/2X/0/0729ca0053be22eb764416a59084b10311979f92.png" width="690" height="259">

---

## Post #29 by @Jim_Lutz

Is it bad that I think I remember replying to a question about you developing such a BPM? Lol!

---

## Post #30 by @Kimberley

We had a similar problem and Epicor sent us a fix.

---

## Post #31 by @Rowley150

Nah lol!!
Really I'd still like to have that BPM active .... It may just need tweaking

---


**Canonical:** https://www.epiusers.help/t/different-quantities-in-part-transaction-history-tracker-to-part-tracker/36922
**Original content:** https://www.epiusers.help/t/different-quantities-in-part-transaction-history-tracker-to-part-tracker/36922