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
36898 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

So, how many of you have updated the estimated cost of material and labor in your ERP system recently? ……Hmmmm. That’s what I thought.

Do you have any idea how accurate those numbers are? Are you making business decisions based on estimates that are completely inaccurate?

Consider switching from estimates to actuals. Furthermore, consider implementing an automated data collection system to make this easy. By collecting production and labor data real time, you can gain real insight into your business and you gain the ability to look at the profitability of individual jobs, projects and employees.

Optimize Your Manufacturing Today!

  1. Identify the key metrics. You need benchmark data so you know what realistic goals are, then track them and publish your performance along with a brief comment from time to time on how things are trending and how you compare with others, particularly your primary competitors. The best thing about this is that it is a system that develops a life of its own.
     
  2. Measure it. Automatically, people start to think about improving things. Then the fun part, stuff begins to improve by itself. Once in place, the system just hums along and the benefits appear, because it has motivated people to think about it, and figure out what they can do to make it better.
     
  3. Communicate it. Publish your numbers, and explain to people how what they do affects the company as a whole and its success/failure. Once they see the numbers, employees quite often start to modify their behavior for the better.

Optimize Your Manufacturing Today!

First8384858688909192Last

Theme picker

Tips: LN | Baan

Table Timestamp Definitions (ttadv4136m000)

Use this session to define timestamps for Infor LN tables. A timestamp is an additional column that stores the date and time of the last change for each record.

Timestamps are utilized by features like the extraction logic of CPM Enterprise Analytics. They enable CPM to perform incremental data extractions. For example, CPM can use the timestamps to extract records that were changed during the last week in a weekly extraction process.

To Create Timestamps...

Operations: To absorb the cost of cost items into specific projects, you'll need to handle them as customized items. However, cost items cannot directly be defined as customized items. Customized items must be physical, either manufactured or purchased.

That said, it's still possible to absorb cost items into a project, although indirectly. Here's how:

  1. Set Up Ledger Account: First, create a new ledger account in session tfgld0508m000 and set the type to "PCS" (project) in the operations management integrations. This account will be used for matching and approving purchase orders for cost items.

  2. Create and Activate Projects: Ensure that the necessary projects are created and set to active status.

  3. Purchasing Cost Items...

12345678910Last

Theme picker

Categories