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

In order to communicate effectively as a team, everyone needs to speak the same language and operate off the same playbook. If decisions are made based on the data or the view of data that individuals are maintaining through their own spreadsheets or other data silos, then communication is negatively impacted.

Manufacturers need to review large amounts of data every day, making it difficult to keep track of key metrics within your department.

That’s where Crossroads RMC’s Analytics Dashboard solution comes in. Our Analytics Dashboard was developed to make tasks easier by putting all of the key information in one convenient location so you can view all of your crucial data in real-time. 

With powerful dashboards, you can...

Did you know that the system stores a record of every inventory transaction and makes them available for inquiries and reports? Transaction history is available for immediate inquiry by item, or by item and location in the Material Status Inquiry program. The inventory transaction record holds data such as the quantity, date, reference number, cost/value, transaction type, scheduled date, and master reference number, lot numbers, and warehouse/location information.

First2829303133353637Last

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