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: Saving Space in Your General Ledger

Kathy Barthelt 0 64062 Article rating: 5.0

Compressing Integration Transactions

One way to save space in your general ledger is to compress integration transactions. The transactions are combined into one ledger account number. However, the detail is still available in the integration transactions sessions.

The compression is seen after the transactions are finalized. 

Compression is established in the mapping scheme by checking the box under the columns “Compression of Debit/Credit Transactions". This can only be done in a mapping scheme that is not activated. 

BPCS/LX Tip: Backup and Save options

Anthony Etzel 0 48868 Article rating: No rating

Users are no longer limited to backing up or saving files to a tape or diskette.They can now use a Save File (SAVF) to save data and objects. LX programs that perform saves and/or backups were modernized to add a new SAVF option.  

There were numerous places in LX where users are prompted to save a file or library. These screens have options for tape or diskette. Diskette refers to the old 8” diskettes used on System/38. These devices are outdated and virtually obsolete. The current means of saving objects on the IBM i, is through the use of a Save File (SAVF). This compresses the data into a single object that can be saved and is easily transferred between systems.

These objects were modified and/or created for this enhancement:

  • Backup Simulation (FOR630C, FOR630D, FOR630FM, FOR640HT, and FOR630HT)
  • Month End Close (INV903D, INV903FM, INV901C, and INV903HT)
  • Purge YTH/Restore Archived Lots (INV912C, INV912D, INV912DHT, and INV912FM)
  • Purge and Save ITH records (INV932C, INV932D, INV932FM, and INV932HT)
  • Labor Ticket Save (SFC905D, SFC905FM, SFC901C, and SFC905HT)
  • Backup Infor LX Files (SYS700C, SYS700D, SYS700FM, and SYS700HT)
  • Backup Infor LX Programs (SYS710C, SYS710D, SYS710FM, and SYS710HT)
  • Backup Infor LX Source (SYS740C, SYS740D, SYS740FM, and SYS740HT)
  • Save File Name Selection (SYS912D, SYS912FM, and SYS912HT)


Benefit

Use the Backup Simulation to copy a simulation file to a SAVF or tape. Users may want to do this to transfer simulation data from one system to another, from site to site, or to save the data before permanently deleting it from the system.

Navistar goes global with Crossroads RMC!

Kathy Barthelt 0 25032 Article rating: 4.7

Navistar, a leading manufacturer of commercial trucks, buses, defense vehicles, and engines, has selected Crossroads RMC’s data collection middleware to use for their global data collection solution. Implementation began in late 2018 with Navistar’s Illinois facility and will be completed in all other divisions by the end of 2019.

Don’t Let Malware Destroy Your ERP System!

Crossroads RMC 0 23169 Article rating: 5.0

We just got a report that another one of our customers has been affected by malware. In this case it wiped out their ERP server. We are working with them to restore it an get everything up and running again. It is highly likely that this got into their network by an email attachment. This seemed like a good opportunity to remind everyone to be extremely careful with email attachments. Even if it appears to be from someone that you know, email “From” addresses can be forged.

Best practice is to save the attachment to a folder, and run a virus scan before opening or viewing the file.

Baan/LN Tip: Credit Control Parameters (ACR Parameters)

Kathy Barthelt 0 67360 Article rating: 5.0

In the Credit Control Parameters, you can indicate if the same letter will be sent for reminding and action taken if amounts are zero or negative. The reminder letters work in conjunction with overdue sales invoices and the “Reminder Diary Margin.” When an invoice has passed its due date plus a certain margin of days, LN generates a reminder advice for the invoice. 

Crossroads Welcomes Ridewell Corporation – MES for Infor LX

Anthony Etzel 0 25182 Article rating: 5.0

Crossroads RMC welcomes Ridewell Corporation as our newest client having selected Crossroads MES (Manufacturing Execution System) for their shop floor automation with integration to Infor LX. 

Ridewell engineers and manufactures air-ride, rubber-ride, steel spring and mechanical suspension systems for the truck, trailer, RV and bus industries. The company has served the transportation industry since 1967 and holds many active patents for exclusive features that provide for low maintenance and superior ride quality.

Ridewell’s objective was to eliminate shop floor paperwork and manual processes, obtain real time performance metrics, and achieve greater visibility over manufacturing operations. After carefully conducting their due diligence they selected Crossroads MES to address these challenges.

Crossroads Manufacturing Execution System connects your manufacturing plant to the rest of your enterprise by using touch screen PCs on the shop floor. Powered by IBM I Power Systems, Crossroads MES fills the gap that exists between your ERP system and your lean manufacturing initiatives by modernizing and transforming the ERP experience. It delivers paperless shop packets to your entire workforce, captures live manufacturing data, and then delivers real-time status to your Tablet or PC.

Key Features include:

  • Paperless Shop Floor                               
  • Labor and Machine Time
  • Production Reporting
  • Material Issue
  • Scrap Reporting
  • Scheduling
  • Capacity Load Balancing
  • Label Integration
  • Dashboard Analytics                    

Crossroads MES provides information that helps manufacturing decision makers understand how current conditions on the plant floor can be optimized to improve production output.

Crossroads RMC is proud to have Ridewell Corporation as a client and we look forward to working together to support their company growth and success.

BPCS/LX Tip of the Week: Shelf Life Days and Retest Days

Anthony Etzel 0 49100 Article rating: 5.0

This feature provides the ability to enter information in the shelf life days and retest days fields for non-QMS lot controlled items, even when the QMS product is installed. The purpose of this enhancement is to allow the user to enter information for non-QMS lot controlled items even when QMS is activated in Parameters Generation, SYS800D. In previous versions, when QMS was activated, the Shelf Life Days and Retest Days fields in Facility Planning Maintenance (MRP140) and Item Master Maintenance (INV100) were not maintainable for non-QMS lot controlled items. The user is now able to change non-QMS lot controlled items even when a QMS product is installed.

Baan & LN Integration News: Playing Telephone Can Get You In Trouble

Kathy Barthelt 0 32351 Article rating: 5.0

Somehow information must be relayed from one person to another, and the “connection” (as it turns out) is pretty manual, and error prone.

How about moving into the 21st century and eliminate the manual effort. How about automating your integrations? Learn About Crossroads RMC Consulting

We have tied Baan and Infor LN to:

  • Warranty systems
  • CRM systems
  • Web portals
  • Automated batch picking systems, and so much more!

Contact me to find out how we can automate the communication between your systems, so you don’t have to worry about what got lost in translation.

First6970717274767778Last

Tips:  LX | BPCS | M3

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

Last

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Interest Invoices

You can generate interest invoices for paid invoices, partially paid invoices, and unpaid invoices. In addition, after you generate and send an interest invoice, you can generate a subsequent interest invoice for the next period.

Setting up interest invoicing: You can set up interest invoicing in Accounts Receivable and the General Ledger.
To set up interest invoicing, use these sessions:

  • Invoice-to Business Partner (tccom4112s000)

For invoice-to business partners for which you want to raise interest invoices, select the Charge Interest check box. If this checkbox is selected, you can select the Interest Rate Code. This interest rate code is assigned to the business partner. If you specify this value, the Interest Rate Code specified in the Financial Business Partner Groups (tfacr0110m000) session is ignored. The interest rate defined for this Interest Rate Code is used to calculate interest amount on reminder letters and interest invoices.

  • Mapping Scheme (tfgld4573m000)

Use this session to define the mapping of the Interest Invoice/Revenues Analysis integration document type.

  • Interest Percentages (tfacr5102m000)

Use this session to define the interest percentages for each financial business-partner group, and for different periods of days. 

  • Interest Invoice Related Data (tfacr5101s000)

Use this session to define whether interest must be calculated on unpaid invoices, partly paid invoices, interest invoices, and/or fully paid invoices. You can also indicate that LN must take advance payments, unallocated payments, and credit notes into account for the generation of interest invoices.

  • Optionally, set conditions

Example: LN only generates an interest invoice advice entry if these conditions are met:

  • The total of all advice entries in one currency is higher than the allowed minimum amount of an interest invoice defined in the Minimum Amount for Interest Invoice field.
  • The invoice is overdue for a greater number of days than the number of days defined in the Minimum Days for Interest Invoice field.


OPERATIONS: Blocking or Unblocking Warehouses

You can block a warehouse for inbound procedures, outbound procedures, or both. For example, you can block inbound and outbound procedures for a warehouse if the warehouse must be closed temporarily for inspection.

You can impose these types of blockings:

  • Full block: Full block on warehousing procedures.

  • Interactive block: Override blocking allowed except blocks on confirm shipment or confirm receipt.

If you impose a full block on inbound procedures, the receipt and inbound inspection procedures are not allowed for the warehouse.

If you impose a full block on outbound procedures, the outbound, outbound inspection, and shipment procedures are not allowed for the warehouse.

An interactive block on inbound procedures blocks the confirm receipt step. For the other inbound steps (for goods already received), a warning is displayed and you are prompted to cancel the procedure or to continue.

These are the other inbound steps:

  • Generate and release inbound advice
  • Print and confirm storage lists
  • Put away stock

If you perform the outbound steps of a warehouse transfer and an interactive inbound block is imposed on the receiving warehouse, you are warned that the receiving warehouse is blocked.

An interactive block on outbound procedures blocks the confirm shipment step. For the remaining outbound and shipment steps, a warning is displayed and the user is prompted to cancel the procedure or to continue. Assembly, internal inventory movements and inventory adjustments are also allowed.


TECHNOLOGY: Archiving Concept

Companies are developing procedures for entering data into an ERP system and for archiving manuals, drawings, specs, and other hard-copy documents. However, in many cases there is no defined procedures to store historical electronic data. Archiving electronic data should be an integral part of your business processes. 

Generally, archiving is the process of moving historical data from the operational environment to a special archive environment. At home, you might move old bank statements from a closet in your study to a box in the attic. At the office, you might store old hard copies of purchase orders in a room far from your own desk. Just because you no longer need the information in your daily work, does not mean you can dispose of the information. In terms of electronic data in your ERP system, archiving means moving historic data from the operational company to a special archive company; in that way, the historic data will be out of your way and safely stored. To free up disk space on your machine after you have archived the data, you can also move the historic data to an external medium.

Archiving strategy:
Archiving historical data is an irreversible process. After data is moved to the archive company, the data can no longer be uploaded back into the operational company. Archiving has a direct effect on the accessibility and availability of information; therefore, you must define a robust archiving strategy which addresses three major topics: What, When, and Who.

Business requirements:
Your business requirements determine what must be stored and for how long. For example, if you have a warranty situation on your projects for five years, you might be required to keep your project open during this time, or you may keep the project in an archive company. Therefore, if the project must remain open, no project-related information, including orders and integration transactions, can be archived.

Every business manager must decide how long what data must be stored in an operational environment for quick access. Reporting requirements must also be listed.

Legal requirements:
In most countries, legal requirements apply to financial data. Tax authorities may require financial data to be stored for a minimum number of years. Additionally, in specific lines of business such as food and beverages or aerospace, governments maintain specific legal requirements, which impact your archiving strategy.

User requirements:
Users rely on historical information. For example, a customer service employee may need to have shipment information of up to one year in the past to accurately address customer queries. These requirements must also be taken into account when you define what can be archived.

Data to be archived or deleted:
Various parties related to your company use information based on logistical and financial transactions occurring in the past. Before you archive or delete this information, you must investigate the need for the information.

Your ERP system contains standard archiving sessions in all major modules. These sessions are designed to copy historical data to the archive company, and then delete the data from the operational company. 

You have three options in archiving sessions:

  1. Archiving and deleting: Data is transferred to the archive company and then deleted in the operational company.

  2. Deleting: Data is deleted in the operational company, but not archived.

  3. Archiving: Data is transferred to the archive company, but not deleted in the operational company.

Using option 1 or 2 makes archiving irreversible. If you archive only because you want to preview the results, the archiving can be done a number of times.

Usually, in archiving sessions, you can also specify:

  • The date up to which the data must be archived
  • If texts must also be archived
  • If texts that already exist in the archive company must be replaced

In addition to archiving logistical and financial data, you can archive general data. 

Delete sessions:
In all major modules, your ERP system contains delete sessions. These sessions only have delete functionality, no archive functionality. Consequently, they are used to clean up data in the operational company, not to transfer data to the archive company. For more information about these delete sessions, see the "Delete sessions" sections under the various modules. For example, see Delete sessions under Procurement.

After data is deleted using delete sessions, the data is no longer available in the operational company. However, parameter settings may determine whether history data is logged when you remove specific data. If required, you can archive the history using the appropriate archiving session.

When can data be archived?
Based on the answers to the previous question, you can now set a term of retaining relevant historical data in your operational environment, and a term of keeping data available in the archive environment.

Who can archive data?
Because archiving is an irreversible process, a certain risk is involved. For example, what if one of your employees starts up an archiving session by mistake? For this reason, you must determine who is authorized to archive and delete data, and then set up these authorizations with the functionality your ERP system offers.

Because no further changes must be made to archived data, access to the archive company must also be restricted to read-only authorization for most users.

Match strategy with ERP functionality: 
After you list all your requirements, the next step is to verify whether the standard ERP functionality is sufficient to facilitate your needs. Usually, your ERP system provides the functionality to meet all of your needs, but must not force you to compromise. We recommend that you avoid customizing your software, however, because we are looking for long-term operational-data storage, customizations must not be ruled out entirely. An example is the requirement to show, in one report, the data from the operational company and archive company. In the current version, this is not standard functionality, but this can be important to manage your business. What can be even more important, if you are using customized software, is the question of whether the archiving sessions have been included. Do you take into account the fields and tables you have customized? Customized tables and fields may have to be included when performing delete/archive runs.

Archiving plan:
After you define an archiving strategy that suits your requirements, you can define the archiving plan. In this plan, you translate the strategy to a more operational level.

Previous Article Infor LN & Baan Tips & Tricks for Finance: Problem Invoices
Next Article Infor LN & Baan Tips & Tricks for FINANCE: Interest Invoices
Print
29363 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories