E9: Errors with Stock Status Report

Yahoo Archive
1
Hi Tom,



I don’t think the stock status report has ever been right. I’ve found problems with it in version 5, 6 and 8 of Vantage.



Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Tom
Sent: Tuesday, September 28, 2010 1:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Errors with Stock Status Report





Hello,

We created a costed inventory report and wanted to check it against the stock status report. What we are finding is that there are discrepancies between the two reports, but when I look at the part tracker warehouse and bin quantities it turns out that my custom report is correct and the stock status has the wrong quantities.

Has anyone else run across this, or are you aware of anything that could be causing the stock status report to have different quantities than the part tracker?

Thank You,
Tom Scott





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

We created a costed inventory report and wanted to check it against the stock status report. What we are finding is that there are discrepancies between the two reports, but when I look at the part tracker warehouse and bin quantities it turns out that my custom report is correct and the stock status has the wrong quantities.

Has anyone else run across this, or are you aware of anything that could be causing the stock status report to have different quantities than the part tracker?

Thank You,
Tom Scott
3
The Stock Status report uses transaction history from the PartTran table to calculate quantities. This has the potential to differ from the OnHandQty stored in the PartWhse and PartBin tables, especially if people enter adjustment transactions and modify the transaction date.

--- In vantage@yahoogroups.com, "Tom" <scott.tom54@...> wrote:
>
> Hello,
>
> We created a costed inventory report and wanted to check it against the stock status report. What we are finding is that there are discrepancies between the two reports, but when I look at the part tracker warehouse and bin quantities it turns out that my custom report is correct and the stock status has the wrong quantities.
>
> Has anyone else run across this, or are you aware of anything that could be causing the stock status report to have different quantities than the part tracker?
>
> Thank You,
> Tom Scott
>