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: Analyzing Inventory Adjustments – 10.6

Want to understand the financial ramifications of inventory changes in LN? 

Analyze Inventory Adjustments in-LN 10.6

Several display and print sessions are available.  In these examples, the item number used is 020000.

1--Adjustment Orders Session

Double click on the order line to get to the Lines detail.

In the Lines session, double click on the item to see the details.
 

The “Adjustment” tab provides the quantities.

The “Price” tab provides the amounts.

Qty of 7 x $398.00 = $2,786.00

You can also get a printout of this session.  Highlight the line and select the print icon.

Select “All.”

Select “Adjustment Orders” and “OK” to continue.

Financial data is on page 2 of report

2--Inventory Integration Transactions

Enter the item, Entity Type From—warehouse, Entity Code From—EQ, and transaction date

The “From” tab displays the quantity and transaction amount

Highlight the line and select “References/Show Integration Transaction”

This will take you to the integration transaction

This session (inventory integration transactions) can also be printed—Highlight the line and select the print icon.

Print selection:

Previous Article Eliminate scrap for just $5-a-day
Next Article Crossroads RMC is proud to enter their 21st year in partnership with Paccar for Baan data collection
Print
36938 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Role-Based Security introduces Role type profiles and allows combining the use of Role profiles with the traditional LX User type security profile functionality. The new Role type profile can be defined to allow or deny access to All Products, Attention Key, Products, Programs, and Transaction Effects. Facility, Warehouse, and Company securities are still defined solely by the User profile settings and are not affected by the assignment of a Role. Where applicable, the Role authority is displayed alongside the User authority on the security profile maintenance screens making it easy to see where there are differences in authority between the User and the assigned Roles. 

When Users are assigned to Roles, security access in LX becomes a combination of authorities granted or denied by the Role, plus any User Exceptions. User Exceptions override authorities set by the Roles. A User can also be assigned to more than one Role.

12345678910Last

Theme picker

Tips: LN | Baan

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.

If functionality such as Commissions, Rebates, or Contracts are enabled in the parameters, LN checks this functionality during transactions, even if you did not specify anything for these concepts. Therefore, if you do not use certain functionality within LN, to improve performance, disable the corresponding parameter.

Optimize Your Manufacturing Today!

First7172737476787980Last

Theme picker

Categories