Stock Status and Inventory Reconciliation (v6.1)

Yahoo Archive
1
Are the non-nettable parts being purchased to your inventory account? Do you
see any adj-cst transactions on the inventory wip recon report? Remember the
stock status report if I remember correctly uses the cost today even if you
are looking at date in the past. Check to see if the trans date and the sys
date are the same for the transactions in either report builder or crystal.
This can cause issues when people back date activity and things haven't been
posted yet.

Jim


_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Lowe
Sent: Tuesday, November 07, 2006 4:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Stock Status and Inventory Reconciliation (v6.1)



Ok, I'm ready to cry Uncle. I've been trying to reconcile day to day
changes in Stock Status values to the Inventory /Wip Reconciliation
report and am not having any success. We have never been able to tie at
month end so I decided to make my job a little easier by taking two
Stock Status report runs (10/31 and 11/01) and seeing if the difference
between the two values match the transactional changes noted on the
Inventory Wip recon report.

Things I've attempted (from personal experience and by looking at some
support docs)

First, there were no cost changes between the above time period and
today so that issue isn't present here. Also, I always run the stock
status the same way to include mfg and pur parts, include non-stock
parts, include non-nettable parts, etc. The as of dates are correct and
I've checked through PartTran to verify that there are no incorrect
Transaction Date issues.

I've checked all inventory transactions to see if any (for example)
PUR-STK transactions are coded to an expense account instead of
inventory. All GL transactions are correct. Also, all Control Accounts
are set up correctly.

No parts were received to non-nettable bins during the time period (but
this shouldn't be an issue anyway with the new Stk Status filtering
options).

Manual entries to the GL are not an issue here since I'm just trying to
reconcile from the Inventory / Wip Reconcilation report. That is, we
haven't posted yet to the GL. I'm just reconciling to the GL /
Inventory sub-ledger.

I created a Crystal Report looking at the Part Transaction records for
11/01 and all Transaction Types have been coded to the correct and
expected GL accounts.

Any PUR-UNK transactions are being coded to expense accounts so this
isn't an issue.

I ran conversion 6430 but there was no change in results.

We use Standard costing so I suspected that someone was changing costing
methods however a review of the Part change logs ruled this out as a
source of the problem.

Also, I ran the Material Transaction Detail reports for Inventory
Transactions and these amounts on 11/1 match the data on the Inventory /
Wip recon report.

At this point I'm not sure what else to do. I can accept small rounding
issues but I'm generally off by $500-600 per day.

Any suggestions? Please?

Mike Lowe
Deep in the bowels of Inventory Reconciliation Hell

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







[Non-text portions of this message have been removed]
2
Ok, I'm ready to cry Uncle. I've been trying to reconcile day to day
changes in Stock Status values to the Inventory /Wip Reconciliation
report and am not having any success. We have never been able to tie at
month end so I decided to make my job a little easier by taking two
Stock Status report runs (10/31 and 11/01) and seeing if the difference
between the two values match the transactional changes noted on the
Inventory Wip recon report.

Things I've attempted (from personal experience and by looking at some
support docs)

First, there were no cost changes between the above time period and
today so that issue isn't present here. Also, I always run the stock
status the same way to include mfg and pur parts, include non-stock
parts, include non-nettable parts, etc. The as of dates are correct and
I've checked through PartTran to verify that there are no incorrect
Transaction Date issues.

I've checked all inventory transactions to see if any (for example)
PUR-STK transactions are coded to an expense account instead of
inventory. All GL transactions are correct. Also, all Control Accounts
are set up correctly.

No parts were received to non-nettable bins during the time period (but
this shouldn't be an issue anyway with the new Stk Status filtering
options).

Manual entries to the GL are not an issue here since I'm just trying to
reconcile from the Inventory / Wip Reconcilation report. That is, we
haven't posted yet to the GL. I'm just reconciling to the GL /
Inventory sub-ledger.

I created a Crystal Report looking at the Part Transaction records for
11/01 and all Transaction Types have been coded to the correct and
expected GL accounts.

Any PUR-UNK transactions are being coded to expense accounts so this
isn't an issue.

I ran conversion 6430 but there was no change in results.

We use Standard costing so I suspected that someone was changing costing
methods however a review of the Part change logs ruled this out as a
source of the problem.

Also, I ran the Material Transaction Detail reports for Inventory
Transactions and these amounts on 11/1 match the data on the Inventory /
Wip recon report.

At this point I'm not sure what else to do. I can accept small rounding
issues but I'm generally off by $500-600 per day.

Any suggestions? Please?

Mike Lowe
Deep in the bowels of Inventory Reconciliation Hell


[Non-text portions of this message have been removed]
3
Get a life!


[Non-text portions of this message have been removed]
4
We have stepped on this same trail to hell, but have not dove into to
the depths you have reached. Our situation is a little more volatile as
we are in Actual Average cost accounting. From our 11/1 to 10/31 we
found 11K of 40K which had been backdated shipment corrections (SysDate
vs. TransDate). We had a lot in Phantom Purges.



Phantom Purges seem to be our major issue. We want to know when the
transaction actually took place. It looks like it dates it for the day
the previous month was closed.



I don't think this helps, but I am definitely interested in what you
find.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Tuesday, November 07, 2006 5:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Stock Status and Inventory Reconciliation (v6.1)



Ok, I'm ready to cry Uncle. I've been trying to reconcile day to day
changes in Stock Status values to the Inventory /Wip Reconciliation
report and am not having any success. We have never been able to tie at
month end so I decided to make my job a little easier by taking two
Stock Status report runs (10/31 and 11/01) and seeing if the difference
between the two values match the transactional changes noted on the
Inventory Wip recon report.

Things I've attempted (from personal experience and by looking at some
support docs)

First, there were no cost changes between the above time period and
today so that issue isn't present here. Also, I always run the stock
status the same way to include mfg and pur parts, include non-stock
parts, include non-nettable parts, etc. The as of dates are correct and
I've checked through PartTran to verify that there are no incorrect
Transaction Date issues.

I've checked all inventory transactions to see if any (for example)
PUR-STK transactions are coded to an expense account instead of
inventory. All GL transactions are correct. Also, all Control Accounts
are set up correctly.

No parts were received to non-nettable bins during the time period (but
this shouldn't be an issue anyway with the new Stk Status filtering
options).

Manual entries to the GL are not an issue here since I'm just trying to
reconcile from the Inventory / Wip Reconcilation report. That is, we
haven't posted yet to the GL. I'm just reconciling to the GL /
Inventory sub-ledger.

I created a Crystal Report looking at the Part Transaction records for
11/01 and all Transaction Types have been coded to the correct and
expected GL accounts.

Any PUR-UNK transactions are being coded to expense accounts so this
isn't an issue.

I ran conversion 6430 but there was no change in results.

We use Standard costing so I suspected that someone was changing costing
methods however a review of the Part change logs ruled this out as a
source of the problem.

Also, I ran the Material Transaction Detail reports for Inventory
Transactions and these amounts on 11/1 match the data on the Inventory /
Wip recon report.

At this point I'm not sure what else to do. I can accept small rounding
issues but I'm generally off by $500-600 per day.

Any suggestions? Please?

Mike Lowe
Deep in the bowels of Inventory Reconciliation Hell

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





[Non-text portions of this message have been removed]
5
Off by 500-600 per day - so your month end is off by 10,000 or does it
average out to be much less than that?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Tuesday, November 07, 2006 5:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Stock Status and Inventory Reconciliation (v6.1)



Ok, I'm ready to cry Uncle. I've been trying to reconcile day to day
changes in Stock Status values to the Inventory /Wip Reconciliation
report and am not having any success. We have never been able to tie at
month end so I decided to make my job a little easier by taking two
Stock Status report runs (10/31 and 11/01) and seeing if the difference
between the two values match the transactional changes noted on the
Inventory Wip recon report.

Things I've attempted (from personal experience and by looking at some
support docs)

First, there were no cost changes between the above time period and
today so that issue isn't present here. Also, I always run the stock
status the same way to include mfg and pur parts, include non-stock
parts, include non-nettable parts, etc. The as of dates are correct and
I've checked through PartTran to verify that there are no incorrect
Transaction Date issues.

I've checked all inventory transactions to see if any (for example)
PUR-STK transactions are coded to an expense account instead of
inventory. All GL transactions are correct. Also, all Control Accounts
are set up correctly.

No parts were received to non-nettable bins during the time period (but
this shouldn't be an issue anyway with the new Stk Status filtering
options).

Manual entries to the GL are not an issue here since I'm just trying to
reconcile from the Inventory / Wip Reconcilation report. That is, we
haven't posted yet to the GL. I'm just reconciling to the GL /
Inventory sub-ledger.

I created a Crystal Report looking at the Part Transaction records for
11/01 and all Transaction Types have been coded to the correct and
expected GL accounts.

Any PUR-UNK transactions are being coded to expense accounts so this
isn't an issue.

I ran conversion 6430 but there was no change in results.

We use Standard costing so I suspected that someone was changing costing
methods however a review of the Part change logs ruled this out as a
source of the problem.

Also, I ran the Material Transaction Detail reports for Inventory
Transactions and these amounts on 11/1 match the data on the Inventory /
Wip recon report.

At this point I'm not sure what else to do. I can accept small rounding
issues but I'm generally off by $500-600 per day.

Any suggestions? Please?

Mike Lowe
Deep in the bowels of Inventory Reconciliation Hell

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


This message has been processed via your triumphgroup.com e-mail
address.



[Non-text portions of this message have been removed]
6
Mike, we are currently on 5.2, going to 6.0 in two weeks. One thing
that you mentioned was your PUR-UNK parts were being expensed. That
might be one of your problems. If you have a part set up and you have
it expensed, make sure that you don't include that class or warehouse
when you run your stock status report. We normally are off no more than
$50 per month with over 6 million dollars in inventory.



Randall Lunsford
Excel Machinery, Ltd.
e-mail: rlunsf@...
Phone: (806) 335-4565 ext. 531
Fax: (806) 335-9017

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bruce Butler
Sent: Wednesday, November 08, 2006 7:18 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Stock Status and Inventory Reconciliation (v6.1)



We have stepped on this same trail to hell, but have not dove into to
the depths you have reached. Our situation is a little more volatile as
we are in Actual Average cost accounting. From our 11/1 to 10/31 we
found 11K of 40K which had been backdated shipment corrections (SysDate
vs. TransDate). We had a lot in Phantom Purges.

Phantom Purges seem to be our major issue. We want to know when the
transaction actually took place. It looks like it dates it for the day
the previous month was closed.

I don't think this helps, but I am definitely interested in what you
find.

Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mike Lowe
Sent: Tuesday, November 07, 2006 5:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Stock Status and Inventory Reconciliation (v6.1)

Ok, I'm ready to cry Uncle. I've been trying to reconcile day to day
changes in Stock Status values to the Inventory /Wip Reconciliation
report and am not having any success. We have never been able to tie at
month end so I decided to make my job a little easier by taking two
Stock Status report runs (10/31 and 11/01) and seeing if the difference
between the two values match the transactional changes noted on the
Inventory Wip recon report.

Things I've attempted (from personal experience and by looking at some
support docs)

First, there were no cost changes between the above time period and
today so that issue isn't present here. Also, I always run the stock
status the same way to include mfg and pur parts, include non-stock
parts, include non-nettable parts, etc. The as of dates are correct and
I've checked through PartTran to verify that there are no incorrect
Transaction Date issues.

I've checked all inventory transactions to see if any (for example)
PUR-STK transactions are coded to an expense account instead of
inventory. All GL transactions are correct. Also, all Control Accounts
are set up correctly.

No parts were received to non-nettable bins during the time period (but
this shouldn't be an issue anyway with the new Stk Status filtering
options).

Manual entries to the GL are not an issue here since I'm just trying to
reconcile from the Inventory / Wip Reconcilation report. That is, we
haven't posted yet to the GL. I'm just reconciling to the GL /
Inventory sub-ledger.

I created a Crystal Report looking at the Part Transaction records for
11/01 and all Transaction Types have been coded to the correct and
expected GL accounts.

Any PUR-UNK transactions are being coded to expense accounts so this
isn't an issue.

I ran conversion 6430 but there was no change in results.

We use Standard costing so I suspected that someone was changing costing
methods however a review of the Part change logs ruled this out as a
source of the problem.

Also, I ran the Material Transaction Detail reports for Inventory
Transactions and these amounts on 11/1 match the data on the Inventory /
Wip recon report.

At this point I'm not sure what else to do. I can accept small rounding
issues but I'm generally off by $500-600 per day.

Any suggestions? Please?

Mike Lowe
Deep in the bowels of Inventory Reconciliation Hell

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

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





[Non-text portions of this message have been removed]
7
--- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@...> wrote:
>Boy, would I love to find an answer on this one. It has been
haunting me for months.


> Ok, I'm ready to cry Uncle. I've been trying to reconcile day to
day
> changes in Stock Status values to the Inventory /Wip Reconciliation
> report and am not having any success. We have never been able to
tie at
> month end so I decided to make my job a little easier by taking two
> Stock Status report runs (10/31 and 11/01) and seeing if the
difference
> between the two values match the transactional changes noted on the
> Inventory Wip recon report.
>
> Things I've attempted (from personal experience and by looking at
some
> support docs)
>
> First, there were no cost changes between the above time period and
> today so that issue isn't present here. Also, I always run the
stock
> status the same way to include mfg and pur parts, include non-stock
> parts, include non-nettable parts, etc. The as of dates are
correct and
> I've checked through PartTran to verify that there are no incorrect
> Transaction Date issues.
>
> I've checked all inventory transactions to see if any (for example)
> PUR-STK transactions are coded to an expense account instead of
> inventory. All GL transactions are correct. Also, all Control
Accounts
> are set up correctly.
>
> No parts were received to non-nettable bins during the time period
(but
> this shouldn't be an issue anyway with the new Stk Status filtering
> options).
>
> Manual entries to the GL are not an issue here since I'm just
trying to
> reconcile from the Inventory / Wip Reconcilation report. That is,
we
> haven't posted yet to the GL. I'm just reconciling to the GL /
> Inventory sub-ledger.
>
> I created a Crystal Report looking at the Part Transaction records
for
> 11/01 and all Transaction Types have been coded to the correct and
> expected GL accounts.
>
> Any PUR-UNK transactions are being coded to expense accounts so
this
> isn't an issue.
>
> I ran conversion 6430 but there was no change in results.
>
> We use Standard costing so I suspected that someone was changing
costing
> methods however a review of the Part change logs ruled this out
as a
> source of the problem.
>
> Also, I ran the Material Transaction Detail reports for Inventory
> Transactions and these amounts on 11/1 match the data on the
Inventory /
> Wip recon report.
>
> At this point I'm not sure what else to do. I can accept small
rounding
> issues but I'm generally off by $500-600 per day.
>
> Any suggestions? Please?
>
> Mike Lowe
> Deep in the bowels of Inventory Reconciliation Hell
>
>
> [Non-text portions of this message have been removed]
>
8
Hi,

Do you use lot costing and lot tracked parts that might go negative.
Have you copied your database and posted everything, and this
doesn't reconcile? Have you tried to reconcile the part trans
records against the Gl?

--- In vantage@yahoogroups.com, "bkeller055" <bkeller@...> wrote:
>
> --- In vantage@yahoogroups.com, "Mike Lowe" <MLowe@> wrote:
> >Boy, would I love to find an answer on this one. It has been
> haunting me for months.
>
>
> > Ok, I'm ready to cry Uncle. I've been trying to reconcile day
to
> day
> > changes in Stock Status values to the Inventory /Wip
Reconciliation
> > report and am not having any success. We have never been able
to
> tie at
> > month end so I decided to make my job a little easier by taking
two
> > Stock Status report runs (10/31 and 11/01) and seeing if the
> difference
> > between the two values match the transactional changes noted on
the
> > Inventory Wip recon report.
> >
> > Things I've attempted (from personal experience and by looking
at
> some
> > support docs)
> >
> > First, there were no cost changes between the above time period
and
> > today so that issue isn't present here. Also, I always run the
> stock
> > status the same way to include mfg and pur parts, include non-
stock
> > parts, include non-nettable parts, etc. The as of dates are
> correct and
> > I've checked through PartTran to verify that there are no
incorrect
> > Transaction Date issues.
> >
> > I've checked all inventory transactions to see if any (for
example)
> > PUR-STK transactions are coded to an expense account instead of
> > inventory. All GL transactions are correct. Also, all Control
> Accounts
> > are set up correctly.
> >
> > No parts were received to non-nettable bins during the time
period
> (but
> > this shouldn't be an issue anyway with the new Stk Status
filtering
> > options).
> >
> > Manual entries to the GL are not an issue here since I'm just
> trying to
> > reconcile from the Inventory / Wip Reconcilation report. That
is,
> we
> > haven't posted yet to the GL. I'm just reconciling to the GL /
> > Inventory sub-ledger.
> >
> > I created a Crystal Report looking at the Part Transaction
records
> for
> > 11/01 and all Transaction Types have been coded to the correct
and
> > expected GL accounts.
> >
> > Any PUR-UNK transactions are being coded to expense accounts so
> this
> > isn't an issue.
> >
> > I ran conversion 6430 but there was no change in results.
> >
> > We use Standard costing so I suspected that someone was changing
> costing
> > methods however a review of the Part change logs ruled this out
> as a
> > source of the problem.
> >
> > Also, I ran the Material Transaction Detail reports for Inventory
> > Transactions and these amounts on 11/1 match the data on the
> Inventory /
> > Wip recon report.
> >
> > At this point I'm not sure what else to do. I can accept small
> rounding
> > issues but I'm generally off by $500-600 per day.
> >
> > Any suggestions? Please?
> >
> > Mike Lowe
> > Deep in the bowels of Inventory Reconciliation Hell
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
9
Randall, if you are going to move to version 6, go to 6.1 not 6.0. It
will make it much easier to migrate to the 8.X versions when you are
ready.


Charlie Smith




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