Stock Status Quantities are Off?

Good Day Tim:

The Stock Status report is known to NOT get the cost correct if run
for a 'historical' date. It gets it right 'most' of the time.

I never got a complete answer, but the thread I had is below.

len.hartka@...


*************************************************
Hi Len,



From development;



The stock status report logic calculates cost by finding the last
ADJ-CST transaction from the cost rollup or a manual adjustment by
parttran tran date and uses that. It does not pull from the part cost
table. The part cost table and the transactions and such will use the
last ADJ-CST transaction by parttran sysdate to pull cost from so it is
pulling the backdated cost adjustment cost to determine its cost.





Ken



From: Len Hartka [mailto:Len.Hartka@...]
Sent: Wednesday, March 21, 2012 11:02 AM
To: Ken Adams
Subject: RE: Call 1396150PSC Support Reply: NEW IM 9.05 Stock-Status
Report - if old date is cost current or as-of



Good Day Ken:



I am less interested in these parts then I am in the philosophy.



Would it be easier to look at the code and see where it gets its
cost?



I know it will not be simple becasue I suspect it is the cost used
on the last transaction - except problably only certain types of
transactions.




Len



________________________________

From: Ken Adams [mailto:kadams@...]
Sent: Wednesday, March 21, 2012 7:58 AM
To: Len Hartka
Subject: RE: Call 1396150PSC Support Reply: NEW IM 9.05 Stock-Status
Report - if old date is cost current or as-of

Hi Len

The stock status report in E9 is not meant to be a sub ledger of the GL.
Back dated reports are problematic to begin with. That is more so the
fact when items have back dated transactions, especially back dated cost
adjustment transactions.

I'll certainly take a look at your data to try to figure out what
calculations are taking place, but I will also need to see the column
with the system date.

Thanks

Ken

From: Len Hartka [mailto:Len.Hartka@...]
Sent: Tuesday, March 20, 2012 7:24 PM
To: Ken Adams
Cc: IT Department
Subject: RE: Call 1396150PSC Support Reply: NEW IM 9.05 Stock-Status
Report - if old date is cost current or as-of

Good Day Ken:

Because I had been told in the past that Stock-Status does
correct both, and since I thought I had checked it out a few years ago (
in M2K) I thought I would do some testing. Also, this is a very valuable
tool for us; so I need a good answer.

Another possibility is that I was told once that it tries to do
it but cannot get it correct, so Epicor does not say that it does.

I think the answer is more complicated then that it uses the
current cost..


************************************************************************
**************

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sci.thollingsworth
Sent: Friday, August 10, 2012 1:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Stock Status Quantities are Off?




Hello Everyone,

Hope someone has an answer for this one. I added a part per an inventory
into our system. Part transaction history tracker shows the one part
added via QTY-ADJ, and the cost adjustment to assign value. I then ran a
stock status report dated 6-30-2012, and the part shows (correctly)
quantity 1, value $200. 5 days later I realize I should not have added
the part and do a quantity adjustment to remove the part. I run a stock
status any time after this and the quantity/value is correct. However,
if I run a stock status report for 6-30-2012 now, it shows 47 parts at
$9400? If I look in part transaction history tracker I see only the 1
part added, 1 part removed. I see nothing whatsoever regarding the 47
pieces, or the $9400. Has anyone ever run into this? Any ideas where I
should look for an answer?

Any help is greatly appreciated. Thanks,

Tim Hollingsworth
Cost Accountant
Sun Country Industries
(505) 998-1980 (office)
(703) 867-4400 (cell)
thollingsworth@...
<mailto:thollingsworth%40suncountryindustries.com>






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
Hello Everyone,

Hope someone has an answer for this one. I added a part per an inventory into our system. Part transaction history tracker shows the one part added via QTY-ADJ, and the cost adjustment to assign value. I then ran a stock status report dated 6-30-2012, and the part shows (correctly) quantity 1, value $200. 5 days later I realize I should not have added the part and do a quantity adjustment to remove the part. I run a stock status any time after this and the quantity/value is correct. However, if I run a stock status report for 6-30-2012 now, it shows 47 parts at $9400? If I look in part transaction history tracker I see only the 1 part added, 1 part removed. I see nothing whatsoever regarding the 47 pieces, or the $9400. Has anyone ever run into this? Any ideas where I should look for an answer?

Any help is greatly appreciated. Thanks,

Tim Hollingsworth
Cost Accountant
Sun Country Industries
(505) 998-1980 (office)
(703) 867-4400 (cell)
thollingsworth@...
Tim, this is actually more of a common occurence than most realize. Take a snapshot of the stock status and the part transaction history and then run conversion 6340 to see if that resynchs everything



________________________________
From: sci.thollingsworth <thollingsworth@...>
To: vantage@yahoogroups.com
Sent: Friday, August 10, 2012 1:27 PM
Subject: [Vantage] Stock Status Quantities are Off?


Â
Hello Everyone,

Hope someone has an answer for this one. I added a part per an inventory into our system. Part transaction history tracker shows the one part added via QTY-ADJ, and the cost adjustment to assign value. I then ran a stock status report dated 6-30-2012, and the part shows (correctly) quantity 1, value $200. 5 days later I realize I should not have added the part and do a quantity adjustment to remove the part. I run a stock status any time after this and the quantity/value is correct. However, if I run a stock status report for 6-30-2012 now, it shows 47 parts at $9400? If I look in part transaction history tracker I see only the 1 part added, 1 part removed. I see nothing whatsoever regarding the 47 pieces, or the $9400. Has anyone ever run into this? Any ideas where I should look for an answer?

Any help is greatly appreciated. Thanks,

Tim Hollingsworth
Cost Accountant
Sun Country Industries
(505) 998-1980 (office)
(703) 867-4400 (cell)
mailto:thollingsworth%40suncountryindustries.com




[Non-text portions of this message have been removed]
Thanks for the reply Mark. Not sure I understand how to run conversion 6340 though... Do you have anymore information on this on can you point me to where I might find out more about this?

Thanks,

Tim


--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> Tim, this is actually more of a common occurence than most realize. Take a snapshot of the stock status and the part transaction history and then run conversion 6340 to see if that resynchs everything
>
>
>
> ________________________________
> From: sci.thollingsworth <thollingsworth@...>
> To: vantage@yahoogroups.com
> Sent: Friday, August 10, 2012 1:27 PM
> Subject: [Vantage] Stock Status Quantities are Off?
>
>
> ÂÂ
> Hello Everyone,
>
> Hope someone has an answer for this one. I added a part per an inventory into our system. Part transaction history tracker shows the one part added via QTY-ADJ, and the cost adjustment to assign value. I then ran a stock status report dated 6-30-2012, and the part shows (correctly) quantity 1, value $200. 5 days later I realize I should not have added the part and do a quantity adjustment to remove the part. I run a stock status any time after this and the quantity/value is correct. However, if I run a stock status report for 6-30-2012 now, it shows 47 parts at $9400? If I look in part transaction history tracker I see only the 1 part added, 1 part removed. I see nothing whatsoever regarding the 47 pieces, or the $9400. Has anyone ever run into this? Any ideas where I should look for an answer?
>
> Any help is greatly appreciated. Thanks,
>
> Tim Hollingsworth
> Cost Accountant
> Sun Country Industries
> (505) 998-1980 (office)
> (703) 867-4400 (cell)
> mailto:thollingsworth%40suncountryindustries.com
>
>
>
>
> [Non-text portions of this message have been removed]
>
Good Day Tim:

Be careful with 6430 - on some versions ( 9.05.601B for one) it made errors and created more imbalances.

You may need a hot fix.

Below is notes I had to run it with.

Run on test server first.

********************************************************************
This tool is on the 32bit server (sun66epirpt) run 6430 qty fix

Run tools: Start >> Programs >> Epicor >> TRAIN >> Admin tools

________________________________

From: Len Hartka
Sent: Friday, March 11, 2011 8:28 PM
To: IT Department
Cc: 'Rick Welling'
Subject: RE: Call 1323221PSC Support Reply: 3/11 IM PartQty File has wrong data


Good Day Bill:

If you look at emails over the weekend, please give me hint how to find this folder.

Is it the App server or DB server - What Drive - do you have files hidden ?

I am connecting with from DOS prompt >> mstsc >> Sun66epiapp ( sn66epidb >> admin is only login >> [drive?] there is no ICON as Marcia said.


Len

________________________________

From: Rick Welling [mailto:rwelling@...]
Sent: Friday, March 11, 2011 2:53 PM
To: Len Hartka
Cc: IT Department
Subject: RE: Call 1323221PSC Support Reply: 3/11 IM PartQty File has wrong data



Len,



Below is what you are looking for in the menu tree. Surely Jerry or Bill have been in here before to run fix programs from Epicor, or to run the data conversions after a patch.





<outbind://12-000000006FFAB850DCF904478BE05F43D031BD7764A52500/cid:582044710@14032011-1BDF>

**********************************************************************************


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of sci.thollingsworth
Sent: Friday, August 10, 2012 2:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Stock Status Quantities are Off?





Thanks for the reply Mark. Not sure I understand how to run conversion 6340 though... Do you have anymore information on this on can you point me to where I might find out more about this?

Thanks,

Tim

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Mark Wagner <mjfw2003@...> wrote:
>
> Tim, this is actually more of a common occurence than most realize. Take a snapshot of the stock status and the part transaction history and then run conversion 6340 to see if that resynchs everything
>
>
>
> ________________________________
> From: sci.thollingsworth <thollingsworth@...>
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Sent: Friday, August 10, 2012 1:27 PM
> Subject: [Vantage] Stock Status Quantities are Off?
>
>
> Â
> Hello Everyone,
>
> Hope someone has an answer for this one. I added a part per an inventory into our system. Part transaction history tracker shows the one part added via QTY-ADJ, and the cost adjustment to assign value. I then ran a stock status report dated 6-30-2012, and the part shows (correctly) quantity 1, value $200. 5 days later I realize I should not have added the part and do a quantity adjustment to remove the part. I run a stock status any time after this and the quantity/value is correct. However, if I run a stock status report for 6-30-2012 now, it shows 47 parts at $9400? If I look in part transaction history tracker I see only the 1 part added, 1 part removed. I see nothing whatsoever regarding the 47 pieces, or the $9400. Has anyone ever run into this? Any ideas where I should look for an answer?
>
> Any help is greatly appreciated. Thanks,
>
> Tim Hollingsworth
> Cost Accountant
> Sun Country Industries
> (505) 998-1980 (office)
> (703) 867-4400 (cell)
> mailto:thollingsworth%40suncountryindustries.com
>
>
>
>
> [Non-text portions of this message have been removed]
>






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]