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 LX & BPCS Tip of the Week: LX 8.4 Database

Anthony Etzel 0 57725 Article rating: 5.0

The database in LX 8.4 has undergone a significant change from previous versions. The database has been created using SQL DDL language instead of the old DDS language. The newer format allows for LX to take better advantage of advances in IBM database technologies as they move forward. Additionally, LX will be better able to make changes to tables (aka files) in the future without causing very large MR explosions to replace all programs that use a specific table. To ease the impact of this significant change, the LX tables (aka physical files) have new names that are the same as the previous version file names but with a “P” at the end, for example IIM is now IIMP. The old file names now belong to SQL views that looks just like the tables. This change made it easier to upgrade all the LX programs without changing every reference to every file. Many of the logical files remain although some have been replaced by SQL indexes to improve performance.

Crossroads RMC is Proud to Announce Product Certification for Baan IV to Avalara!

Kathy Barthelt 0 40603 Article rating: 5.0

Crossroads RMC is pleased to announce that our Baan IV integration to AvaTax has officially been certified by Avalara! This means that all Baan IV, Baan V and Infor LN customers now have an automated solution for sales and use tax!

AvaTax provides sales and use tax calculations in real time including rate determination, returning filing, remittance and exemption certificate management. 


Want to learn more? Please contact Kathy Barthelt for more details

1st Infor LN 10.7 Implementation for Crossroads RMC!

Kathy Barthelt 0 31920 Article rating: 5.0

We are proud to announce our first Infor LN 10.7 implementation in partnership with Infor Consulting Services for LOOP, Inc. (Louisiana Offshore Oil Port Services). As part of this project, Crossroads RMC will be providing Finance and Data Migration as well as Infor OS / Ming.le consulting services.

Learn More about Crossroads RMC Consulting Services and our knowledgeable Consultants!

Infor LN & Baan Tip of the Week: Credit Checks for Business Partners

Kathy Barthelt 0 75207 Article rating: 5.0

Did you know that you have several options for credit checks for your business partners?

Action-several options are available:

  • Always Hold (Credit)—the order will always be held until released
  • Never Hold (Credit)-the order will never be held
  • Check Credit—a credit check is performed at time of sales order entry, release to invoicing or at confirm shipment.  When this status is used, the check can be performed at one or all three steps.  The steps are only visible with this status.
  • Always Hold (Overdue Invoices)—the order will be held for overdue invoices until released.

Link the credit rating to the invoice to a business partner in the credit control session. You may also enter a credit limit. A credit limit of zero means unlimited credit.

The Security Model in IDF

Anthony Etzel 0 32803 Article rating: 5.0

By applying security to an object, you can control which users can view the object and which users can create, change, delete or copy the object.

Basic object security allows you to control who can display or maintain an object. Advanced object security allows you to control selectively who can create, change, delete, or copy an object.

In the basic model, all of the maintenance activities are permitted to those users who are authorized to maintain the object. Use the basic security model if you want a user who can change an object to also be able to create or delete the object. Use the advanced security model if you need to restrict some users to changing the object but not creating or deleting the object.

Upgrading from BPCS 6.1 to LX 8.3

Anthony Etzel 0 39485 Article rating: 5.0

It's always great to hear nice words from our customers!

"Our upgrade from BPCS 6.1 to LX 8.3 was greatly aided by Crossroads RMC. Their extensive knowledge of the financial system was a saving grace for us since we had a system that was set up over 15 years ago by people no longer in the company. The patience and professionalism of Hugh Carty made the transition much less complicated and frustrating. There is no doubt in my mind that it would have taken a much longer period and a substantially more painful path if it was not for Crossroads RMC bending over backward to accommodate our processes and time constraints.

Crossroads RMC was also able to help us with AS400 technical training, MRP production system design, and pricing using Promotions and Deals. This large swath of knowledge was very helpful in management discussions. Thanks to the Crossroads RMC team and in particular Hugh Carty, Yupo was able to bring this implementation under budget and on time."

Tim Knight — IS Manager, Yupo Corporation, USA

Learn More: Crossroads RMC Consulting Services

Infor LX & BPCS Tip of the Week: Partial Search in Item Description List

Anthony Etzel 0 57344 Article rating: 5.0

Previously, if a user performed a partial search for an item by using a double byte language, no matches were found. Regardless of whether the MLS module is used, this enhancement allows a user to use a double byte language to perform partial or full item description searches. This enhancement resolves an issue with partial searches on screens where the Item Master Lookup (WINIIM) screen is used, such as Material Status Inquiry, INV300D-01, Item Master Selection INV100D1-01, Facility Planning Selection, MRP140D1-01, and Purchasing Inquiry, PUR300D1).

The user selects the F4 prompt from these screens to open the Item Description List. In the prompt window, the user specifies option 10 to perform a partial or full search on an item description.

First6667686971737475Last

Tips:  LX | BPCS | M3

New IDF Inquiries 

Infor LX has a long history of providing IDF inquiries over most critical business areas, but there are still some areas that lack this capability.
The following IDF inquiries are now available in 8.4.2:

  • Customer Quote
  • Customer Quote Line
  • RMA (Return Material Authorization)
  • RMA Line

Benefits

  • Ability to sort, subset, filter, and view information in a modern and intuitive way
  • Point and click navigation to related information – 360 views
    • Exceptional personalization and extensibility capabilities

New IDF Inquiries 

Infor LX has a long history of providing IDF inquiries over most critical business areas, but there are still some areas that lack this capability.
The following IDF inquiries are now available in 8.4.2:

  • Customer Quote
  • Customer Quote Line
  • RMA (Return Material Authorization)
  • RMA Line

Benefits

  • Ability to sort, subset, filter, and view information in a modern and intuitive way
  • Point and click navigation to related information – 360 views
    • Exceptional personalization and extensibility capabilities
Last

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE Tip: Remap Posted Integration Transactions (tfgld4282m100)

Use this session to remap Posted transactions that were mapped incorrectly.

To remap integration transactions successfully, several conditions must be fulfilled. For details, refer to To remap integration transactions.

Enter the ranges of selection criteria for the integration transaction or range of integration transactions to be remapped. You can select the integration transactions of a range of business objects or of a specific business object.

You must select a specific integration document type or an integration document type group.

To evaluate the remapping before you perform the actual remapping, you can select the Simulate check box and the Error Report check box. After you solve the errors, you can run the session again and clear the Simulate check box.

After remapping the integration transactions, you can use the Post Integration Transactions (tfgld4282m000) session to create the postings in the General Ledger.

OPERATIONS Tip: Using Country of Origin for Purchase Orders

For purchase orders, information about the COO allows you to track the related import duties, tariffs, and compliance with sourcing requirements. You can maintain the COO of an item when creating an order or the release level of a purchase order.

When you create a purchase order line in the Purchase Order Lines (tdpur4101m000) session, the COO related details are defaulted based on the item-purchase data defined in the Items - Purchase (tdipu0101m000) session. To view this data, you can use the Country of Origin option from the References menu in the Purchase Order Lines (tdpur4101m000) session.

After the order line is released to Warehousing, an inbound line is created in the Inbound Order Lines (whinh2110m000) session with the COO information. A receipt line is created in the Warehouse Receipt Lines (whinh3512m100) session when the inbound order line is received. To view the actual COO for the item specified on the receipt line, you can use the Country of Origin option from the References menu in this session.

You can view the country of origin (COO) data for the inventory received in a warehouse in the Item - Country of Origin Inventory (tcitu6600m000) session based on the data specified in the header section such as, warehouse, item, and so on.

In the Inventory Tracking Receipt (tcitu2610m000) session, you can view the information related to the purchase order, inventory quantity, and actual COO of the item. You can use the Intrastat Transactions (tccom7171m000) session to view the COO that is reported for an order line and is used for the Intrastat declaration.

TECHNOLOGY Tip: Impact of Configuration Changes on Audit Trails:

Impact of Configuration Changes on Audit Trails

The impact of changes in the audit settings varies depending on the specific circumstances. The issues typically arise when changes made to audit settings are implemented at runtime without requiring all users to exit the system (LN). As a result, some users may continue to generate audit trails using the old configuration, while those who log in after the changes take effect will create audit trails based on the new configuration.

Changes in User Profiles

Below is a summary table that illustrates the effects of these changes for a specific table within a company:

Change Description Impact
Add a table Users that still use the old settings do not audit some transactions.
Remove a table Some transactions that must not be audited with the new settings are still audited by users that use the old settings.
Change the audit type for a table or field Some transactions are audited according to the old settings, and other transactions are audited according to the new settings.
Add or remove a field After you audit transactions in the table with the new settings, users that use the old settings can no longer perform transactions on this table. Therefore, users with the old settings can be forced to restart LN.

Note on Changes in Field-Specific Auditing:
When you toggle field-specific auditing on or off for a table, which alters the number of fields being audited, the effect is analogous to adding or removing a field. However, not every modification to the audit settings impacts the runtime settings. Converting the new settings to runtime might result in no net change for the entire configuration if the overall effect of the adjustments neutralizes each other.

Previous Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: Impact of Configuration Changes on Audit Trails
Next Article Infor LN & Baan Tips & Tricks for EXECUTIVES
Print
36273 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories