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

Baan/LN Tip of the Week: Warehouse Material Movement / Problems With the Inventory Structure Table (whinr150)

Kathy Barthelt 0 83193 Article rating: 5.0

This has come up as an issue during various stages of warehouse material movements – transfers, outbounds, shipments. We have seen it right up to 10.4. The inventory structure table (whinr150) becomes a problem. The error points to that table, but users are lost as to how to fix it.

In the session Units by Unit Set many companies let the field Storage default to Yes. If the UOM is not intended to be used in inventory then that setting should be No. 

If an item is purchased in UOM different from the inventory unit and the setting is Yes then LN adds a record in that UOM to the inventory structure table. It is that record that causes problem later.

The session has an option to change the value of the storage field. Specific > Convert Use for Storage. This option works both ways and will correct all inventory in the UOM range. 

Should a user receive an error that references inventory structure table then the solution is to check that session to see if an odd UOM exists in it. If so use the Convert Use for Storage to correct the problem.

Baan/LN Tip: Disabling Unused Functionality in LN

Kathy Barthelt 0 83151 Article rating: No rating

If functionality such as Commissions, Rebates, or Contracts are enabled in the parameters, LN checks this functionality during transactions, even if you did not specify anything for these concepts. Therefore, if you do not use certain functionality within LN, to improve performance, disable the corresponding parameter.

Optimize Your Manufacturing Today!

Crossroads RMC named as Avalara's Certified Integration Partner for Infor LX

Anthony Etzel 0 30399 Article rating: 5.0

Avalara Announces 41 Newly-Certified Integrations Into Business Application


December 20, 2018 05:00 AM Eastern Standard Time

SEATTLE--()--Avalara, Inc. (NYSE:AVLR), a leading provider of cloud-based tax compliance automation for businesses of all sizes, today announced the release of 41 newly-certified integrations with accounting, ERP, ecommerce, point-of-sale, mobile commerce, and CRM software applications.

Avalara has been a partner-centric company since its founding in 2004, with a keen focus on integrating with technology solutions already in use by existing and future customers. Avalara Certified integration partners have met criteria developed by Avalara to guarantee each integration’s performance and reliability. Certified integrations are built to ensure customers enjoy a fast, reliable, and easy process for embedding Avalara’s automated tax management into existing systems.

Additionally, these integrations enable customers of Avalara partner solutions to benefit from Avalara’s real-time calculation of applicable taxes, fees, and surcharges for billing line items. Avalara software reduces the tedium and complexity of determining taxes for millions of products and services across the U.S., Canada, Europe, and other international jurisdictions, giving customers more time to focus on driving their own business success.

The latest group of Avalara Certified integrations includes:

  • Infor LX (by Crossroads RMC) is an ERP solution used primarily by manufacturers.

Baan & LN Tip of the Week: Get Real!

Kathy Barthelt 0 83628 Article rating: No rating

You’ve got an ERP system, so everything should be real-time and everyone should have access to information in real-time, right? RIGHT?!

Why not? Why are there spreadsheets, and separate Access databases off to the side?

Data loses value over time, so why not give everyone up to date, accurate information all the time? Take a look at those silos of information and see how you can eliminate them. Your business will benefit greatly as a result.

Optimize Your Manufacturing Today!

BPCS & LX Tip of the Week: Get Real!

Anthony Etzel 0 57263 Article rating: No rating

You’ve got an ERP system, so everything should be real-time and everyone should have access to information in real-time, right? RIGHT?!

Why not? Why are there spreadsheets, and separate Access databases off to the side?

Data loses value over time, so why not give everyone up to date, accurate information all the time? Take a look at those silos of information and see how you can eliminate them. Your business will benefit greatly as a result.

Optimize Your Manufacturing Today!

Baan & LN Tip of the Week: Simplify & Save Money – Evaluate Your Production Lines

Kathy Barthelt 0 129635 Article rating: No rating

When is the last time you took a hard look at your production lines?

  • How are you moving product through the facility?
  • Do you have work instructions / drawings available where needed?
  • Do you have frequently used inventory available at the line?
  • Where are the bottlenecks?
  • Are your processes simplified?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

BPCS & LX Tip of the Week: Simplify & Save Money – Evaluate Your Production Lines

