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

BPCS/LX Tip of the Week: January - Time to Reflect and Plan

Anthony Etzel 0 45511 Article rating: No rating

Happy New Year! January is always a great time to reflect on the prior year – what went well, and what didn’t. It is also the obvious time to plan for the coming year – what do I want to accomplish and how can I best achieve my goals?

As the saying goes, “you can’t improve what you can’t measure”, so if you haven’t already, it is time to start putting processes, procedures and programs in place within your company to measure how well each department is doing against their objectives. Start to analyze your numbers and publish them internally. Where are you at currently? Where do you want to be? Seeing both sets of numbers pushes employees to hit those targets. Do this now, and you’ll be seeing positive results before you know it!  

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: January - Time to Reflect and Plan

Kathy Barthelt 0 73971 Article rating: No rating

Happy New Year! January is always a great time to reflect on the prior year – what went well, and what didn’t. It is also the obvious time to plan for the coming year – what do I want to accomplish and how can I best achieve my goals?

As the saying goes, “you can’t improve what you can’t measure”, so if you haven’t already, it is time to start putting processes, procedures and programs in place within your company to measure how well each department is doing against their objectives. Start to analyze your numbers and publish them internally. Where are you at currently? Where do you want to be? Seeing both sets of numbers pushes employees to hit those targets. Do this now, and you’ll be seeing positive results before you know it!  

Optimize Your Manufacturing Today!

Clack Corporation Goes Live on LN 10.4

Kathy Barthelt 0 26532 Article rating: 5.0

Clack Corporation, a leader in water treatment and plastic processing, has gone live with Infor LN 10.4. The Crossroads RMC team partnered with Clack in this very important technology initiative for the company. With Clack’s dominance in the industry, they were challenged to provide a top-notch ERP system that would keep up with their ever-expanding business needs. LN 10.4 provides the right tools, specifically geared towards industrial manufacturers such as Clack. Combined with the Crossroads RMC Shop Floor Data Collection Solution for LN, Clack is positioned very well for growth in the years ahead.

BPCS/LX Tip of the Week: Financial Year End – Have you done all you need to do?

Anthony Etzel 0 50148 Article rating: No rating

I'm reposting this checklist for things to consider in order to finish out the current year, and plan for next year…

  • Are your accounting records up to date so you can make a projection of how the current year will turn out?
  • Are all account reconciliations up to date to facilitate the closing of the books after year end?
  • Are there accounts receivable that should be reserved for or written off prior to the end of the year?
  • If your business carries inventory, do you need to plan a physical count as of the end of the year?
  • Has depreciation on your fixed assets been recorded during the year? Have you considered depreciation on current year additions?
  • Have all new asset purchases and bank loans been recorded on your books?
  • Are there any liabilities, for example, pending legal actions or warranty issues, which will need to be recorded prior to year end? 
  • Do you have a plan in place to properly “cut-off” revenue at year-end to properly match revenue and expense?
  • Will there be bonuses, profit sharing contributions or discretionary retirement plan contributions paid prior to the end of the year? How will these payments affect cash flow?
  • Will you be in compliance with your bank covenants at year end?
  • Do you need to make arrangements to receive statements as of the end of the year for cash value of life insurance, loan balances, etc.?

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: Financial Year End – Have you done all you need to do?

Kathy Barthelt 0 83810 Article rating: No rating

I'm reposting this checklist for things to consider in order to finish out the current year, and plan for next year…

  • Are your accounting records up to date so you can make a projection of how the current year will turn out?
  • Are all account reconciliations up to date to facilitate the closing of the books after year end?
  • Are there accounts receivable that should be reserved for or written off prior to the end of the year?
  • If your business carries inventory, do you need to plan a physical count as of the end of the year?
  • Has depreciation on your fixed assets been recorded during the year? Have you considered depreciation on current year additions?
  • Have all new asset purchases and bank loans been recorded on your books?
  • Are there any liabilities, for example, pending legal actions or warranty issues, which will need to be recorded prior to year end? 
  • Do you have a plan in place to properly “cut-off” revenue at year-end to properly match revenue and expense?
  • Will there be bonuses, profit sharing contributions or discretionary retirement plan contributions paid prior to the end of the year? How will these payments affect cash flow?
  • Will you be in compliance with your bank covenants at year end?
  • Do you need to make arrangements to receive statements as of the end of the year for cash value of life insurance, loan balances, etc.?

Optimize Your Manufacturing Today!

First95969798100102103104Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Using the Data Access Layer (DAL)

During an Exchange import, you can use all the functionality programmed into the Data Access Layer (DAL). If you use the DAL, Exchange carries out all the constraint checks, integrity checks, and side effects, for example, updates on other tables, that are programmed into the DAL. Database integrity is guaranteed automatically.

Using the DAL reduces the costs of interface development. You can use the DAL to import standard interfaces developed by Infor for partner products, as well as for specific interfaces built by customers, for example, to integrate LN with legacy systems. You can use the DAL in both single site and multisite environments.

The checks or additional actions specified in the DAL are carried out for each row that is imported. Database errors are logged in the same way for DAL and non-DAL import. DAL hook errors are also logged. You can specify whether the DAL property checks are or are not carried out.

If you specify the use of the DAL for a table relation for an import, the dal.new, dal.update, and dal.destroy functions are used instead of db.insert, db.update, and db.delete. You can choose to use DAL for particular tables and not for other tables, therefore, an import batch can contain both types of table relations simultaneously. The import through DAL works for both the import based on audit or indicators (inserts, updates, deletes), and the full import (inserts only).

DAL settings are run time aspects, which means you can change these aspects without having to regenerate the import program. DAL settings are also logged in the log table at batch line level, to enable you to find out what the DAL settings were when the import was run.

Important to realize is that an update through the DAL can result in a number of side effects. Actions performed by the DAL must not be carried out twice. For example, if the DAL updates the available to promise (ATP) quantity for an item when importing order data, the ATP quantity must not be updated in a condition script as well.

For this reason, you must not add any actions in condition scripts, or import additional data, that are already handled in the DAL.

Previous Article Infor LN & Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan Tips & Tricks for FINANCE: Set Up and Calculate Currency Differences
Print
1898 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories