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: Getting the Most Out of the Shop Order Inquiry Program – Part 2

Anthony Etzel 0 64315 Article rating: No rating

Understanding: How many hours remain in total and at each operation?

Now let’s look at what information is being supplied from the shop floor.

It’s not uncommon for transaction reporting to be captured manually on the shop packet that was issued to the factory floor when the SO was released.

The big question is, is anything done with the data? Is it collected and keyed to a  spreadsheet and not shared, or is the transaction data keyed to SFC600? If it is being keyed, ask how often and by whom? Some companies use alternative methods to capture transaction data that do not require batch keying via a keyboard.

Not a lot of data is required to be keyed to SFC600 in order for the SO Inquiry to be useful. The data that should be reported for the transaction process is as follows:

  • The type of hours being reported – machine, run labor, setup labor
  • If reporting setup and run labor you want an employee clock number
  • The shop order and the operation that is being reported
  • Is the operation complete
  • How many good were produced at this operation
  • How many hours – the numbers of hours are critical. Do the employees estimate how many hours they worked, or do they track actual time started and stopped in order to calculate the actual number of hours.

Based on what is captured and how often will have an impact on the SO inquiry screen. Understanding the batch times as to when the transactions are keyed will provide you with the window as to the SO status at that point in time. Or, are they keyed as they happen in a near real time fashion so that you can have a more current view of the factory floor.

Baan/LN Tip of the Week: ERP Setup - Pros & Cons

Kathy Barthelt 0 52486 Article rating: No rating

You may have started your setup of your ERP system one way, and have discovered over time that maybe it no longer fits how you need to do business. Here are some pros/cons to consider for a Single Finance / Multi-Logistic setup. 

 Pros
All accounting functions are centralized into one company.  One balance sheet is generated – even though multiple logistics sites are involved.  Income statements can be generated by logistic company via use of a Dimension to represent the logistic company.

Allows logistical functions to be decentralized within one legal entity – if this is what is desired.

Logistics data not visible across companies – pro if you do not want users to see other company’s data.

 

Cons

Crossroads RMC Maintains Preferred Partner Status With Honeywell / Intermec for 2016

Crossroads RMC 0 33103 Article rating: No rating

Honeywell has renewed Crossroads RMC’s Silver Level status in their Performance Partner Program for 2016. This recognition provides Crossroads RMC with the authorization to resell Honeywell/Intermec mobile computing products at a substantial discount, thereby allowing Crossroads’ customers to take advantage of that discount as well. 

Crossroads works closely with the Honeywell /Intermec engineering group to provide the best hardware offerings at a good price point for manufacturers across North America.

BPCS/LX Tip of the Week: Getting the Most Out of the Shop Order Inquiry Program – Part 1

Anthony Etzel 0 61945 Article rating: 5.0

Understanding: How many hours remain in total and at each operation?

First let’s look at some key BPCS Master File data starting with the routing file.

How many routing steps (operations) are set up that reflect how the product is produced in the factory? If you take a short cut and set up only one operation for the entire process, then you will limit the information seen on the SO inquiry program. Set up the operation steps to reflect what you want to report back to from the factory floor.

Will each of the routing steps run in one work center, or in different work centers? To keep it simple you may want to set up work centers as departments. For example:

  • Assembly
  • Machine
  • Paint
  • Etc.

For each operation setup consider how you have set up the following:

  • Load Codes – for example a code 5 is used if reporting both setup time and run labor time. These codes are maintained in the work center file
  • Basis Code – typical codes are P for pieces per hour,  3 is used for hours per 1,000 pieces
  • Setup hours – if you set them up, you also want to report them
  • Run hours – Direct Labor
  • Machine hours

How you set up th

Baan/LN Tip of the Week: ERP Setup - Pros & Cons

Kathy Barthelt 0 60880 Article rating: No rating

You may have started your setup of your ERP system one way, and have discovered over time that maybe it no longer fits how you need to do business. Over the next few weeks, I’ll be providing some pros/cons to consider for different company setups.

Pros/Cons of Single Finance / Single Logistic Company Set-Up

Pros
Easy to implement and to maintain.
No risk of processing data for another company.
Data not visible across companies – pro if you do not want users to see other company’s data.
Cost Prices can be different for the same item in the different logistics companies.
Easy to add or remove companies when companies are bought or sold.
Accounting functions are all separate by company. – Pro if each finance company is managed separately.
 

 

Cons
Decentralized operations – purchasing, sales, manufacturing, planning, warehousing, etc.
User must go in and out of companies if there is a need to view or create transactions in more than one company.

It’s NOT All About the Money, Money, Money… Motivating Employees in the New Year!

Kathy Barthelt 0 39720 Article rating: 5.0

Have you ever thought about what really motivates your employees?

It’s not about the almighty dollar, you know. Ok, ok…..money doesn’t hurt, but money alone doesn’t keep most people in their jobs. You actually need to motivate your employees to keep them showing up, mentally, and physically. Employees that don’t feel motivated are probably underperforming, and that means you’re losing money.

Ask yourself these questions about your employees:

  • Are they happy…..YES….HAPPY! Do they enjoy coming to work every day?
  • Do they feel challenged, or do they feel demeaned?
  • Are they sinking, or are they swimming?
  • Do they have the right tools in their arsenal to battle the giants?
  • Where’s the reward?

Happiness - I’ve worked with manufacturers for almost 20 years now...

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

Anthony Etzel 0 63387 Article rating: No rating

Came across an article online from Lauber CFO’s, and thought I would share. Here is a checklist for things to consider in order to finish out the year and help you plan for 2016:

 

  • Are your accounting records up to date so that you can make a projection of how the current year will turn out?
  • Are all account reconciliations currently 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 f
First108109110111113115116117Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

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.

FINANCE: Set Up and Calculate Currency Differences

To set up and calculate currency differences for foreign currencies:

  • Use the Company Parameters (tfgld0503m000) session to specify the profit and loss ledger accounts, 12 profit and loss dimensions, and transaction type for a posting exchange rate differences that is calculated using the FIFO method. To specify this data, use the Currency Diff. FIFO tab. The reports printed from the Print Company Parameters (tfgld0404m000) session, include the Currency Differences FIFO fields.
  • Use the Calculate Currency Differences (tfgld5201m000) session to calculate the currency differences resulting from transactions posted on accounts for which the field Currency Analysis in the session Chart of Accounts (tfgld0508m000) is set to Required.

OPERATIONS: Subcontracting Overview

Companies can decide to involve a subcontractor and subcontract part of their activities. The subcontractor carries out the work and returns the products to your company.

In Infor LN, subcontracting is considered as purchasing labor from a third party. Therefore, if a manufacturer wants to subcontract work, he must generate a purchase order to start the subcontracting process. These are the types of subcontracting:

  • Subcontracting with material flow
    • Operation subcontracting: For operation subcontracting, a part of the production process (one or more operations) is subcontracted.
    • Item subcontracting: For item subcontracting, an item's entire production process is subcontracted. Therefore, it is always used with material flow support.
  • Subcontracting without material flow: The simplest form of subcontracting is to generate a subcontracting purchase order to record the operations outsourced to a subcontractor. The subcontracting purchase order only represents the administrative handling of the subcontracting process. When the subcontracted item is received back from the subcontractor, you must close the subcontracting purchase order, which initiates the production process.
  • Unplanned subcontracting: Unplanned subcontracting is applicable when you subcontract after generating a production order. For unplanned subcontracting, a purchase order is generated from the production order and the material supply lines are populated by Shop Floor Control.
  • Service subcontracting: For service subcontracting, work on an item to be maintained or repaired is subcontracted. This work entails the entire repair process, or only a part of it. Service subcontracting can be used with or without material flow support.

To start the subcontracting process, a purchase order is required.

Previous Article Infor LN & Baan Tips & Tricks for FINANCE: Moving calendar periods
Next Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: Using the Data Access Layer (DAL)
Print
480 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories