Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Kathy Barthelt
/ Categories: Infor LN & Baan Tips

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

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.

Previous Article Baan/LN Tip: Disabling Unused Functionality in LN
Next Article Crossroads is proud to work with Johnson Crushers International on their LN re-implementation to 10.6
Print
38415 Rate this article:
No rating
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

The Enterprise Item application in the Infor Development Framework for Infor LX supports display of all information relevant to an item. This includes numerous aspects of Inventory, including facility, warehouse, location, lot, and container data.

With the Enterprise Items application, you can customize the data displayed to include more or less data than is currently displayed using the standard Infor LX programs. You can access this information through a single point of entry, so there is no need to switch from one program to another to see all the data you require. This ability to customize will help streamline your decisions by allowing you to display information that is specific to your needs.

The various Enterprise Item application cards provide listings, maintenance type information, and current information that you could previously only access by running multiple standard Infor LX programs, such as Material Status Inquiry (INV300), Bill of Material Inquiry (BOM300), and Routing Inquiry (SFC100).

Optimize Your Manufacturing Today!

This enhancement to the Purchase Receipts screens; optionally shown with the quantity and weight fields populated with the open value on the purchase order. Previously the user had to manually enter the quantity received or, for a dynamic weight and measure items, the weight received for each line on the purchase order. Now the screens are populated with the open value and if the open value is the same as the value received, the user can simply accept the line.

The Receive All field on the PUR550D1-01 screen determines whether the receipt lines are populated with the open value. A system parameter controls the Receive All default value but the default value can be overridden. If the user specifies 1=Yes in the Receive All field then the PUR550D2-02 screen displays the open quantity or weight for each line. The user can accept the open value for each line. 

Optimize Your Manufacturing Today!

First7576777880828384Last

Theme picker

Tips: LN | Baan

Instead of sharing tables through logical linking, you can replicate table content between companies. This approach allows certain non-key attributes of a record to vary by company. For example, if you replicate bills of materials rather than sharing them, each company can associate a different warehouse with the same bill of material. This way, the bills of materials are consistent across companies, while the warehouses can differ.

Replication also enables selective availability of records in other companies. For instance, when replicating items, you might limit which items are available in a sales company based on their item group, only including end items. You can further refine replication to specific subsets, such as particular item groups.

Keep in mind that replication requires any referenced tables to be either replicated or shared as well.

12345678910Last

Theme picker

Categories