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]
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]