Anthony Etzel 0 55472 Article rating: No rating

When is the last time you took a hard look at your production lines?

  • How are you moving product through the facility?
  • Do you have work instructions / drawings available where needed?
  • Do you have frequently used inventory available at the line?
  • Where are the bottlenecks?
  • Are your processes simplified?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

BPCS/LX Tip of the Week: Make Your ERP Work FOR You - Streamline Your Processes

Anthony Etzel 0 54351 Article rating: No rating

Such lofty goals you had when you implemented your ERP system. It was going to be like pressing the “Easy Button”…  then it wasn’t.

What happened? In some cases, decisions were made to implement the system “just like we used to run our old system”. Great idea? Not so much. Your business changes, and your business software needs to change as well.

Are you using the ERP system, but everything seems cumbersome and takes more time than its worth? 

Ask yourself these questions:

  • Have you looked at streamlining your processes?
  • Can you automate a step or two and eliminate some manual keying?
  • Can you add barcoding to avoid keying in some information altogether?
  • How about automating the printing of some reports?

Now is the time to sit down and really review the steps required to complete the task and think out of the box a bit. Soon you can develop your own streamlined process to get the job done quickly and efficiently.

Optimize Your Manufacturing Today!

First8283848587899091Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

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

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 a second archiving environment, which must also be an exact copy of the live environment. Define the companies of the second archive environment as the archive companies of the companies of the first archive environment. If necessary, a third and more archiving environments can be set up. You must then archive the data from each archive company to its archive company in the second archiving environment, and so on.

When you archive the data, LN builds an array with all the companies of the group and the archive company linked to each company. If any of the companies in the group does not have an archive company, LN reports an error and aborts the archiving process.

Batches and batch lines are only archived and/or deleted if you perform archiving and deletion in the company in which they exist. This is always the source company. Any intercompany documents and related finalized transactions that belong to the batch are not archived and/or deleted until the target company is archived.

If the batch has been deleted from the live environment, such intercompany documents and transactions will then temporarily exist without a batch in the live environment until the target company’s transactions are archived. Therefore, it is recommended to archive all the companies of a group within a short time.

Finalization runs are also archived. A finalization run can only be deleted from the live environment if all the attached batches have also been deleted.

Financial documents are archived and/or deleted if you perform archiving and deletion in the company in which they exist. For each document, LN searches whether a related intercompany document exists.

If the document’s transaction type indicates that the document numbering does not have to be in a fixed sequence, the document is not deleted from the live environment, to avoid duplicate document numbers.

A finalized transaction is not deleted from the live environment if the fiscal year of the transaction does not equal the fiscal year of the batch and the fiscal year of the transaction cannot yet be archived. If the Archive option is selected, the related batch, batch line, and document are copied to the archive company and retained in the live environment.

If a transaction is still referenced by open sales orders or purchase orders, it is marked as Deleted but not actually deleted. The related batch, batch line, and document are copied to the archive company and retained in the live environment. They are deleted when the referenced open transactions are closed and archived, for example, when you run the Archive/Delete Fully Paid Purchase Invoices (tfacp2250m000) session

If the transaction’s ledger account is a matchable account, any related matching data is also archived.

During the archiving process, the originating company of the finalized transaction is replaced with the originating company’s archive company. In this way, the archive environment will not contain references to the live environment.

During archiving, intercompany document relations are also copied to the archive environment. In the archive environment, these relations are updated in such a way, that each document in the relation refers to the environment in which the document actually exists. In the live environment, the document relation is retained until all related finalized transactions are deleted. For invoice-related transactions, this only occurs during the removal of fully-paid invoices. The document relation is also updated in the live environment, in order to refer to the archived document if all related finalized transactions have been removed from the live environment.

After the normal archiving process, an additional archiving step is performed in which all transactions and documents in the live company that arise from intercompany postings, are archived. During this step, intercompany relations are archived and/or deleted as described earlier.

Batches, batch lines, and documents that have the Deleted status are deleted from the live environment, unless the document’s transaction type indicates that the document numbering does not have to be in a fixed sequence. Such documents are not deleted from the live environment, to avoid duplicate document numbers.

Previous Article Infor LN & Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan Tips & Tricks for OPERATIONS: Simulated Purchase Prices (ticpr1170m000)
Print
546 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories