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

A/P Payment Update in LX 8.3.4

Anthony Etzel 0 42460 Article rating: 5.0

A/P Payment Update in LX 8.3.4. ACP660B creates a file using a layout required by the bank; the file informs the bank to pay invoices. These conditions must be met to create the file:

  • FIM is an installed product in SYS821  ­
  • The user is authorized to FIM in SYS600 ­
  • The company is active in FIMCOMIT in SYS105  ­
  • The payment type is in BONPAYTP (SYS105)

Infor LX & BPCS Tip of the Week: LX 8.4 Database

Anthony Etzel 0 58110 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 40693 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 31969 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 75408 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 32832 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 39510 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

First6667686971737475Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

OPERATIONS: Update, Cancel or Remove Outbound Order Lines
When the originating order or order line of an outbound order line is canceled or changed, this affects the outbound order line and may affect the related outbound advice, shipments, or shipment lines.

For most order origins, warehousing order-type parameters determine whether these actions are allowed:

  • Update the outbound order line if the originating order is changed.
  • Cancel the originating order line and the outbound order line.
  • Delete the canceled outbound order line.

If updating is allowed, changes made to the originating order are updated to the outbound order line and the related outbound advice, and, if present, picking lists, are deleted.

If updating is not allowed, a message is displayed, and the input is blocked when you try to change the originating order line.

If canceling is allowed, the outbound order line is deleted or set to Canceled when the originating order line is canceled.

When a canceled outbound order line is deleted, if present, the related outbound advice and picking list are also deleted. Outbound order lines originating from manual order origins cannot be deleted when canceled.

To process an outbound order line that is not deleted but set to Canceled, the outbound order line must be set to Shipped. The status of the outbound order line determines whether all steps of the outbound and shipment procedures must be completed to process the outbound order line.

When a canceled outbound order line is set to Shipped, the shipped quantity is automatically set to 0. You can create a transfer order to return the not-shipped goods to inventory.

If canceling is not allowed, you cannot cancel the originating order line or the outbound order line. A message to that effect is displayed when you try to cancel the originating order line.

To prevent the goods from being shipped when canceling is not allowed, you must complete the outbound and shipment procedures. When confirming the shipment line, you must set the shipped quantities to 0 and create a transfer order to return the not-shipped goods to inventory.

FINANCE: Currency Differences Accounts
Currency differences can make the financial analysis and reconciliation more complex. These types of currency differences can occur:

  • Currency differences
    Currency result caused by fluctuations in the exchange rate, for example, if the rate differs between the invoice date and the payment date.

  • Exchange gain and loss
    Currency result caused by the use of different exchange rate types, for example, the Sales rate type and the Internal rate type, or if using the rate determiner you have changed the exchange rate for a transaction during the order handling procedure.

  • Translation gain and loss
    Currency result caused by the use of different currencies during the order handling procedure, for example, if the order currency or the payment currency differs from the invoice currency.

  • Destination gain and loss
    Currency result caused by different results when the transaction currency is converted to the various home currencies. Destination gain and loss can only occur in an independent currency system.

To support good reconciliation possibilities, currency differences and exchange gain and loss are posted to these accounts:

  • Exchange Gain and Loss
    For differences between related amounts (debit and credit postings) due to different exchange rate types or different currency rates.

  • Currency Translation
    For transactions in which the debit posting and the credit posting are made in different currencies.

  • Currency Differences contra account
    For currency differences on the invoice accrual account due to rate changes between the receipt date and the approval date of the invoice and calculated when you close a financial period.


TECHNOLOGY: Advantages of Data Replication
Instead of sharing tables through logical linking, you can replicate table content between companies. This approach allows certain non-key attributes of a record to vary by company. For example, if you replicate bills of materials rather than sharing them, each company can associate a different warehouse with the same bill of material. This way, the bills of materials are consistent across companies, while the warehouses can differ.

Replication also enables selective availability of records in other companies. For instance, when replicating items, you might limit which items are available in a sales company based on their item group, only including end items. You can further refine replication to specific subsets, such as particular item groups.

Keep in mind that replication requires any referenced tables to be either replicated or shared as well.

Previous Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: Advantages of Data Replication
Next Article Infor LN & Baan Tips & Tricks for FINANCE: Use of Electronic Bank Statements
Print
55940 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories