Please Wait a Moment
X

Infor ERP Tips & News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Infor LN & Baan Tip of the Week: Limitations of Customer Defined Fields (CDFs)

Kathy Barthelt 0 965 Article rating: 5.0

Customer Defined fields are fields that can be added to tables, screens, reports and BODs. Validation and calculation logic can be defined around those fields. This gives you great added capability and flexibility… however, are you aware of the limitations of using CDFs?

  • You cannot define customer defined fields for tables within Tools (the tl and tt packages).
  • External integrations, such as Infor Integration, EDI, Office Integration, and SOA-based integration, do not support customer defined fields.
  • You can use customer defined fields within 4GL reports, if editing the 4GL report layouts is still supported in your environment or by using the report personalization features of Infor LN Report Designer. For external reporting, only Infor Reporting and Microsoft Reporting (SSRS) support customer defined fields.
  • Customer defined fields cannot store application data in multiple data languages.
  • There is no direct limitation on the number of CDFs in a table. The actual number of fields in a table and the total length of all fields may be limited by the RDBMS you use.
  • Only super users can run the Convert to Runtime Data Dictionary (ttadv5215m000) session to convert the customer defined fields and the related domains to the runtime data dictionary.

Note: The full functionality of customer defined fields is only available within Web UI and LN UI. Customer defined fields are not displayed in the classic Infor LN BW UI.

If you have questions or need assistance with the use of CDFs, or Baan/LN modifications in general, please contact us for assistance. We’d be happy to help.

800.762.2077 or kbarthelt@crossroadsrmc.com

Infor LX & BPCS Tip of the Week: Item Deletion Option in IDF Enterprise Items

George Moroses 0 952 Article rating: 5.0

Previously, users were unable to delete items in IDF Enterprise Items when they have inventory balances or the item is connected to ancillary records, such as sales history records. This feature added in LX 8.4 provides the ability to delete an item when sales history records are found but all sales history activity is zero.

When the user attempts to delete an item in IDF Enterprise Items that is tied to a sales history record, the panel displays a message that the item cannot be deleted. The user can then run the Delete Validation Report to determine which records are tied to this item that prevent the validation. If the item no longer has manufacturing activity but had old sales history, the item can be deleted.

Infor LN & Baan Tip of the Week: In Transit Inventory Report – LN 10.7

Kathy Barthelt 0 1524 Article rating: 5.0

A new In Transit Inventory report can be printed in the Print In Transit Inventory (whinr1410m300) session. The report provides an overview of company inventory that is on the move and not stored in a warehouse. This concerns only inventory that is transferred from one warehouse to another. Items that are shipped to, for example, customers or projects, or items that are issued to production lines or service departments are excluded.

The report shows item inventory quantities and values on warehouse transfer orders which are issued at the origin warehouse, but are not yet received in the destination warehouse. These open inter-warehouse transfer orders represent inventory that is loaded on trucks or other means of transport, or located at intermediate pooling points such as harbors and train stations.

The quantities and values are retrieved from the Item-Warehouse-Inventory Transactions and the Inventory Integration Transactions sessions.

In the Print In Transit Inventory (whinr1410m300) session, a range of warehouse valuation groups, warehouses, items, transaction dates, etc. can be specified. Additional print options are available that determine if only item quantities must be printed or if insight into both quantities and inventory value is required. Quantities and values can also be aggregated by site and destination or origin warehouse.

At Crossroads RMC, we pride ourselves with being in the race for the “long haul”.

Crossroads RMC 0 1604 Article rating: 5.0

24 x 7, we are here to help you keep on keeping on.

Our team of dedicated professionals has an outstanding track record of being able jump in and make a difference. We can help you build on past success, address current needs, and work in lockstep with you to ensure that you weather this storm and come out the other end ready to move forward.

The Crossroads team is able to provide on-demand resources in:

  • Manufacturing Planning
  • Warehousing
  • Finance
  • Distribution
  • Customization
  • Integration
  • Data Migration
  • Upgrades & Implementations

Our team is staffed to provide world class ERP consulting and 24x7 support services to keep your systems running and your staff operating at maximum productivity.

Our consultants are committed to your success and we look forward to working with you to get through this challenging time together.

Sincerely,

Crossroads RMC
800.762.2077

Infor LX & BPCS Tip of the Week: Expanded Amount Fields on the Period End Calculation Reports – LX 8.4

George Moroses 0 1192 Article rating: 5.0

The Print/Calculate FIFO/LIFO/Average Program (VAL250B) has been changed to use five decimals in calculating amount fields. This has been done to improve the precision on the Period End Calculation Reports.

The fields, reports or areas impacted include:

  • Report and Generate FIFO Values, VAL200D
  • Working Value FIFO Calculation Report, VAL250O1
  • Report and Generate Average Values, VAL 210D
  • Working Average Values Calculation, VAL250O1
  • Report and Generate LIFO Values, VAL220D
  • Working Values LIFO Calculation, VAL250O2

Infor LN & Baan Tip of the Week: New Inventory Aging Analysis Report – 10.7

Kathy Barthelt 0 1303 Article rating: 5.0

A new standard Inventory Aging report can be printed in the Perform Inventory Aging Analysis (whina1440m000) session. This report is mainly based on the physical incoming and outgoing inventory movements and transactions. The date of inventory consumption or issue is compared to the date of receipt. If inventory is not yet issued, a reference date is used for aging calculation.

The report includes this information:

  • Which inventory items are not frequently used or are obsolete.
  • How long items have been stored in a warehouse.
  • Inventory and transaction values. This facilitates the financial auditing process.

To use this new feature, an inventory aging analysis definition must be available in the Inventory Aging Analysis Definition (whina1140m000) session.

Infor LX & BPCS Tip of the Week: Order Entry Line Copy Feature – LX 8.4

George Moroses 0 1409 Article rating: 5.0

This enhancement provides the ability to copy order lines, quote lines, and RMA lines. During Order Entry, action 3=Copy is available to copy regular lines and special lines. The new line displays in the next available line number.  This enhancement reduces manual key entry and speeds up Order Entry. 

The programs or areas impacted include ORD700D2, Order Line Entry, Quote Line Entry and RMA Line Entry.

RSS
123578910Last

Theme picker

Tips:  LX / BPCS / M3

If you plan to use Infor WebTop, the WebTop version 4.7 or above is required when running LX 8.4. Also, acquire and install the latest WebTop 4.7 patches from Infor Xtreme prior to running LX WebTop. WebTop 4.7 can be applied to your existing environments before you install 8.4.0. If this is completed before installing LX 8.4 then the LX install will take care of much of the Webtop server configuration automatically, including installing the LX Webtop metadata, updating WEB_ENV, and including the Webtop Platform library in the INLIBL data area as part of the environment setup. If you choose to install WebTop after the LX 8.4 installation is completed, the “Infor LX 8.4 Webtop 4.7 Configuration Guide” will guide you through all the configuration steps to set up Webtop for your LX environment.

123578910Last

Theme picker

Tips: LN & Baan

Infor Operating Service (OS) is a technology platform that supports fully integrated, industry-specific solution suites with mobile-first design, a consumer-inspired user experience, and science-driven analytics. It leverages the convergence of information, analytics, cloud computing, mobility, and social business.

This platform includes these products:

•    Infor Ming.le
•    Infor ION CE
•    ION Messaging Service (IMS)
•    Infor Data Lake
•    Infor Document Management
•    Infor Localization Services Platform (LSP)
•    Infor Localization Services

Read OS overview>

123578910Last

Theme picker

Categories