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 LX & BPCS Tip of the Week: Journal Upload – EGLi

George Moroses 0 52231 Article rating: 5.0

EGLi users who maintain journal entries in a Microsoft Excel spreadsheet can use this utility to upload journal entries to EGLi. The Journal Upload installation program adds an Add-Ins tab to Microsoft Excel. This tab includes options to connect to the server where EGLi is installed and to open a spreadsheet template to use for manual journal entry. When the spreadsheet is complete, the Add-Ins tab is used to upload the spreadsheet.

To install Journal Upload:

  1.  The Power-Link Installation page has links to the Client installation programs and a link to download and install the Journal Upload utility. To access this page, use this link with your own values for system and NetLinkport: http://system:NetLinkport/Installs/ClientInstall/Install.html  where system is the server where IDF is installed and NetLinkport is the Net-Link port, typically 36001
     
  2. On the Power-Link Installation page, click the link provided to download and install EGLi Journal Upload.
     
  3. Follow the screen prompts to complete the installation on your PC.
     
  4. To verify the installation, open an Excel spreadsheet. Confirm that the Add-Ins tab is on the spreadsheet. 


See the Infor Enterprise General Ledger for System i Journal Upload Installation and Infor LX Configuration Guide.

Infor LN & Baan Tip: Open Transactions Check – LN 10.7

Kathy Barthelt 0 56641 Article rating: 5.0

When closing a project, users were informed about open transactions blocking the closure process. To proactively check on open transactions, the Show Open Transactions option has been introduced in the Project Status (tppdm6107s000) session. With this option, issues can be resolved before changing the status.

Infor LX & BPCS Tip of the Week: LX 8.4 Enhancement – Company Security for ACR510

George Moroses 0 17492 Article rating: 5.0

This enhancement provides LX Company Security to Invoice Maintenance, ACR510. Only users authorized to the invoice company can view or maintain invoices.

User must be authorized to ACR as a product or ACR510 as an individual program in Security Master Maintenance, SYS600. Additionally, ACR510-01, displays all records, but if the user tries to revise or display a transaction record for a company the user is not authorized to, this error message is displayed: “User is not authorized to the transaction company.”

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

George Moroses 0 20731 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 prevents 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 62187 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....

First4950515254565758Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Infor LN & Baan Tip: The ABC’s & 123’s of Serialized Items
Kathy Barthelt
/ Categories: Infor LN & Baan Tips

Infor LN & Baan Tip: The ABC’s & 123’s of Serialized Items

A serialized item is a physical occurrence of a standard item that is given a unique lifetime serial number. This enables tracking of the individual item throughout its lifetime, for example, through the design, production, testing, installation, and maintenance phases. A serialized item can consist of other serialized components.

In Service, a serialized item can be a customer-specific or owner-specific installation. Installation groups are a group of installations/serialized items such as photocopiers, computers, air conditioners, forklifts, lathe machines, and even aircraft.

A serialized item is identified by both the item code and serial number. You can set up the mask used to generate the serial numbers so the serial number includes some fields of the item data, such as the item group and the manufacturer.

In a multi-company structure, the companies can share the serialized item data. All the service departments in the various companies can refer to the same serialized items.

The serialized item can originate from a sales order or a project. The details of a serialized item indicate their origin, for example, by using specific sets of serial numbers for items that originate from sales orders and from projects. Serialized items can also originate from an as-built structure or directly from the production bill of material in Manufacturing.

In Service, serialized items can start their respective life cycles in As-Built mode or As-Maintained mode. Each serialized item, with or without its installation group, can be covered by a service contract or a warranty.

The serialized item status

Serialized items can be status controlled. Each serialized item can have the following status:

  • Startup - The serial number has been assigned, but the item is not yet included in a service order or contract. You can only change the status to Active.
  • Active - The serialized item is part of a service order or contract. You can only change the status to Revision.
  • Revision - You can only change the status to Active.


Serial numbers

A unique serial number is assigned to every manufactured item or purchased item. The serial number is assigned to track the item in its life cycle. You can define a dummy serial number for an item. The dummy serial number is a temporary number and can be used to monitor the item until a permanent number is assigned. For each serialized item, you can define an alternative serial number for customer reference. You can use the alternative serial number to search for items when you register calls, create service order activities, or register parts lines for a maintenance sales order.


Serialized item groups

You can group serialized items by serialized item groups. A serialized item group is a group of serialized items with similar features. You can define the serialized item groups that you need, for example, to categorize the skills required for the maintenance of the items, or as a basis for enquiries and reporting. For example, you can select service engineers on the basis of their skills for a specific serialized item group.


Serialized items in physical breakdown structures

Serialized items are the building blocks of physical breakdown structures. A physical breakdown structure is the relationship definition of a set of serialized items with their underlying parts and assemblies. Some serialized items, such as a photocopier, have a simple structure whereas other serialized items such as a ship or an aircraft have a complex structure.

A top serialized item occurs at the highest level in the physical breakdown structure, while the underlying structure consists of assemblies that are either effective or outdated. Use the Tree View option to display a graphic view of the structure.

Each serialized item in the breakdown can be linked to a functional element, with a common function across the entire structure, and can be used to group serialized items based on the functional importance.

Previous Article Infor LN & Baan: Customizing Shipping Labels for All Customers
Next Article Infor LN & Baan Tip: Outbound Order Lines
Print
23441 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories