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: Purge optional during Month/Period End - LX 8.4

George Moroses 0 56849 Article rating: 5.0

For various month/period end programs, the purge function is now optional.

Scope:

INV903, Inventory Month End Close, optionally purges both inventory records as well as customer invoices. Some applications already have a flag or option for purging (for example, ACP900) and other applications are stand-alone. If you do not want to purge, do not run these programs: Order Purge and Close, ORD900, Close Quotes, ORD930, and Delete RMAs, ORD935. Now there are options on whether to purge records during the month end or period end programs.

The Benefits include:

• Flag or option added to allow the user to decide whether to perform month-end function with or without purge.

• Allows for month-end processing without purge.

• Improves efficiency of month-end processing.

Impact:

This enhancement includes these programs or areas:

• INV903, Inventory Month End Close

• ACR900, A/R Period Close

• CST900, PRF900, SFC900 Shop Order Close

• PUR900, Purchasing Month End Close

Johnson Crushers Selects Crossroads RMC for LN 10.6 Data Collection

Kathy Barthelt 0 37889 Article rating: 5.0

Johnson Crushers International (JCI), a global leader in engineering and manufacturing full lines of cone crushers, horizontal and incline vibrating screens and track-mounted, portable and stationary crushing and screening plants, has selected Crossroads RMC’s Data Collection solution for their Infor LN 10.6 implementation. 

JCI’s main objectives with this project are to support their continued growth and enable a continuous improvement effort to drive additional value to the business. In phase 1 of this project, JCI will implement Crossroad RMC’s Labor Reporting and Maintain Receipts data collection applications. Go live is expected to occur in early Q1 of 2020.

Factors to considered when undertaking an ERP implementation or upgrade

Kathy Barthelt 0 38185 Article rating: 5.0

Things to consider when choosing your ERP Implementation Partner:

ERP Partner Value Add:

  • Proven track record
  • References
  • Focused on-time / on budget
  • Strategic partnership with Infor
  • Knowledge of extension products that are available for your ERP
  • Post-implementation – What does the partner bring to the table once the project is complete?

Project Management

  • Does your assigned project manager fit your needs?
  • Past project management experience with the same ERP
  • Project Management methodology
  • Project Plan development and style
  • Does the PM develop a realistic plan with clear objectives, timeline, and responsibilities?

 
Consulting Team Selection​

Need help figuring out if your organization is properly positioned for an implementation or upgrade? Contact Kathy Barthelt today. We can help to ensure that your organization is positioned for success.

  • Does my ERP Implementation partner have the team to support my project?
  • Resume review
  • Interview all candidates
  • Working knowledge of ERP system/version
  • Communication skills
  • Geographic location
    • Relative industry experience
    • Technical Viewpoint
    • Understanding of any enhancements made to your system and what the best approach to streamlining for future releases. Knowing the tools available to accomplish this task.

LN & Baan Tip of the Week: Inventory In Transit Report – 10.7

Kathy Barthelt 0 80945 Article rating: 5.0

A new In Transit Inventory report can be printed in the Print In Transit Inventory (whinr1410m300) session. The report provides an overview of company inventory that is on the move and not stored in a warehouse. This concerns only inventory that is transferred from one warehouse to another. Items that are shipped to, for example, customers or projects, or items that are issued to production lines or service departments are excluded.

The report shows item inventory quantities and values on warehouse transfer orders which are issued at the origin warehouse, but are not yet received in the destination warehouse. These open inter-warehouse transfer orders represent inventory that is loaded on trucks or other means of transport, or located at intermediate pooling points such as harbors and train stations.

The quantities and values are retrieved from the Item-Warehouse-Inventory Transactions and the Inventory Integration Transactions sessions.


Do you know where you're required to collect sales tax?

Crossroads RMC 0 34193 Article rating: 5.0

More than 40 states have changed their rules on sales tax obligations for remote sellers in the past year, meaning more companies are required to collect sales tax in states they’ve never even considered before. 

Attend the Avalara sessions at Inforum to learn more:

333450 - Vision: From 1 to 50—Scaling your business to handle new sales tax requirements, sponsored by Avalara
New laws that obligate remote sellers to collect sales tax are spreading throughout the US. In many states, you’re now required to register, file, and remit if you make 200 transactions or $100,000 in sales into the state. In this session, a sales tax compliance expert will break down what these new laws mean for your business and how you can scale your business effectively without turning your accounting and finance operations upside down. Join us to learn how to prepare.
Wednesday, Sep 25, 2:00 PM - 02:45 PM – Room 288

333727 - Speed: Sales tax compliance in the post South Dakota v. Wayfair era, sponsored by Avalara
Join Avalara to learn about sales tax compliance in 2019. We’ll review new mid-year sales tax changes for 2019; economic nexus laws and how to mitigate risk and maintain compliance; help you determine where to file and register based on where you conduct business; and discuss how Avalara and Infor deliver end-to-end cloud-based sales tax automation, including rate determination, return filing, remittance, and exemption certificate management.
Wednesday, Sep 25, 1:30 PM - 01:50 PM – Hub Theater 6 (Product Spotlight)

Anxious to learn more about IDF? Attend Inforum Sessions highlighting the latest and greatest updates

Anthony Etzel 0 24714 Article rating: 5.0
  • ERP242 - Product: What’s new with LX 8.4
    Learn about our latest release of LX and the value it can provide to your business. This release includes additional support for IDF, new application features, and an expanded database. Additionally, this release continues to improve through ongoing enhancements from our enhancement request system.
    Thursday, Sep 26, 10:00 AM - 10:45 AM – Room 272

  • ERP243 - Product: LX—IDF Master Data Management
    Learn about the new flexibility and features available with item, cost, vendor, and customer definition through IDF during this session. Maintaining this critical information is now easier to manage and control with LX 8.4
    Wednesday, Sep 25, 12:00 PM - 12:45 PM – Room 272

  • Academy: Learn to Use IDF to Better Manage Customer, Vendor, and Item Data with LX
    Attend this session for hands-on experience using IDF to manage your critical master data in Infor LX 8.4. (Length: 1hr & 45mins) 
    Wednesday, Sep 25, 1:00 PM - 02:45 PM – Room 277

  • ERP106C - Case Study: Trinity—Upgrading a 20-Year-Old Customized ERP system
    Join this session to learn why and how Trinity is upgrading its customized 20-year-old BPCS ERP system to the latest version of LX and going vanilla. Trinity is using the best business practices built into LX along with Infor OS and IDF to support the latest user experience and integrations.
    Wednesday, Sep 25, 2:00 PM - 02:45 PM – Room 272

OTTO: Making plans happen isn’t just about monitoring material shortages

George Moroses 0 27761 Article rating: 5.0

Making plans happen isn’t just about monitoring material shortages. Supporting activities can be the real cause of delays. Some non-material events customers have monitored using OTTO include:

  • Scheduling and coordination of outside services (such as heat treating and plating)
  • Quality Assurance for pharmaceuticals and inspection
  • Moving off-site inventory to the plant
  • Moving inventory from temporary (conveyor) location to pickable location
  • Scheduling of overseas containers
  • Design engineering for make-to-order

OTTO provides the ability to proactively manage the entire customer order backlog from top to bottom. It begins monitoring orders as soon as they’re booked and identifies and prioritizes those critical events that must happen every day so they can be managed and get orders produced and shipped on time.

Visit Our OTTO page to learn more.

First5960616264666768Last

Tips:  LX | BPCS | M3

Improves control over PO costing changes during invoice entry by replacing passive warnings with an intentional override action.

  • In ACP500D3 (Invoice Entry PO Costing), users previously could unintentionally accept changes by pressing ENTER, even when quantity to cost or amount to cost values had changed.

  • A new “F14 to Override” warning message replaces the old message:
    “Details have changed. Press enter again to accept data.”
    This ensures users acknowledge and confirm significant changes explicitly.

New System Parameter:

  • “Apply GRN Costing Tolerance for PO Costing” (optional):

    • Within tolerance: Displays the original message —
      “Details have changed. Press enter again to accept data.”

    • Outside tolerance: Triggers the new override requirement —
      “F14 to Override”

Benefits:

  • Enhances oversight and reduces unintentional cost acceptance.

  • Enables better control of PO costs when invoice details differ from expectations.

Last

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Use of Electronic Bank Statements

All actions required for converting, validating, matching, and posting electronically received bank statements can be performed within a single session:

  • Bank Statement Workbench (tfcmg5610m100)
  • Bank Statement (tfcmg5610m000)

Alternatively, you can use the sequence of electronic bank statement sessions outlined below.

Steps to Process Electronic Bank Statements:

  1. Convert Electronic Bank Statements (tfcmg5202m000)
    Convert the received bank file to a format that LN can process. LN stores the converted bank statement files in the directory specified in the Path For EBS Archive field of the Bank Relations (tfcmg0510m000) session. In the Pathname EBS File field, you must add the file name. To add the current date to the file name, append a tilde (~) to the file name.

  2. Validate Bank Statements (tfcmg5202m000 / tfcmg5510m000 / tfcmg5511m000)
    Validate the converted electronic bank statement.

  3. Match Bank Statements (tfcmg5210m000)
    Automatically match as many of the imported statements (status Validated) as possible with open items. LN can match the statements with sales invoices, purchase invoices, and anticipated payment documents.

    Matching Options:

    • Match - Surplus on Aging / Unallocated (Default value)
    • Match - Surplus on Unallocated
    • Match - Surplus to be allocated Manually
    • Allow Underpayments
    • Use Payment Difference Tolerance
       
  4. Matching Results (tfcmg2500m100)
    Review the results of the matching process.

    To handle an unmatched amount, you can:

    • Manually add an unallocated payment or receipt line.
    • Reconcile the surplus with remaining open entries of the business partner.
       
  5. Post Bank Statements (tfcmg5210m100)
    Post the bank transactions to the General Ledger.

    Update the business partner’s bank account number and other details in the Bank Account by Pay-by Business Partner (tccom4115s000) session, based on the details read from the bank statement file.

OPERATIONS: What is Statistical Inventory Control (SIC) and How Does It Work?

Statistical Inventory Control (SIC) is an inventory-controlled order system designed to maintain stock levels based on predefined thresholds, rather than being demand-driven like EP (Enterprise Planning). Since SIC relies on inventory levels, it may lead to higher stock levels. To minimize financial risks, SIC is best suited for:

  • Low-cost items.
  • Items with predictable demand or short lead times.


Applications of SIC

  • Low-Cost Items: Particularly effective for inexpensive goods.
  • Predictable Demand or Short Lead Time: Suitable when demand patterns are stable or lead times are minimal.
  • Warehouse-Specific Planning: Useful for planning by warehouse rather than across the supply chain.
  • Trading Industries: Commonly employed in sectors like supermarkets.
  • Immediate Demands: Effective for items required immediately by customers.
  • Ease of Use: Simple to implement and manage.


Limitations of SIC

  • Does not account for dependent demand from planned orders (e.g., MPS/MRP/INV).
  • Does not generate distribution orders.
  • Ignores time-phased planned orders.
  • Lacks forecast consumption techniques.
  • Uses both nettable and non-nettable warehouses.

How SIC Works

SIC operates based on the Reorder PointStock Levels, and Order Method.

Triggering SIC

When Economic Stocks (calculated as On-Hand Inventory + On-Order – Allocated Stocks) on the Horizon Date fall below the Reorder Point, SIC triggers the creation of:

  • Planned Purchase Advice.
  • Planned Production Advice.


Order Methods in SIC

The quantity for these advices is determined by the Order Method, which can be one of the following:

  • Replenish to Maximum Stock
  • Fixed Order Quantity
  • Economic Order Quantity (EOQ)
  • Lot-for-Lot

Example: SIC in a Supermarket

Scenario: Managing stock for Ice Cream (1 Kg Pack)

  • Current Stock: 10 PCs
  • Reorder Point: 5 PCs
  • Safety Stock: 2 PCs
  • Lead Time: 1 Day
  • Order Method: Replenish to Maximum (Maximum Stock: 20 PCs)
  • Maximum Anticipated Consumption: 3 PCs/Day

Process:

  1. Customer purchases reduce the stock.
  2. When stock reaches 5 PCs, SIC is triggered.
  3. A Purchase Advice is generated for 15 PCs to replenish stock to the maximum level (20 PCs).
  4. During the lead time (1 day), the remaining 3 PCs (excluding Safety Stock) meet customer demands.
  5. In emergencies, Safety Stock can also be utilized.

Statistical Inventory Control offers a practical approach for managing inventory levels, particularly in industries with predictable demand or fast-moving items. However, its limitations make it less ideal for complex or time-phased planning scenarios.

TECHNOLOGY: Archiving Data from tipcs300 and ticst300 Tables

1. Archiving tipcs300

  • Using Session tipcs2260m000:
    • When archiving PCS projects, selecting the "Archive Financial data" option ensures that:
      • Records in tipcs300 are archived to the archiving company.
      • Records are deleted from the original company.
    • If records remain in tipcs300:
      • They may belong to projects that have not been archived.
      • The project may have been archived without selecting "Archive Financial data."
    • Verify there are no errors during the archiving process.
  • Using Session tipcs3500m001:
    • The session "Delete Financial Transactions by Project" can delete records from tipcs300.
    • Note: This session is not for archiving; it removes records without copying them to the archiving company.

2. Archiving ticst300

  • Using Session ticst0250m000:
    • The session "Archive Production Orders" allows:
      • Archiving and deleting records from the original company.
      • Only deleting records from the original company.
    • When executed:
      • Records in ticst300 associated with archived orders are removed.
      • Remaining records belong to unarchived orders.

Previous Article Infor LN & Baan Tips & Tricks for TECHNOLOGY: Archiving Data from tipcs300 and ticst300 Tables
Next Article Infor LN & Baan Tips & Tricks: Action Required - Infor LN Cloud Edition - Fonts Update!
Print
56288 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories