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 Tips & Tricks for FINANCE: Override Exchange Rate

George Moroses 0 3326 Article rating: 5.0

This feature uses different exchange rates in the user's inventory processes by using new macros in Post Inventory to G/L, INV920D. INV920 used macros limited by the Override Exchange Rate parameter set on the book in Book Definition, CEA105D3. If the Override Exchange rate parameter is set to No, the macro uses the Rate Type of the Book. If the Override Exchange parameter is set to Yes, the macro uses the Rate Type of the Order Company. This enhancement provides macros that use the Rate Type of the Order Company. This enhancement provides macros that use the Rate Type of the Warehouse Company, Order Company, or the Book regardless of the Override Exchange Rate parameter in the Book.

Infor LX/BPCS Tips & Tricks for TECHNOLOGY: Change SyncBillofMaterial BOD

George Moroses 0 2614 Article rating: 5.0

This enhancement provides the ability to enable setting facility-specific bill of material BOD's accounting entity from the facility's stocking warehouse's company. The bill of material BOD can be consistent with the bill of resources BOD which sets its accounting entity from the company associated with the facility's stocking warehouse.

Crossroads RMC Presents 4 Must-Attend Sessions at inPOWER 2024

September 23-26, 2024

George Moroses 0 2932 Article rating: 5.0

Crossroads RMC Presents 4 Must-Attend Sessions at inPOWER 2024
Empower Your Business with Innovation

September 23-26, 2024

As a Gold Sponsor, Crossroads RMC is thrilled to present four impactful LX Track sessions this year, designed to inspire and empower attendees to drive success within their organizations:

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Adding a Timestamp to LN Standard Tables

Kathy Barthelt 0 4796 Article rating: 5.0

Table Timestamp Definitions (ttadv4136m000)

Use this session to define timestamps for Infor LN tables. A timestamp is an additional column that stores the date and time of the last change for each record.

Timestamps are utilized by features like the extraction logic of CPM Enterprise Analytics. They enable CPM to perform incremental data extractions. For example, CPM can use the timestamps to extract records that were changed during the last week in a weekly extraction process.

To Create Timestamps...

Infor LN & Baan Tips & Tricks for OPERATIONS: Absorbing Cost Items into Projects

Kathy Barthelt 0 4956 Article rating: 5.0

Operations: To absorb the cost of cost items into specific projects, you'll need to handle them as customized items. However, cost items cannot directly be defined as customized items. Customized items must be physical, either manufactured or purchased.

That said, it's still possible to absorb cost items into a project, although indirectly. Here's how:

  1. Set Up Ledger Account: First, create a new ledger account in session tfgld0508m000 and set the type to "PCS" (project) in the operations management integrations. This account will be used for matching and approving purchase orders for cost items.

  2. Create and Activate Projects: Ensure that the necessary projects are created and set to active status.

  3. Purchasing Cost Items...

Infor LN & Baan Tips & Tricks for FINANCE: Ledger Account Blocked Error

Kathy Barthelt 0 4538 Article rating: 5.0

When attempting to post to a ledger account, users may occasionally encounter an error indicating that the ledger account is blocked. To resolve this issue, navigate to the Chart of Accounts session (tfgld0508m000) and select the Miscellaneous tab. Once there, review the Blocking field. The available settings are:

  1. Free
  2. Blocked for manual input (integration transactions and other automatic transactions can be posted with this setting)
  3. Blocked for all purposes.
RSS
135678910Last

Theme picker

Tips:  LX | BPCS | M3

TECHNOLOGY: Facility Security Ranges

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

FINANCE: Expiration Date for Quotes and RMAs

A Cancel-by-Date has been added to the Quote Header and RMA Header panels. This optional field can limit how long a quote or authorization to return items for credit is valid.  

For quotes, this enhancement provides an optional end date for the quote. For RMAs, it provides an optional date by which the customer must return the items to receive the credit listed on the RMA.

The Cancel-By-Date prints on the Order Acknowledgement and RMA Acknowledgement to inform the customer of this important limitation to the quote or return authorization. 

An Order Entry user cannot copy the quote to create a new order if the Cancel By Date has caused the quote to expire.

OPERATIONS: Default Split Salesperson to Customer Orders

Sales commissions are based on combinations of the Primary, Split, and Line-Level salesperson and the commission codes defined for the customer and item. You can now define the Split Salesperson in the same master files as the Primary Salesperson. While the Primary Salesperson is mandatory, the Split Salesperson is optional. It defaults during Order Create using the identical hierarchy as Primary Salesperson. Using Split Salesperson provides more flexibility in the calculation of sales commissions. The ability to define a default Split Salesperson improves the accuracy of sales commission qualification and calculation and reduces maintenance and adjustments necessitated by corrections.

Previously, a user could complete the Cost Transfer (CST920) process for any range of facilities regardless of their security settings established in SYS600. This enhancement verifies the user security settings set up in SYS600 before processing cost transfers for a range of facilities in CST920. If the user has authority for a facility range, but there are facilities within that range that are not authorized, the program skips those facilities and completes the cost transfer process.

135678910Last

Theme picker

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Year-End Processing Checklist for Period and Fiscal Year Closure

The conclusion of the fiscal year is inevitably a hectic period, making it crucial not to overlook essential tasks within your ERP system to ensure a seamless year-end close and set the stage for a successful start to the upcoming year. Below are critical items to include in your comprehensive checklist:

Year-End Close Process:

  1. Remove discontinued items.
  2. Eliminate sold purchase receipts.
  3. Clear lot attributes for sold lots.
  4. Update standard cost based on the current cost field (for environments without Manufacturing only).

Prepare for Year-End Close:

  1. Conduct a comprehensive physical inventory and update quantities before the actual year-end or establish a robust cycle-counting program.
  2. Review and post any applicable sales and purchase invoices/returns.
  3. Prepare users for a year-end push to complete all year-to-date inventory adjustments, receipts, and invoicing.
  4. Determine procedures for handling new year transactions without immediate posting.
  5. Establish new standard costs for the upcoming year (Manufacturing).
  6. Discuss cutoff dates for removing Archived BOMs and Closed/Canceled Mfg Orders (Manufacturing).

Finance Specific Items:

  1. Set up financial periods for 2024 (fiscal, reporting, and tax, as applicable).
  2. Open January period in 2024.
  3. Finalize any outstanding transactions from the current year (2023).
  4. Perform a soft-close for any open periods in 2023.

General Baan/LN Tips:

  1. Issue any pending old sales invoices.
  2. Resolve outstanding financial integration errors.
  3. Establish new integration mapping for 2024 as needed.
  4. Test the mapping in a controlled environment before the new year.
  5. Review and update jobs to ensure they will process in 2024.
  6. Determine, for cash-flow purposes, which purchase invoices won’t be paid until 2024.
  7. Verify that calendars are set up for the new year with holidays correctly indicated.
  8. Check jobs to ensure that any with hard-coded dates will point at the new year.

For additional insights and tips on year-end processing, refer to the relevant documents in the Infor Knowledge Base.

 KB 

 Content 

 1879191  

 Document including step by step procedure, possible error/warning messages, and more (Infor LN) 

 1147023 

 Step by step procedure description (Infor LN)

 1116239 

 Step by step procedure description (Infor LN)

 1117334

 Step by step procedure description (Infor LN; Portuguese)

 1171300 

 Step by step procedure description (Baan IV) 

If you require assistance or have any questions, feel free to reach out to us, and we'll gladly guide you through the necessary steps to ensure a thorough and accurate completion of your year-end processes. Contact us at 1.800.762.2077 or via email at solutions@crossroadsrmc.com. Your success is our priority, and we're here to help.

Previous Article Infor LN & Baan Tip: When is backflushing disabled in LN?
Next Article Infor LX / BPCS & Infor LN / Baan Tip: Time for the Notorious TRIO: Manual -  Physical -  Inventory
Print
13423 Rate this article:
2.5
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

x

Categories