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

About 65% of the world’s population are visual learners. This extends into the ERP software realm, too.

Infor LX & BPCS

George Moroses 0 63750 Article rating: 5.0

Graphical representation makes complex concepts—like the intricacies of an ERP system—more universal, relatable and easy to understand.

ERP dashboards gather and visualize critical metrics from across the organization, offering insight into the performance, outlook and interconnectivity of business processes.

By setting up ERP dashboards that illustrate key metrics and compellingly communicate operational performance, key stakeholders will have a clear picture of the health of the business—and make better, more informed business decisions as a result.

The Crossroads Analytics Dashboard has preconfigured views for all of the following:

 Infor LX & BPCS
  • Sales Bookings (ECH)
  • Accounts Receivable (RAR)
  • Accounts Payable (APH)
  • Planned Orders (KFP)
  • Purchasing (HPH)
  • Shop Order Material (FMA)
  • Shop Order Operations (FOD)
  • CEA
  • Order Booking (ECS)
  • Labor History (FLT)
  • Sales History (SIH)
  • Material Status (IIM/ILI)

To learn more visit our Analytic Dashboard webpage.

Consulting News: How do I identify the processes that impact my ERP upgrade?

Crossroads RMC 0 44732 Article rating: 5.0

Identify all of the processes that impact my ERP upgrade

  • Identify all current users that transact/execute transactions
    • List users by transaction type/functional area
    • List users by shift worked (off-shift resources often support multiple areas/functions)
    • List users by time frame of use (Daily, Weekly, Monthly, Annually)
       
  • Identify all users that receive reports from the system
    • List last run date of all reports, queries and owners
       
  • Identify all data extract programs/routines
    • Downloads to Excel/Access databases
    • Downloads to Labor / Payroll Reporting Systems
    • Downloads to Assets Management Systems
    • Downloads to Third Party Logistics partners
    • EDI messages for requirements downloads to vendors
    • EDI Input for Order Entry, ASN, and Quotes.
    • Downloads/uploads to vendor Quality Management Systems

Infor LX & BPCS Tip of the Week: MPS vs. MRP

George Moroses 0 65544 Article rating: 5.0

What items should be MPS planned, and what items should be MRP planned…

Master Scheduled Items are those items that are finished goods, or service items, that receive their requirements either specifically from Independent demand, or both Dependent and Independent demand.

  • Independent Demand is demand that cannot be calculated from higher level demand in the product structure, and therefore must be either a forecast or an actual customer order (Finished Goods or Service parts sold to customers).
  • Dependent demand is derived from higher level demand in the product structure. Dependent demand includes components, raw materials, and sub-assemblies. (these are not normally Master Scheduled Items).
  • Service Parts may have both independent demand from forecast and/or customer orders, as well as dependent demand from higher level demand if that item is also used in other sub-assemblies or products.
  • Cumulative Lead Time is a concept used in Master Production Scheduling (MPS) that combines the “fixed” lead time, and the “variable” lead time needed to produce the product. It is the longest path through a given Bill-of-material. Based on the MPS setup options, Infor/ERP LX will calculate cumulative lead time (also called “the Critical Path”) for you (use the “indented BOM” display in BOM300 and find the item with the longest lead time “L/T”). Note: You may have to use Action 21, Line Detail, to see the “L/T” lead time for each item.

You’ve got a handle on your inventory requirements, right? Are you confident you can handle a rush order, or ten rush orders?

Baan & LN Add-Ons

Kathy Barthelt 0 36341 Article rating: 5.0

RMCbuild gives you the ability to report a component’s gross requirement, shortage, on-hand inventory, on-order inventory, allocated inventory, inspected inventory, production or work orders due to replenish component inventory, buyer or planner, and/or item group… and more.

RMCbuild takes all the surprise and guess work out of inventory planning. Give your employees the tools they need to do their job effectively.

Avalara isn't only tax calculation and returns filing....

Baan & Infor LN

Kathy Barthelt 0 41059 Article rating: 5.0

Did you know that in addition to tax calculation and returns filing, Avalara can also help with:

  • Business license and tax registration
  • Streamlined Sales Tax qualification
  • Nexus analysis and compliance
  • Tax document management including exemption certificates
  • Audit preparation

Contact us today! We partner closely with Avalara to provide you with solutions on ALL version of Baan and Infor LN!
 

Infor LN & Baan: Is Your House All In Order?

Kathy Barthelt 0 32655 Article rating: 5.0

Have you successfully closed all of the fiscal, tax and reporting periods for 2019 and closed the year? Sometimes this task hangs out there looming because either people don’t know what needs to be done, or there is a fear there are going to be problems.

Let Crossroads RMC’s expert finance consulting team help you through this.

Move into 2020 with ease! Contact Kathy Barthelt today to put together a plan for your close.
800.762.2077

Want a way to convert IBM i ® spool files into full-color, professional forms that are output as PDF documents?

Anthony Etzel 0 33233 Article rating: 5.0

Want a way to convert IBM i ® spool files into full-color, professional forms that are output as PDF documents?

Crossroads RMC and TL Ashford can help you get there!

TLAForms provide a reliable, feature-rich, cost-effective forms solution for IBM i, with no programming required!

Contact Anthony Etzel for more info: 1.630.955.1310, x125 or aetzel@crossroadsrmc.com

First5758596062646566Last

Tips:  LX | BPCS | M3

Tips: LN | Baan

Kathy Barthelt

Infor LN & Baan Tips & Tricks for 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.
     

Previous Article Infor LN & Baan Tips & Tricks for EXECUTIVES
Next Article Infor LN & Baan Tips & Tricks for OPERATIONS: What is Statistical Inventory Control (SIC) and How Does It Work?
Print
47229 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

x

Categories