Infor ERP Tips and Infor ERP News for Infor LX, BPCS, Infor ERP LX, Infor LN, Infor ERP LN, Baan, Infor M3, and Movex

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 54169 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 114992 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 19018 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 23215 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 135896 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....

First5859606163656667Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

George Moroses

What are the biggest struggles manufacturers face with regard to tax compliance?

  • Tracking thousands of SKU numbers that cross taxability rules or vary in taxability based on state
  • Getting the rates right and filing the reports correctly
  • Surviving an audit (which in this business is inevitable)
  • Keeping track of all the smaller jurisdictions and their special districts
  • Ensuring a seamless process that is audit-able
  • Figuring out what is taxable and what isn’t
  • Tracking use tax

As with other manufacturing processes, having a repeatable, consistent process with sales and use tax compliance means automation. Automating sales and use tax compliance with a solution that ensures that consistent, accurate process means a solution that delivers:

  • Accurate sales and use tax calculations for collections that take into account product taxability, location, rules and regulations.
  • An exemption certificate management process that enables digital collection and storage of exemption certificates as well as transaction association and timely renewals.
  • Flow-through returns processing that provides a liability worksheet for review for each return filed, empowering your company to have oversight and visibility to all your sales and use tax liabilities and remittance.
  • Best practices in managing your sales and use tax processes and easy access to all data in case of an audit.
  • Up-to-date sales and use tax rates and information.

Using an automated solution for sales and use tax compliance helps manufacturers and distributors stay up-to-date with the latest changes in sales and use tax information. Consistency, repeatability, and accuracy help to reduce audit risk and potential negative assessments. Critical features to look for in an automated solution:

  • Easy integration with your back-end financial applications and/or inventory management software.
  • Ecommerce integration capability.
  • Geospatial technology to ensure “to the rooftop” level accuracy for locations.
  • Accuracy and speed.
  • Accessibility of information—anywhere, anytime.

Contact Crossroads RMC to learn how the Avalara - AvaTax integration can benefit your company. 800.762.2077​

Print
32567 Rate this article:
5.0
George Moroses

George MorosesGeorge Moroses

Other posts by George Moroses

Contact author

x

Categories