Different quantities in part transaction history tracker to part tracker?

Epicor ERP 9
1

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.

Pasted image1836×933 80.9 KB

2

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

3

Dear Dora,

the transactions are not in the Material Request Queue…

Pasted image1603×654 44.9 KB

4

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

5

What does running the Stock Status Report say?

6

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

7

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

8

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

Pasted image1747×459 13.7 KB

9

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

Pasted image870×215 3.46 KB

10

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

Pasted image914×493 5.1 KB

11

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

12

Here is the detail behind the error:

Pasted image980×748 10.7 KB

13

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

14

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)

1 Like
15

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

16

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

1 Like
17

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.

18

We’re on E10.0.700.4 the SCR is 165979

19

thank you

20

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. "

1 Like