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
36877 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 LX 8.4, an enhancement has been included to allow for the expanded Company fields to have the leading zero truncated.

To trim leading zeros, CEA515B is called during macro resolution to trim the leading zero based on the position in the Zero Trim file (GZT). The Zero Trim file contains all the company number fields currently defined in the CEA Cross Reference fie (GXM).

This enhancement provides year over year comparison in financial reports and eliminates the need to setup new companies in programs such as Alias Definition. Financial programs trim the leading zero on Company fields, such as Company 010, on subsystem transactions to process as Company 10 during CEA macro resolution. Clients who prefer to retain the Company value as 010 on financial reports can clear the GZT file.

First5657585961636465Last

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