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

Is your team still manually entering UPS and FedEx information into your Baan or Infor LN system?

Kathy Barthelt 0 19 Article rating: 5.0

If so, those manual shipping steps are likely costing you time, money, and customer satisfaction:

❌ Re-entering shipping details into Baan or Infor LN

❌ Copy-pasting tracking numbers

❌ Delayed invoicing and frustrated customers

There’s a better way to manage your parcel shipping.

RMCship: Seamless UPS & FedEx Integration

RMCship is a powerful automation solution that fully integrates UPS WorldShip and FedEx Ship Manager directly with Baan IV, Baan V, and Infor LN.

We eliminate manual entry and streamline your entire workflow:
 

Before RMCship (Manual)

After RMCship (Automated)

Re-keying data into two systems      

✔️ Create cartons/pallets directly in ERP

Delayed tracking updates

✔️ Auto-send shipment data to UPS/FedEx

Manual tracking number entry

✔️ Instantly pull back tracking numbers, freight, and more 

Manual invoice updates

✔️ Auto-add shipping data to sales orders & invoices

The Results Are Clear:

Infor LN & Baan Tips & Tricks for OPERATIONS: Simulated Purchase Prices (ticpr1170m000)

Kathy Barthelt 0 112 Article rating: 5.0

Use this session to define simulated purchase prices for purchased items per site.

Field Information:

  • Cost Calculation Code - price calculation code
  • Item

The raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, and sold.

An item can also represent a set of items handled as one kit, or which exist in multiple product variants.

You can also define nonphysical items, which are not retained in inventory but can be used to post costs or to invoice services to customers. The examples of nonphysical items:

  • Cost items (for example, electricity)
  • Service items
  • Subcontracting services
  • List items (menus/options)
     
  • ​Site - The site for which the purchase price is simulated.
  • Purchase Currency - The currency of the simulated purchase price.
  • Simulated Price - Purchase price

The simulated purchase price and currency are recorded twice.

  • Simulated Price Multi Currency - The purchase price in multiple currencies.

The simulated purchase price and currency are recorded twice. The amount in this field is related to the price of the supplier.

  • Unit - Purchase price unit
  • Cost Component - The cost component that must be of the type Material Costs.

Note: The cost component specified in this field does not become part of the standard cost detail structure if it is part of the cost component scheme of the selected item. If calculations are performed with a calculation code not used for actualization (simulations only), the simulated purchase price is mapped to the cost component defined in the records for this session.

Infor LN & Baan Tips & Tricks for TECHNOLOGY & FINANCE: Archiving Finalized Transactions

Kathy Barthelt 0 88 Article rating: 5.0

TECHNOLOGY & FINANCE: Archiving Finalized Transactions

To support correct archiving in a multicompany structure, the following rules apply:

  • Each company must have its own archive company. Companies cannot share an archive company.
  • The structure of archive companies must be an exact copy of the live environment.
  • A company must keep the same archive company until the end of its lifetime. Once data has been archived, you cannot change the archive company.

If extra archiving capacity is required, it is recommended that you set up...

Infor LX/BPCS Tips & Tricks for FINANCE: Tax Code Table Window (WINZRTD)

George Moroses 0 65 Article rating: 5.0

Added total tax rate to accumulate the tax rate based on effective date for each tax code and added an action to display the Tax Rate Code Table window (WINZRCD). Tax Code Table subsets list of item tax codes when customer tax code is entered in Order Entry.

This enhancement provided the following new features:

Tax Code Table (WINZRTD)
Tax Rate Code Table (WINZRCD)
Order Entry (ORD700D9-06)
Purchase Order (PUR500-09 / PUR600-09)
Enhance Tax Code Table Window (WINZRTD)

READ MORE>

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Optimize PUR500 for WebTop Grid Performance

George Moroses 0 81 Article rating: 5.0

Improve subfile record loading to optimize for WebTop Grid performance.
Improve subfile loading in PUR500-07 to take advantage of WebTop Grid capabilities.

This enhancement allows the WebTop Grids allow users to personalize list-type screens such as PUR500-07 to display as many records as their presentation allows.  With WebTop Grids, the PUR500 user is no longer limited by the number of records that can be displayed in a traditional green screen subfile screen.

Infor LX/BPCS Tips & Tricks for OPERATIONS: Add Item Description to Inbound Delivery Lines Selection

George Moroses 0 71 Article rating: 5.0

Inbound Delivery Line Detail panels have been enhanced. Item Description is added to the Inbound Delivery Lines Selection screen, and the number of lines displayed on the screen has been increased.

The Item Description is displayed in the user’s language, if available, else in base language. In addition, the Item Description shown on the Inbound Delivery Lines PO Detail panel has been enabled for multi-language support, and is also displayed in the user’s language, if available.

This enhancement provides additional detail about the items appearing on an inbound delivery.

Users can now see additional detail about the items on an inbound delivery. The item description is displayed in the user’s language, if defined. The redesign of the Inbound Delivery Lines Selection panel also allows more delivery lines to be displayed to the user.

245678910Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

George Moroses

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

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories