Infor ERP Tips and Infor ERP News for Infor LX, BPCS, Infor ERP LX, Infor LN, Infor ERP LN, Baan, Infor M3, and Movex

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

Manage the Complexity of Tax Compliance

Insights from our partner Avalara

Crossroads RMC 0 438 Article rating: 5.0

Sales tax compliance becomes more complex as businesses grow. Expanding into new markets, adding locations, selling online, or integrating systems after an acquisition can quickly introduce new tax obligations.

Many organizations find manual tax processes difficult to manage and scale. Automation can simplify compliance, improve accuracy, and reduce the risk of costly penalties.

When Compliance Gets Complicated

Changes such as the following often create new tax requirements:

• Upgrading or changing ERP systems
• Mergers or acquisitions requiring system integration
• Adding locations or warehouses
• Expanding into e-commerce
• Managing remote employees
• Selling at trade shows across multiple states

Businesses may also struggle with large transaction volumes, exempt products or customers, audit exposure, and tax obligations in complicated states.

Why Avalara & Crossroads RMC

Avalara automates tax registration, calculation, filing, and document management, helping businesses maintain compliance as they grow.

Crossroads RMC integrates Avalara directly with Infor ERP environments, enabling automated tax calculations and reporting within existing ERP workflows.

Avalara supports more than 41,000 businesses and government organizations in over 75 countries, helping organizations manage complex tax requirements while focusing on growth.

800.762.2077 | Contact Us

Infor ERP Tips & Tricks: Already Have Avalara? Integrate It with Your Infor ERP

Infor LN | Baan | Infor LX | BPCS

Crossroads RMC 0 608 Article rating: 5.0

If your company already uses Avalara for tax compliance, you can integrate it directly with your Infor ERP system.

Crossroads RMC has developed integrations that connect Avalara’s automated tax calculation and compliance platform with Infor ERP environments, allowing tax calculations, reporting, and compliance processes to run seamlessly within your existing ERP workflows.

This integration helps eliminate manual tax processing, improve accuracy, and ensure tax compliance as your business grows.

If you’re already using Avalara and want to streamline tax automation within your ERP, Crossroads RMC can help you connect the two.

800.762.2077 | Contact Us

Elevate Your Team's Output with Expert CloudSuite/LN & Baan Help Desk Services

Kathy Barthelt 0 734 Article rating: 5.0

In today’s fast-paced business environment, maintaining an efficient and responsive ERP system is crucial for success. However, managing ERP support internally can be resource-intensive and distract from your core business objectives. That’s where Crossroads RMC comes in. With our on-demand ERP Expert Help Desk Service, your organization can enhance efficiency, boost customer satisfaction, and allow your team to focus on key business goals.

Key Advantages

  • Round-the-Clock Support: Access functional and technical support 24/7, 365 days a year—even on weekends and holidays!
  • In-depth Expertise: As an Infor Partner, we offer extensive knowledge across all Infor CloudSuite/LN & Baan versions, ensuring you get the best possible support.
  • Comprehensive Technical Management: Expert assistance with extensions, personalizations, report development, and system administration to keep your environment optimized and tailored to your needs.
  • Multiple Communication Channels: Reach out via phone, text, email, online portals, Microsoft Teams, web meetings, or in-person visits.
  • Transparent Monitoring: Receive transparent monthly reports to keep track of service utilization.
  • Disaster Recovery Solutions: Benefit from comprehensive ERP disaster recovery solutions tailored to safeguard your operations.
  • Specialized ION Support: Get expert assistance with your ION data flows, workflows, and APIs for seamless integration and management.

Why Crossroads RMC - Partnering for Success

  • Cost Savings: Outsourcing your ERP Help Desk with Crossroads RMC can significantly reduce the overhead costs associated with supporting and maintaining your ERP system.
  • Access to Specialized Expertise: Our team consists of skilled consultants who are deeply familiar with your ERP systems. Their expertise ensures quick and effective resolutions to your issues, minimizing downtime and enhancing overall productivity.
  • Scalability: Adjust the level of support as your business needs change, without the hassle of hiring or training new staff. Whether your company is growing, scaling down, or experiencing seasonal fluctuations, Crossroads RMC provides the flexibility to match your evolving requirements.
  • Focus on Core Business: Free up your internal team to focus on strategic projects that drive growth and innovation. Outsourcing your ERP help desk allows your staff to concentrate on core business functions, leading to better use of time and resources.
  • Comprehensive Partnership: At Crossroads RMC, we are dedicated t

Infor LN & Baan Tips & Tricks for TECHNOLOGY: Audit Configuration Management

Kathy Barthelt 0 1356 Article rating: 5.0

You use LN audit features to fully or partially log changes that users make to the LN database tables when they use LN sessions.

The audit functionality is based on the concept of audit profiles. In an audit profile, you define which tables and fields are audited and when, in the context of an audit profile. To bundle profiles in the same functional area, you can relate the profiles to audit categories. You can export and import audit profiles with various options to enable a quick configuration. The audit trail is stored in sequence files, which are generated for each combination of company and table.

Note: For some important parameter tables it is required that auditing is enabled.

You can view or print the history of modifications.

Infor LN & Baan Tips & Tricks for OPERATIONS: Production Order Parameters

Kathy Barthelt 0 974 Article rating: 5.0

To avoid having to report quantities also at the order level, set the Post to Inventory when Reporting on Last Operation parameter to Yes in these sessions:

  • Production Order Parameters (tisfc0100s000) > Planning tab
  • Production Settings by Site (timfc0180m000) > Production Order tab

With regard to as-built handling, because JobControl acts as a reporting tool similar to the Machine Work List (tisfc4600m000) session, we recommend these settings in the Production Order Parameters (tisfc0100s000) session (Miscellaneous tab) and Production Settings by Site (timfc0180m000) session (Production Order tab):

  • In the Serials section, set the Generate Serial Numbers parameter to On Printing Documents or On Release as the serial number that can be selected in JobControl to report completed or rejected products must have the Valid status in LN.
  • In the Serials section, we recommend setting the As-Built Status Handling parameter to Manual as the serial number assignment is performed in JobControl.

Infor LN & Baan Tips & Tricks for FINANCE: Copy Received Purchase Invoices (tfacp1210m000)

Kathy Barthelt 0 880 Article rating: 5.0

When the invoice is copied, the status in the Invoice Status field in the Received Purchase Invoices (tfacp1500m000) session is set to Registered. The invoice cannot be copied again.

Note: If you have started this session using the browse arrow, you can only find and select a record.

Field Information

  • Invoice-from Business Partner: The invoice-from business partner
  • Document - The document number: The document number is a sequence number under which the invoice is temporarily recorded. When an invoice is registered officially, you must assign the invoice to a different number, in combination with a transaction type.
  • Business Partner Invoice Number: The invoice-from business partner's invoice number is the invoice identification used in LN: This number is printed as the payment reference when the invoice is paid.
  • Invoice Date: The date printed on the invoice. This date is used as a reference date for the term of credit allowed.
  • Currency: The invoice currency
  • Amount: The invoice amount
1345678910Last

Tips:  LX | BPCS | M3

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
64737 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories