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

Infor LN & Baan Tips & Tricks for OPERATIONS: Absorbing Cost Items into Projects

Kathy Barthelt 0 19909 Article rating: 5.0

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

Infor LN & Baan Tips & Tricks for FINANCE: Ledger Account Blocked Error

Kathy Barthelt 0 20824 Article rating: 5.0

When attempting to post to a ledger account, users may occasionally encounter an error indicating that the ledger account is blocked. To resolve this issue, navigate to the Chart of Accounts session (tfgld0508m000) and select the Miscellaneous tab. Once there, review the Blocking field. The available settings are:

  1. Free
  2. Blocked for manual input (integration transactions and other automatic transactions can be posted with this setting)
  3. Blocked for all purposes.

Infor News You Can Use: Infor Velocity Summit

October 1-2, 2024 (Las Vegas) & October 22-23, 2024 (Amsterdam)

Kathy Barthelt 0 10129 Article rating: 5.0

Antiquated technology has no place in today’s fast-moving world

To succeed, you need to move with velocity—this means not just moving fast, but with purpose and precision. Velocity-powered businesses measure success by the value created at every turn, not just by speed.

At the Infor Velocity Summit, we’ll unveil our latest innovations across generative AI, process intelligence, ESG, and more, distilled from our work with 60,000 customers and built for your industry, from the ground up.

Discover how possible happens>  https://www.infor.com/events/infor-velocity-summit

The Far-Reaching Impact of Disconnected Data: From Operations to the Executive Suite

Kathy Barthelt 0 11287 Article rating: 5.0

The Impact of Disconnected Data Across Your Organization

Operations Impact:

  • The warehouse manager’s spreadsheet tracking inventory levels and supplier shipments is disconnected from your ERP.
  • Dealer Portal Email orders need to be manually entered into the system.

Finance Impact:

  • Budgeting data is maintained in isolated spreadsheets, unlinked to quotes or sales figures in your ERP.
  • Open purchase orders and invoices need manual matching and approval, creating inefficiencies.

Technology Impact:

  • A large number of reports must be generated outside the ERP for teams to stay "up to date."
  • Valuable time is spent exporting ERP data for analysis in external data cubes.

Executive Impact:

  • Compiling an accurate picture of inventory and financial health is a struggle when data comes from multiple sources.
  • Lack of visibility to inventory shortages results in losing customers due to stockouts or delays.

Disconnected data refers to information stored separately from your main business system, such as your ERP. While this data holds value, the lack of integration creates challenges across your entire organization—often more than expected...

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Role-Based Security

George Moroses 0 16377 Article rating: 5.0

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.

Infor LX/BPCS Tips & Tricks for EXECUTIVES

George Moroses 0 14204 Article rating: 5.0

OPERATIONS:
Shelf Life Days and Retest Days
This feature provides the ability to enter information in the shelf life days and retest days fields for non-QMS lot controlled items, even when the QMS product is installed. The purpose of this enhancement is to allow the user to enter information for non-QMS lot controlled items even when QMS is activated in Parameters Generation, SYS800D.

In previous versions, when QMS was activated, the Shelf Life Days and Retest Days fields in Facility Planning Maintenance (MRP140) and Item Master Maintenance (INV100) were not maintainable for non-QMS lot controlled items.

FINANCE
Inventory Transaction Post to G/L by Cost Type
This enhancement provides a method to post material, labor, and overhead values on inventory postings to the general ledger to meet financial reporting requirements. The solution provides an optional further breakdown of cost by cost bucket using the new G/L Cost Type.

TECHNOLOGY:
Role-Based Security
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.

First678911131415Last

Tips:  LX | BPCS | M3

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

Last

Tips: LN | Baan

[EasyDNNnews:IfExists:Event]
[EasyDNNnews:IfExists:EventRegistration][EasyDNNnews:EventRegistration:RegisterButton][EasyDNNnews:EndIf:EventRegistration] [EasyDNNnews:IfExists:Payment][EasyDNNnews:Price][EasyDNNnews:EndIf:Payment] [EasyDNNnewsLocalizedText:Eventdate]: [EasyDNNnews:EventDate] [EasyDNNnewsLocalizedText:ExportEvent] [EasyDNNnews:IfExists:EventLocation]

[EasyDNNnewsLocalizedText:EventLocation]: [EasyDNNnews:EventLocation]

[EasyDNNnews:EndIf:EventLocation] [EasyDNNnews:IfExists:EventRegistration]
  • [EasyDNNnewsLocalizedText:NumberOfAttendants]: [EasyDNNnews:EventRegistration:NumberOfAttendants]
  • [EasyDNNnewsLocalizedText:MaxNumberOfTickets]: [EasyDNNnews:EventRegistration:MaxNumberOfTickets]
  • [EasyDNNnewsLocalizedText:NotUsedTickets]: [EasyDNNnews:EventRegistration:NotUsedTickets]
  • [EasyDNNnews:IfExists:Payment]
  • [EasyDNNnewsLocalizedText:Price]: [EasyDNNnews:Price]
  • [EasyDNNnews:EndIf:Payment]
[EasyDNNnews:EventRegistration:InfoMessage] [EasyDNNnews:EndIf:EventRegistration] [EasyDNNnews:IfExists:EventSignUp]

[EasyDNNnewsLocalizedText:AreYouGoing]

[EasyDNNnews:SignUpActionBar]
[EasyDNNnews:EndIf:EventSignUp]
[EasyDNNnews:EndIf:Event]
George Moroses
/ [EasyDNNnewsLocalizedText:Categories]: [EasyDNNnews:Categories]

Infor LX & BPCS Tip: PowerLink

PowerLink is a Windows-based client for end-users within the Infor Development Framework (IDF). PowerLink allows exports/imports from/to the ERP database, but how much do you really know about it? Here is some helpful information about PowerLink.​

Why does PowerLink sometimes fail to export all records?
There's not a finite amount of records that PowerLink can export. However, PowerLink export was never intended to handle large volumes of data. It was designed as a quick snapshot of a fairly small subset and a simple view of the user's PowerLink card. 

What is the maximum amount of data that can be exported?
The maximum number of records is only limited by the system resource like memory, etc. When the system runs out of resources, an OutOfMemory error should occur. In previous testings, we have exported +1 million records, although the size of records differs greatly between business objects, the total size of the data could be an issue. For larger volumes of data, customers should investigate other tools such as the iSeries Access "Data Transfer from iSeries Server" feature to download directly to Excel.

How do I know if the size of the data is an issue?
1. When exporting to an external file (text, HTML) then importing to Excel: You can easily check the output (text, HTML) to see if the intermediate output has all the records. This can be done by visual inspection or through the use of column totals. Simply compare between the output and what you see in PowerLink. If the exported file has all the records, then the problem is definitely Excel.
2. When exporting to clipboard, then copy/paste to Excel: There is a clipboard export size limit that is controlled through client preferences. Check the exported data in the clipboard, and see if it contains all the records or only partial records due to the size limitation set in client preferences. If limited, change the client preferences using Customize from the Main browser > Preferences > Miscellaneous tab > Limit Clipboard Export, and try the export again. If the clipboard has all the records the problem is in Excel, which we don't have jurisdiction over.

Suggestions for improving the export process. 

  1. Reduce the number of columns seen in the view. This will serve to reduce the data being exported and may increase the number of records that can be exported. 
     
  2. Reduce the complexity of the view. If the view has one column that lives on a related object, then it has to build SQL behind the scenes to get that related record. If all of the columns come from a single business object, then the processing will be significantly faster.
     
  3. Export to HTML, which can be opened directly by Excel, Access, and many other programs. This reduces the processing of the export formatting because PowerLink needs only to put begin and end tags around each data element. This will also preserve column alignment when Excel or other programs open the file.
     
  4. Unless you are exporting a fairly small volume of data, export to a file, not clipboard. Clipboard is held in memory until the entire view is read, and records are written to the file as they are retrieved.
     

 Also see KB 1357068 for more information about testing your view.

Print
49133 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories