Receipts not Posting to Inventory

[MAKNIGHT71]

Good day!

I was just notified by my purchasing manager that the receiver application is not updating the inventory on hand for a specific item he has recived into the system. He gets a receiver number, but nothing else happens. Both he and myself have checked out the item's master and location records, and both appear to be okay. Any ideas? We are running 7.6.200GR. Thanks.

maknight

 

[crystalreporting]

Is it creating IM transaction history records - run the History report out of IM for an item you're having problems with and let me know. I'm presuming the item is stocked?

Peter Shirley

http://www.linkcorp.com

 

[MAKNIGHT71]

Yes. There are records in the history file as late as July 6 from the receiving user. There is also a record for the 19th where someone in accounting manually added the material to stock. The item is flagged as stocked.

maknight

 

[dgillz]

What does the comment "There is also a record for the 19th where someone in accounting manually added the material to stock" mean?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[crystalreporting]

Is this problem occurring regularly with the one inventory item, or is it sporadically over multiple items?

Peter Shirley

http://www.linkcorp.com

 

[MAKNIGHT71]

As far as anyone can tell, it is only happening with this one item right now.

On 7/19, the purchasing manager had someone in our accounting department perform a manual transaction to add the product to inventory since the automatic method did not work when it was received.

maknight

 

[dgillz]

Please check the item to make sure it is not a receiving inspection item.

Also, run a file validation report on the item master and item location for this item only, and fix any errors you find.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MAKNIGHT71]

We do not use receiving inspection (it is not turned on).

I have never seen a "file validation report". Please point me to where this is. Thanks.

Also, please note that as of last night we have upgrade to 7.6.200.5. This was a planned upgrade. We are running the Pervasive SQL version.

maknight

 

[crystalreporting]

If it's the one item, then I would suspect some sort of setup problem with the item in questions. Sometimes, the time you'd take investigating and tracking down the problem, just isn't worth it - can you create a new item, transfer the inventory to it, and use it instead (i.e. ditch the item number that's giving you problems)? Short of that, I'd probably use the Pervasive control center (PCC) or MSQuery to review ALL of the fields in the IMITMIDX and IMINVLOC tables comparing each field in the problem item with an item that is working correctly. The file validation utility that dgillz is referring to will likely highlight problems you weren't even aware of (or wanted to know about) - you can find it in System Manager, Maintain, System Utilities, File Validation. It was originally designed to validate converted or imported master files and checks to make sure that things link product types have a valid product type record etc.

Peter Shirley

http://www.linkcorp.com

 

[dgillz]

The file validation report is under system manager, maintain, system utilities, file validation.

Run this report for the IMITMIDX and IMINVLOC for only the item in question, and please report back the errors you find.

I do not think deleting and readding the item is the issue, something is set up wrong and we need to identify what it is. The file validation reports will hopefully help us identify this. They have been a great help in the past.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[MAKNIGHT71]

I try to run the File Validation Report from system utilities, and I get a COBOL error message "Cannot Call Program 'VALID'". I checked and the program does not exist on our server.

maknight

 

[kscheeler]

That was an issue after upgrading to 7.6.200. To correct it, you need to log into the visual menu builder as SUPERVISOR. Highlight the user that you want to run the file validations, highlight SMMENU, right click and go to customize. Find the visual menu builder choice, right click on it and go to properties. Change the program name to VALID1, click on the save disk and you should be all set. You'll need to do this for each user that runs the file validations.

Kevin Scheeler

 

[MacolaHelp]

Have you checked the distribution file or run the history report to include distributions? It sounds like iminvloc is not updated when you receipt goods. Does it create history or imdifil records? If not, chances are pretty good you have some data corruption in imitmidx or iminvloc.

 

[dgillz]

MAKNIGHT71,

Any update on this? I just received an identical report from another client.

I also wrote a crystal report that looks at the IMINVTRX records that should have updated inventory, and compares the qty to the old qty to make sure they are different. This may help you determine if this is happening on any other parts than the one you are aware of.

Let me know an email address and I'll send the report your way.

As an aside, 7.6.200GR is not a good thing. Upgrade to 7.6.200.5.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[ESTAGroup]

This may seem like a strange question but did you just beging adding records to the Item/Vendor Master when you started seeing this problem?