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: Inventory Transaction Post to G/L by Cost Type

Anthony Etzel 0 32869 Article rating: No rating

This enhancement provides a method to post material, labor and overhead values on inventory postings to the general ledger to meet financial reporting requirements. The solution provides an optional further breakdown of cost by cost bucket using the new G/L Cost Type.

The benefit this program provides is the ability to post detailed material, labor, and overhead values during inventory posting to the general ledger to meet financial reporting requirements. It also helps isolate import and transport cost elements required by some countries. Global companies with intercompany purchasing are able to isolate material costs so that it is eliminated at a consolidated level.

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: Inventory Tracking

Kathy Barthelt 0 70887 Article rating: No rating

Do you have a good handle on your inventory? Do you know when products need to be reordered and which are on their way? Are you able to find inventory easily within your facility, or are items getting misplaced and then unnecessarily reordered? Having a good inventory system in place will avoid unnecessary costs and save lots of time. We’ve been helping customers with this for over 20 years. Let us know if you need help getting started.

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: How is Your Productivity?

Kathy Barthelt 0 74943 Article rating: No rating

Are your employees not as productive as you’d like them to be? 
Are jobs not getting completed on schedule? 

Without actual data, making decisions about how efficient your operation is will be difficult. Start tracking actual time to complete each operation. Compare different production lines running the same job. Is one line running more efficiently? If so, start looking at why. Track downtime, setup, etc. Once you start really analyzing each piece of the puzzle, you can begin to uncover areas that are ripe for improvement.

Optimize Your Manufacturing Today!

BPCS/LX Tip of the Week: Understanding What Goes On – Out on the Factory Floor

Anthony Etzel 0 29084 Article rating: No rating

Ok… so you want to know the status of a specific shop order that was released two days ago.

What do you do?

It’s a sure bet that you have a manager, supervisor, or planner who can walk the floor and find the order at whatever work center it happens to be at. He/she can then answer “what operations have been completed and how many were completed?” All this requires leg work, and of course, a fair amount of time.

Now, if you have setup your BPCS master files properly, and you report transaction activity, you should be able to get those shop order statuses much faster using the SFC300 Shop Order Inquiry Screen.

At your fingertips you can see:

  • Release date & due date
  • How many hours remain in total and at each operation
  • The quantity required, what was finished and the remaining quantity
  • What components (materials) have been issued

Pretty basic information, right? Are you getting what you need to know? If not, then you may want to reexamine how your BPCS files are setup and what transactions along with their frequency are captured.

Optimize Your Manufacturing Today!

December Lunch & Learn Webinar for BPCS & LX!

ERP Data Analysis Made Easy!

Anthony Etzel 0 25410 Article rating: 5.0

Want answers to questions like…

  • Which lines of business are performing best, and what products are being sold?
  • Who are my top-performing sales reps, and what products are they selling?
  • What trends can I see based on my customers’ purchases?
  • What warehouse orders are planned over the next 6 months and do I have enough inventory on hand?

-----------------------------------------------------------------------------------------------------------------

Get all of this and more with easy drag and drop capability all without touching your ERP system or creating custom reports!


1:00 p.m. ET | 10:00 a.m. PT

Watch Video Now

Learn How to Create Views for:

  • Accounts Payable
  • Accounts Receivable
  • Labor
  • Material Costs
  • Production
  • Sales Orders
    And more!

BPCS/LX Tip of the Week: Role-Based Security

Anthony Etzel 0 36211 Article rating: No rating

Role-Based Security introduces role type profiles and allows combining the use of role profiles with the traditional LX user type security profile functionality. The new role type profile can be defined to allow or deny access to All Products, Attention Key, Programs, and Transaction Effects.

Facility, Warehouse, and Company securities are still defined solely by the user profile settings and are not affected by the assignment of a role. Where applicable, the role authority is displayed alongside the user authority on the security profile maintenance screens making it easy to see where there are differences in authority between the user and the assigned roles.

When users are assigned to roles, security access in LX becomes a combination of authorities granted or denied by the role plus any user exceptions. User exceptions override authorities set by the roles. A user can also be assigned to more than one role.

Optimize Your Manufacturing Today!

Baan/LN Tip of the Week: Strategies to Issue Materials – LN

Kathy Barthelt 0 75688 Article rating: No rating

LN offers you various levels of control for the issue of materials. You can specify a different method for each material.

Available methods to control the quantity of the issue:

  • Direct user control over the quantities to issue
  • Quantities determined by the allocations

Available methods to control the time of the issue. LN issues the material:

  • After a user gives a command
  • At the allocation date
  • Immediately when the production order is released

Special methods:

  • Backflushing
  • Floor stock

Optimize Your Manufacturing Today!

Flexfab Selects Crossroads RMC for Company Wide Implementation of Data Collection for Infor LN

Crossroads RMC 0 32287 Article rating: 5.0

Flexfab Horizons International, Inc, a global leader in the manufacture of high performance silicone and other advanced polimer products, has selected Crossroads RMC’s Data Collection Solution, RMC3, for their company wide solution for data collection. The initial implementation will take place in Q4 2017 at their location in Nottinghamshire, UK and will focus on improvements in warehouse management. Applications to be implemented include Receiving, Inspections/Approvals, Putaway, Stock Transfers and Stock Inquiry. Flexfab is already a long time user of RMClabel for all of their barcoding needs. This product is made to work seamlessly with all of Crossroads RMC's data collection applications, so the incorporation of this solution will also be part of this project. Implementation for Flexfab US will occur in early 2018.

First8384858688909192Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Currency Differences

When currency differences are posted, several parameters affect the way the entries in the General Ledger are created. This section explains the possible parameter settings:

  1. Ledger accounts by currency

  2. Writing off currency profits

  3. Fixed exchange rate

  4. Writing off currency differences for anticipated payments


1. Ledger accounts by currency
This parameter is recorded in the Finance Company Parameters (tfgld0503m000) session.

If the Ledger Accounts Currency Differences by Currency check box is selected, the (un)realized currency differences are posted to the ledger accounts defined in the Currency Difference Ledger Accounts by Currency (tfgld0119s000) session.

LN retrieves the related dimensions from these sessions:

  • General Ledger: Finance Company Parameters (tfgld0503m000)

  • Accounts Payable: Ledger Accounts by Business Partner Group (tfacp0111m000)

  • ACR: Ledger Accounts by Business Partner Group (tfacr0111m000)

If the Ledger Accounts Currency Differences by Currency check box is cleared, the currency differences are posted to:

  • General Ledger: the ledger accounts specified in the Finance Company Parameters (tfgld0503m000) session.

  • Accounts Payable/ Accounts Receivable: the ledger accounts recorded for the business partner group.


2. Writing off currency profits
This parameter is defined in one of these sessions:

  • ACP Parameters (tfacp0100m000)

  • ACR Parameters (tfacr0100s000)

If the Currency Profits check box is selected, the unrealized currency profits are posted as well as the unrealized currency losses. Unrealized currency losses are always posted when writing off currency differences.

3. Fixed exchange rates
For each invoice, the rate determiner defines:

  • Which date is used to determine the exchange rate.

  • If currency differences are calculated.

  • For which (home) currencies the currency differences are calculated.

The Rate Determiner is set in the Sales Invoices (tfacr1110s000) session or the Purchase Invoice Entry (tfacp2600m000) session.

Unrealized currency differences are written off in one of these sessions:

  • Write Off Currency Differences (tfacp2240m000)

  • Write Off Currency Differences (tfacr2250m000)

4. Writing off currency differences for anticipated payments
This parameter is defined in one of these sessions:

  • ACP Parameters (tfacp0100m000)

  • ACR Parameters (tfacr0100s000)

If the Currency Difference Anticipated Payments check box is selected, invoices with anticipated payments or anticipated receipts are considered for writing off currency differences.

OPERATIONS: Pegging Material Supply Lines for Operation and Product Subcontracting

For project pegged production orders, operations can be subcontracted. The material delivered to the subcontractor can be project pegged or anonymous. The subassemblies that are sent and retrieved are always project pegged. Costing breaks can apply to direct the costs of the subcontracted operation to a specific project cost account. If (production material) costing breaks are used, a purchase order line's peg can differ from the peg on the material supply line.

For product subcontracting, the subcontracted purchase orders can include materials that inherit the project pegs, or can include anonymous materials. The pegged materials are stored in inventory and are shipped to the subcontractor with project pegged orders.

In case of a project pegged order, a peg distribution is linked to the Purchase Order Material Supply Line in the Purchase Peg Distribution (tdpur5100m000) session. For a specific purchase order line (detail) and material sequence, the material supply line's Order and Consumption quantities are distributed across the peg distribution lines for combinations of project/budget, project element, and/or project activity. The peg information in the Purchase Peg Distribution (tdpur5100m000) session includes the line number for the peg in the distribution, the peg (project, element, activity), and the material supply line quantity by peg. The peg distribution cannot be manually created and must always be generated using the parent.

For operation subcontracting, the purchase order line, the material supply line, and the linked peg distributions are generated by Job Shop Control and can only be updated by Job Shop Control.

For product subcontracting, the purchase order line, the material supply line, and the peg distributions are generated by Procurement. A material supply line's peg distribution can be updated only from the parent, that is the purchase order line, the purchase order line peg distribution, or the material supply line. If a purchase order line's distribution line is changed, and no quantities are received or consumed yet, the pegged fields on the linked material supply lines are synchronized to the updated distribution line in the Purchase Order Material Supply Lines (tdpur4116m000) session. However, if a different quantity distribution is applicable, the quantities of the material supply lines' distribution lines are redetermined in the Purchase Peg Distribution (tdpur5100m000) session.


TECHNOLOGY: Load Audit Tables for Profile (ttaud3220s000)

Use this session to load tables for an audit profile.

Usually this session is run from the Specific menu of the Audit Tables by Profile (ttaud3120m000) session. The selected profile in that session is displayed in the first line of the current session.

The result of loading the tables depends on the selection level you use in the current session. For each element on the lowest selection level, a line is created in the Audit Tables by Profile (ttaud3120m000) session. For example, if you select a package and a number of modules, a line is created for each module. Because you did not specify the tables, the All check box is selected.

Field Information

  • Profile: The audit profile for which the tables are loaded.
    Note: If you start the current session from the appropriate menu of the Audit Tables by Profile (ttaud3120m000), the profile displayed is the profile that is selected in that session.
  • Package: The package that contains the tables you want to load.
  • Module: The module that contains the tables you want to load.
  • Table: The tables you want to load.
  • Audit Type: The audit type that must be set for the tables that are loaded.
    Note: You can either select Always, or Changed. However, it is also possible to determine the audit type per field. This is the Not Applicable option in the Audit Tables by Profile (ttaud3120m000) session. If you want to set the audit type per field, you must change the audit type to Not Applicable after the tables are downloaded, and then specify the audit type per field in the Audit Fields by Table (ttaud3125m000) session.

Previous Article Infor LN & Baan Tips & Tricks for OPERATIONS: Subcontracting Overview
Next Article Infor LN & Baan Tips & Tricks for FINANCE: Currency Differences
Print
226 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories