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

Anthony Etzel
/ Categories: Infor LX & BPCS Tips

Infor LX & BPCS Tip of the Week: LX 8.4 Database

The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance.
Previous Article Crossroads RMC is Proud to Announce Product Certification for Baan IV to Avalara!
Next Article A/P Payment Update in LX 8.3.4
Print
30164 Rate this article:
5.0
Anthony Etzel

Anthony EtzelAnthony Etzel

Other posts by Anthony Etzel

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Previously, if a user performed a partial search for an item by using a double byte language, no matches were found. Regardless of whether the MLS module is used, this enhancement allows a user to use a double byte language to perform partial or full item description searches. This enhancement resolves an issue with partial searches on screens where the Item Master Lookup (WINIIM) screen is used, such as Material Status Inquiry, INV300D-01, Item Master Selection INV100D1-01, Facility Planning Selection, MRP140D1-01, and Purchasing Inquiry, PUR300D1).

The user selects the F4 prompt from these screens to open the Item Description List. In the prompt window, the user specifies option 10 to perform a partial or full search on an item description.

This enhancement allows users who currently perform outside operation processing in shop floor programs to manage the transfer of components used in the outside operations to the vendor’s designated warehouse.

This enhancement provides modified and new INV511D screens and adds new logic to allow the user to identify all shop orders that have components linked to outside operations or to identify all the components linked to an outside operation on a shop order. The shop orders can be filtered by either a date range or by a specific vendor.

Inventory Transfers for Outside Operations enhances the management of external operations by providing screens that simplify the selection of the shop orders or items to transfer to a vendor.

Transfers to the vendor warehouse are performed in the Inventory Transfers, INV511D, screens.

First6162636466686970Last

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