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 LN & Baan Tips & Tricks for Finance: Problem Invoices

Kathy Barthelt 0 47239 Article rating: 5.0

You can use a problem code to indicate that a problem exists for a sales invoice. If the invoice-to business partner notifies you about a problem with the invoice and does not pay it, you can link a problem code to the invoice.

In the direct debits procedure, problem invoices are automatically discarded. For each problem code, you can set an option to prevent linked invoices from being selected on reminder letters.

Infor LN & Baan Tips & Tricks for Technology: Using audit files in the Exchange module

Kathy Barthelt 0 47279 Article rating: 5.0

The audit server logs all database actions that change the contents of a table in so-called audit files. The Exchange module can use these audit files, which are useful in a multisite environment because the databases on all sites must have identical data. These audit files can also be used in data conversions.

Only the updates in a specific period are exchanged, which leads to an improvement in performance. Specify this period in the Export Data (Non-Regular) (daxch0233m000) and Export Data (on a Regular Basis) (daxch0234m000) sessions. Changes such as insert, update, and delete are processed and written into the ASCII files. Actions such as drop, clear, and create tables are ignored.

Audit control data is added to the resulting ASCII file. This data consists of a batchline ID, transaction ID, sequence ID, and an indicator. The control data is added at the beginning of each line and is formatted like other data fields such as the enclosing and separator characters.

An update writes two lines to the ASCII file. One line contains the key fields and old values of the updated fields. The other line contains the new values of the key fields and updated fields, even if a key field does not change.

The batchline ID is used for recognition when processing the ASCII files. The transaction and sequence IDs are used to ensure that the transactions are replayed in the same order as on the exporting site. The indicator defines the type of action that is executed on the table. Use the letter I to insert; use the letter D to delete; use the letter U to update with old values; and use the letter N to update with new values.

Infor LN & Baan Tips & Tricks for Operations: Copying EBOMs - Which copying method should I use?

Kathy Barthelt 0 51161 Article rating: 5.0

To determine which copying method you must use, answer question 1 and follow the instructions.

Question 1: Is the source component a project item (that is, is a project defined in the first segment of the item code)?

  • If the answer is yes, proceed with question 3.
  • If the answer is no, proceed with question 2.


Question 2: Is the target component a project item?

  • If the answer is yes, select copy method NonProj Item to Proj Item.
  • If the answer is no, proceed with question 4.

Question 3: Is there a relationship with the same project?

  • If the answer is yes, select copy method EBOM to Production BOM Only.
  • If the answer is no, proceed with question 4.


Question 4: Is there a relationship with the target item?

  • If the answer is yes, proceed with question 5.
  • If the answer is no, select copy method No Copy Action.


Question 5: Does the item exist already?

  • If the answer is yes, select copy method EBOM to Production BOM Only.
  • If the answer is no, select copy method Copy E-Item to Item.

Infor LX / BPCS Tips & Tricks for Finance: Inventory Period Balance Freeze

George Moroses 0 18692 Article rating: 5.0

Users can now freeze period-end balances at the end of a fiscal period. You can now store the opening/ending on hand balance for each Inventory period at the Item (IIM), Warehouse/Item (IWI) and Lot/Location (ILI) levels. This information can then be used for inventory tracking and valuation purposes, as well as other ad hoc financial and audit reporting requirements. Infor LX clients can backdate inventory transactions into the immediate previously closed period, and thus update what was saved as the opening/ending balance throughout the current open period.

Infor LX / BPCS Tips & Tricks for Operations: Retain Lot Status on Shipped Resupply Orders

George Moroses 0 13820 Article rating: 5.0

When a lot is completely shipped on a customer order, the Lot Status is changed to Z. Since a resupply order must still be received in the To Warehouse to complete the transaction, do not update the lot status when the resupply order is shipped. If a lot is completely shipped on a resupply order, LX no longer updates the lot status to Z, because the shipped lot retains its current lot status, the additional steps, no additional steps are required to receive it in the To Warehouse.

Infor LX / BPCS Tips & Tricks for Technology: Reset Purchase Order In Use

George Moroses 0 14608 Article rating: 5.0

This feature resolves or resets a purchase order or requisition that is no longer being processed, but the system still indicates it is 'in use'. The user selects Purchase Order/Requisition in Use Maintenance, PUR940D, from the Purchasing Management Menu, PUR, located in the Special Processing sub-menu. The user then enters an order or requisition to remove the 'In Use' status.

First7891012141516Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

An ERP System Review is NOT a Report Card

It's a no-judgment-review - we promise!

report card C minusWe all remember our school days and the nervousness that we felt when it came time to get our grades. Even if we were doing well, we were still nervous. Sometimes we experienced that same nervousness when it came time for a performance review on our job. Nervousness…sometimes dread…knowing that our performance was not what we wanted it to be, or others expected it to be. 

Somehow I think the feelings that we felt in our past often find ways to creep into our present. I have seen this recently when I suggested an ERP system review to one of our customers. They immediately became flustered and thought about every possible problem that they knew existed within the software and how they were currently using it. I asked them to consider the purpose of the ERP system review.

An ERP Utilization Review will:

  • Document how your company is using your ERP system (or a particular aspect of the system) and to what extent the system meets the needs of the business.
  • Identify challenges encountered using the software.
  • Create opportunities for improving business processes and generating additional value.
  • Identify potential risks and areas that need improvement.


key hole to the futureSo, if the result of ERP system review is to establish a path forward for growth based on current status, then why doesn’t every company take advantage of it? I think for some, the answer lies in the feelings of nervousness and dread still stuck in the recesses of our brains.

An ERP system review or more specifically a utilization review is NOT a personal report card, or performance review showing how well a particular individual does his/hers/their job, nor is it an attack on the team that implemented the software. 

As they say, hindsight is 20/20. What we view now to be a less than ideal implementation methodology may have been absolutely appropriate at the time the software was originally deployed. The software has likely matured and the skillsets of the individuals responsible for the system have likely matured as well. In some cases, those resources are no longer with the company, leaving those that remain with no back story as to how and why implementation decisions were made.

Instead of viewing the ERP utilization review as a reason to find fault in previous decisions, think of it as discovering untapped potential – both of the ERP system and the people who use it. Viewing an ERP utilization review in this way puts a positive spin on it and allows us to challenge ourselves to identify opportunities for growth far greater than anything we imagined before. This means not only moving our businesses forward faster but also advancing the strength of the company as individuals and as a team.

What untapped potential lies within your company?

Consider a utilization review of your entire ERP system, or just a part of it like Finance, Technology, Materials Management, Order Processing, or Shop Floor Control. You just might be surprised at what greatness can be achieved… far greater than anyone could have imagined.  

Get a free phone consultation button

800.762.2077

Print
28928 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories