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 44893 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 19657 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 11328 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 14418 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 21918 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....

RSS
First3839404143454647Last

Theme picker

Tips:  LX | BPCS | M3

TECHNOLOGY: Facility Security Ranges

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

FINANCE: Expiration Date for Quotes and RMAs

A Cancel-by-Date has been added to the Quote Header and RMA Header panels. This optional field can limit how long a quote or authorization to return items for credit is valid.  

For quotes, this enhancement provides an optional end date for the quote. For RMAs, it provides an optional date by which the customer must return the items to receive the credit listed on the RMA.

The Cancel-By-Date prints on the Order Acknowledgement and RMA Acknowledgement to inform the customer of this important limitation to the quote or return authorization. 

An Order Entry user cannot copy the quote to create a new order if the Cancel By Date has caused the quote to expire.

OPERATIONS: Default Split Salesperson to Customer Orders

Sales commissions are based on combinations of the Primary, Split, and Line-Level salesperson and the commission codes defined for the customer and item. You can now define the Split Salesperson in the same master files as the Primary Salesperson. While the Primary Salesperson is mandatory, the Split Salesperson is optional. It defaults during Order Create using the identical hierarchy as Primary Salesperson. Using Split Salesperson provides more flexibility in the calculation of sales commissions. The ability to define a default Split Salesperson improves the accuracy of sales commission qualification and calculation and reduces maintenance and adjustments necessitated by corrections.

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

12345678910Last

Theme picker

Tips: LN | Baan

Beyond the Four Walls—Achieving Upstream and Downstream Inventory Visibility

Infor LX | BPCS | Infor LN | Baan | Infor M3

When an enterprise has many suppliers, dealers/distributors, and customers spread out across the globe, it becomes important that it gains better visibility into inventory outside of its direct ownership and control, on both the supply and demand side. On the supply side, the company has outstanding POs and needs reliable estimates of when those will ship, as well as early indications whenever there will be delays in shipment. Once shipped, updates on the estimated time of arrival (ETA) are important, particularly when there are delays.

This external visibility is even more important during times of disruption. Early visibility into disruptions in supply or rapid changes in demand is key to providing the intelligence to drive agility. By responding earlier, faster, and with more accurate intelligence, a company has more options, makes smarter decisions, and avoids catastrophes.

How do you get that visibility? Here are some options…

• EDI—EDI can provide POs (EDI 850) for orders, ASNs (EDI 856) to communicate what has been shipped, Inventory Inquiry/Advice (EDI 846) with updates to on-hand inventory at various holding locations, including status (on hand, committed, on order, etc.), forecasts (e.g. EDI 830 planning schedule with release), shipping schedules, and other useful information about inventory in transit or at rest. EDI can be challenging for a smaller company to implement, especially without the right partner and solution. For this reason, not all suppliers or customers will necessarily have EDI. In those cases, an alternate approach, such as a portal, is needed to serve the remaining non-EDI trading partners.

• Supplier and Customer Portals—Portals provide a way for suppliers or customers who do not have EDI capabilities to update inventory, production, and order status. This requires some training and communications so that the trading partners use the system consistently, properly, and in a timely manner. (Portals to ERP for Infor LN & Baan Only)

• External Inventory Locations/Accounts—Some ERP systems allow supplier or customer stocking locations to be set up within the solution, so those locations look like another distribution center or plant, but with the inventory in those locations not being owned by the company. Personnel at the supplier or customer can then be given an account within the ERP system to update their inventory information. The account may provide additional functionality to the supplier or customer as well. If the trading partner actively uses the system to run a part of their operations, the data are more likely to be timely and accurate.

• API Integration—Trading partners may provide inventory data via an API in the ERP system.

• Planning Solutions—provides the ability to proactively manage the entire customer order backlog from top to bottom. It begins monitoring orders as soon as they’re booked and identifies and prioritizes those critical events that must happen every day so they can be managed and get orders produced and shipped on time. (OTTO - On Time Orders for Infor LX, BPCS & M3 Only)

Now more than ever, good inventory management, with accurate inventory data, is a core element of success for manufacturers and wholesale distributors. Having the right products, in the right place, at the right time, in the right quantities—and doing so at a low cost—drives profitability, cash flow, customer loyalty, and success for a company. This can be a difficult balancing act, especially when demand is volatile and supply disruptions occur. It can be achieved with the right inventory strategy, process disciplines, risk management, and capable systems in place. Excellence in inventory management, with the right systems, is key to enabling businesses to survive in challenging times and thrive in the market during good times.

Not sure where to start? Crossroads RMC consultants have expertise with all of the options listed above and can help you realize optimal inventory management, regardless of the size of your organization. 800.762.2077, solutions@crossroadsrmc.com, or ask us to contact you.

Print
24946 Rate this article:
5.0
Crossroads RMC

Crossroads RMCCrossroads RMC

Other posts by Crossroads RMC

Theme picker

Contact author

x

Categories