• Visit Us on Facebook
  • Visit Us on Twitter
  • Link with Us on LinkedIn
800.762.2077

Baan/LN Tip of the Week: Warehouse Material Movement / Problems With the Inventory Structure Table (whinr150)

Author: Kathy Barthelt/Monday, February 04, 2019/Categories: Baan & LN Tips

Rate this article:
No rating

This has come up as an issue during various stages of warehouse material movements – transfers, outbounds, shipments. We have seen it right up to 10.4. The inventory structure table (whinr150) becomes a problem. The error points to that table, but users are lost as to how to fix it.

In the session Units by Unit Set many companies let the field Storage default to Yes. If the UOM is not intended to be used in inventory then that setting should be No. 

If an item is purchased in UOM different from the inventory unit and the setting is Yes then LN adds a record in that UOM to the inventory structure table. It is that record that causes problem later.

The session has an option to change the value of the storage field. Specific > Convert Use for Storage. This option works both ways and will correct all inventory in the UOM range. 

Should a user receive an error that references inventory structure table then the solution is to check that session to see if an odd UOM exists in it. If so use the Convert Use for Storage to correct the problem.

Print

Number of views (87)/Comments (0)

Tags:
Kathy Barthelt

Kathy Barthelt

Other posts by Kathy Barthelt

Leave a comment

Name:
Email:
Comment:
CAPTCHA image
Enter the code shown above in the box below
Add comment