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 52624 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 57710 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 17711 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 21510 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 63412 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....

First5253545557596061Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Manufacturing Tip: All About Routings

The planning data for the method of manufacturing is defined in Routing. A routing consists of operations, with each operation identifying the last to be carried out in a work center and/or on a certain machine defined for a specific site.

Routings can be as follows:

  • Standard Routing - A generic routing that can be attached to multiple items
  • Item specific - A routing that is applied to one item
  • Network routing - A routing containing sequentially ordered operations and parallel operations
  • Order quantity dependent routing - A routing that is defined for a specific quantity of items

You use the Routing module to record routings for manufactured items. You can define the following:

Work centers - A work center is where production activities are performed. Resources, such as people and machines, are linked to a work center. A work center is a group of resource units used as a functional planning unit. The operation rate code, which is linked to the work center, is used to calculate the standard cost of an item or the estimated and actual costs. The capacity load on a work center is used in the planning of production. Work centers can be part of enterprise units used for multi-company modeling purposes.

Machines - Machines are linked to work centers and are used to plan operations. The rate defined for a machine is used to calculate the actual machine costs. The capacity load on a machine is used for production planning.

Reference operations - Classified according to the nature of the work performed, reference operations are used to describe activities that take place in the job shop. Reference operations are linked to operation rate codes, which are used to calculate the standard cost of an item or the estimated and actual costs. Reference operations are used in production planning.

Operations - The operation data for standard and customized manufactured items is maintained with operations. Operation data is stored and maintained for standard items and customized items. A series of operations are performed to manufacture an item. The sequence of operations is defined as a routing in operations. Yield and scrap are defined per operation.

Norm times - The run time and production rate of an operation are determined using norm tables. After a matrix is defined for two physical characteristics, such as length and width you can maintain a set of standard operation times for the X-Y coordinates. When tasks and routings are defined, the run time and production rate can be calculated by using a norm table.

Skills - Certain skills may be mandatory to perform a specific operation. To ensure employees assigned to an operation possess the necessary knowledge, skills are linked to both employees and operations.

Previous Article Infor LN & Baan Tip: Deleting Records
Next Article Infor LN & Baan Finance Tip: What Can You Do in the Financial Statements Module?
Print
66193 Rate this article:
4.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories