ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> Inventory Reconciliation/ Exception Report
http://www.istechforum.com/YaBB.pl?num=1183127662

Message started by ddlong on 06/29/07 at 07:34:22

Title: Inventory Reconciliation/ Exception Report
Post by ddlong on 06/29/07 at 07:34:22

We are using EVO/ DBA Classic latest version with all patches posted thru yesterday.

We are getting ready to run a physical inventory so last night I ran SM-J-C with both master level reconciliation and transaction level - A to match master level.

It seemed to run fine.

When I run my inventory exception report, I still have several parts that show the following:

Note: UOH total of locations not same as UOH total of inventory record. Use Reconcile Inventory to correct.

Why didn't it correct it?

This isn't something new, but I have never reported it on the forum.

Darla Long
CIG, Inc.
Independence, Ks

Title: Re: Inventory Reconciliation/ Exception Report
Post by Vman on 06/29/07 at 08:26:43

Not sure if this is any help, but at one time my company had multiple locations, which we subsequently consolidated. I then ran the reconciliation, and it recreated the additional locations on the items that previously had more than one, even though they did not exsist in the master location database. I had to use maintain database to fix it.

Title: Re: Inventory Reconciliation/ Exception Report
Post by ddlong on 06/29/07 at 09:22:56

Thanks for your input. We have had a lot of problems keeping the old "blank" location out. We have 3 main locations - none of them blank and each time I run the reconciliation, it does add back that blank location - I have in the past fixed in maintatin database, but the next time I run the reconciliation it always comes back.

Title: Re: Inventory Reconciliation/ Exception Report
Post by GasGiant on 06/29/07 at 12:24:20

SM-J-C will not correct serial/lot number mismatches. For instance, if location A has 5 widgets, but only 4 serial numbers available for them... that is an error that must be corrected by a human.

Also, if the locations have a positive and a negative number, e.g. part 1234 shows 4 on hand in location A and -4 in location B, that is a good balance if the master says 0, but it is a problem for each location. SM-J-C doesn't seem to know what to do about that.

Title: Re: Inventory Reconciliation/ Exception Report
Post by fast on 08/14/07 at 12:58:49

Another item we are getting and have not been able to keep clean...

"Note: UOH total of locations not same as UOH total of inventory record. Use Reconcile Inventory to correct"

It seems that once they get cleaned/fixed, they always come back.

Title: Re: Inventory Reconciliation/ Exception Report
Post by GasGiant on 08/14/07 at 13:50:32

Some process is taking inventory from the wrong location. When I find this it usually means that someone created Work Orders for a non-inventory location. We ship equipment being sent out for customer trial from a special location, which helps us to keep our books straight and to track the items until they are either returned or paid for by the customer. If the Production Team Leader uses SO-N to create Work Orders for a trial Sales Order, he has to remember to change the WO location during the process. Otherwise, the product will get built in a different location from where the inventory is kept. As soon as that WO is backflushed... blast! Now we have 22 parts forced negative in our special shipping location. I've recently started making the person who created the Work Order fix the problem by transferring all of the parts from the inventory location into the special location. It seem to be cutting down on the location mismatch problem ;)