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 Tip: Latest Porting Set – All Versions of Infor LN & Baan

Kathy Barthelt 0 48177 Article rating: 4.5

Are you on the latest porting set for your version of Infor LN or Baan? Check here to be sure:

VERSIONS: Infor LN, Infor Baan ERP 5.0c, Infor Baan IVc4

LAST MODIFIED ON:
13th Jan, 2021: Updated with 9.3i porting set, see KB 2176336 for this version. Available from LN CE release 2021.01
9th Oct, 2020: Updated with 9.3h porting set, see KB 2158949 for this version. Available from LN CE release 2020.10
9th July, 2020: Updated with 9.3g porting set, see KB 2142625 for this version. Available from LN CE release 2020.07
10th April, 2020....

Infor LX & BPCS Tip: Special Functions

George Moroses 0 26026 Article rating: 5.0

Use F14 from a menu to display the Special Functions screen, SYS50007.
From this pop-up screen you can access the following menu options:

  • JCDA Maintenance (SYS010D)
  • Display Output Queue
  • Display User Output
  • Send Messages
  • Display Messages
  • Display Job Log
  • Display Submitted Jobs
  • Display Remembered Keys
  • Menu Maintenance (SYS147)
  • Menu Print (SYS148)

This menu is only available from the character0based user interface. Infor Webtop users can access programs from the Quick Launch Menu.

Infor LN & Baan Materials Tips: Serialized and Lot Controlled Items

Kathy Barthelt 0 51585 Article rating: 5.0

Serial and Lot are additional characteristics/properties of Items that can be used to uniquely or collectively identify and track the item along with its Item code. Any Item can be made as Serialized and/or Lot controlled by choosing options "Serialized" and "Lot Controlled" in Items-General session under traceability section on the Details tab.

Further in Items-Warehousing data under the Identification tab, you can enable "Lot Tracking", "Lot in Inventory", "Serial Tracking" and "Serial in Inventory" which enables tracking of the Items. You can also define if the Item is "Serial/Lot not in inventory" then where you want to record the serial and lot details in the transactions like "Direct Delivery", "Receipt", "Transfer", "Register during As-Built, Service and Maintenance".

Below are some topics related to Serialized and Lot Controlled Items that will be useful...

How often are you counting your inventory? Are inaccurate counts affecting your ability to satisfy customer orders?

Infor LX | BPCS | Infor LN | Baan

Crossroads RMC 0 26796 Article rating: 5.0

Crossroads RMC Cycle Counting Applications provide:

  • Increased inventory accuracy.
  • The ability to review & approve count before direct update of LN/Baan tables.
  • The elimination of unnecessary re-orders of items with current inventory.
  • Greater ability to satisfy customer orders due to accurate inventory levels.
  • Direct labor cost savings – less staff required for count.
  • Increased productivity during count – counts reduced from weeks to a day.


Learn more about Cycle Counting for Infor LX & BPCS> 

Learn more about Cycle Counting for Infor LN & Baan> 

Infor LX & BPCS Materials Tip: Unique ID Generator / Unique Sequence Number

George Moroses 0 24582 Article rating: 5.0

Serial Number Unique ID Generator - The new Serial Number Unique ID Generator program (INV599B3) is used to generate a unique value that groups a set of serial numbers that should be treated as part of a single, comprehensive set of inventory transactions.

Assign Unique Sequence Number - The new Assign Unique Sequence Number program (SYS046B) is used by any program that posts an inventory transaction, that is, writes an...

Infor LN & Baan Tip: Can You Backflush An Item If Estimated Quantity is Zero?

Kathy Barthelt 0 50163 Article rating: 5.0

Yes, you can backflush an item with an estimated quantity = 0.00 if you haven't already backflushed the order. For example, you had an order with one component, you reported the quantity at the operation or order level and ran the backflush. Now you realize you need another component added. In this example, the order has already been backflushed, so if you were to add a second component, run backflushing, nothing would happen.

Backflushing is based on the 'quantity to backflush' in report operations or report orders complete. When the quantity is backflushed....

Increase Production by 10-20% - It's Simple!

Developed for Infor LX, BPCS, Infor LN, Baan & Infor M3

Crossroads RMC 0 27531 Article rating: 5.0

Studies show that merely displaying current production data to your workers via a dashboard increases production.

Improve the performance of your shop floor with Analytics Dashboard for Infor LX, BPCS, Infor LN, Baan, and Infor M3. It's simple to use and configure without programming knowledge. Display performance metrics in a grid, graph, chart, or any way that makes sense. learn more>

Infor LX & BPCS Manufacturing Tip: Production Register Listing

George Moroses 0 25750 Article rating: 5.0

Use the Production Register Listing screen, JIT610D1-01, to print an edit list of the labor tickets that you added or updated. Use this report to see the data to post before you actually perform the update. After you print the edit list, you can go back to Production Reporting (JIT600) and change the data before you post the batch. The program assigns a number to each production report that you posted in JIT600. You can use JIT600 to reference the production report that you want to update. Access: Specify Post on Production Reporting, JIT600D1-01.

First3536373840424344Last

Tips:  LX | BPCS | M3

This enhancement provides additional views, additional order and line details, improved navigation, and additional capabilities to the IDF Customer Order Inquiry cards and to customer order-related business objects such as Allocations, Customer Invoices, Inventory Transaction History, Promotions, Drop Shipments.

Enhanced Order views based on user roles such as customer service, warehouse/logistics, salesperson/commission, data analysis/management reporting

  • Improved sort, select and filter capabilities
  • Enhanced navigation, data organization and data display
  • Improved customer service access to all transactions throughout the entire customer order life cycle – from quote to order, related invoices, and any RMAs, return orders, related credit memos
  • Improved grouping of related fields
  • New cards to present additional order and order line details
  • Consolidation of cards and card details when appropriate
  • Enhanced Display and Maintain capabilities for drillback to related customer, ship-to, item, carrier, terms, and other master file details
  • Improved display of dates, times and applicable time zones when Region Code time zone support is implemented
  • Multi language Description, Name and Address fields displayed in user’s language, if defined, else in base language

This enhancement provides search capabilities on segment value description in Segment Value List window (WINGSVD).

Segment Value List (WINGSVD):

  • Converted to a standard subfile
  • New action code 10=Search

This makes it easier to locate segment values when defining segment values in Model Account Builder or Alias definition. In addition, WINGSVD has been redesigned as a subfile to enable WebTop grid capabilities.

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
47061 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories