Please Wait a Moment
X

Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News

Resources Infor ERP Tips & News

Crossroads Connections

Infor ERP Tips & News from the Experts

Infor LX | Infor LN | BPCS | Baan | Infor M3

Subscribe to newsletter

Baan/LN Tip of the Week: Warehouse Material Movement / Problems With the Inventory Structure Table (whinr150)

Kathy Barthelt 0 62578 Article rating: 5.0

This has come up as an issue during various stages of warehouse material movements – transfers, outbounds, shipments. We have seen it right up to 10.4. The inventory structure table (whinr150) becomes a problem. The error points to that table, but users are lost as to how to fix it.

In the session Units by Unit Set many companies let the field Storage default to Yes. If the UOM is not intended to be used in inventory then that setting should be No. 

If an item is purchased in UOM different from the inventory unit and the setting is Yes then LN adds a record in that UOM to the inventory structure table. It is that record that causes problem later.

The session has an option to change the value of the storage field. Specific > Convert Use for Storage. This option works both ways and will correct all inventory in the UOM range. 

Should a user receive an error that references inventory structure table then the solution is to check that session to see if an odd UOM exists in it. If so use the Convert Use for Storage to correct the problem.

Read more

Baan/LN Tip: Disabling Unused Functionality in LN

Kathy Barthelt 0 62985 Article rating: No rating

If functionality such as Commissions, Rebates, or Contracts are enabled in the parameters, LN checks this functionality during transactions, even if you did not specify anything for these concepts. Therefore, if you do not use certain functionality within LN, to improve performance, disable the corresponding parameter.

Optimize Your Manufacturing Today!

Read more

Crossroads RMC named as Avalara's Certified Integration Partner for Infor LX

Anthony Etzel 0 26789 Article rating: 5.0

Avalara Announces 41 Newly-Certified Integrations Into Business Application


December 20, 2018 05:00 AM Eastern Standard Time

SEATTLE--()--Avalara, Inc. (NYSE:AVLR), a leading provider of cloud-based tax compliance automation for businesses of all sizes, today announced the release of 41 newly-certified integrations with accounting, ERP, ecommerce, point-of-sale, mobile commerce, and CRM software applications.

Avalara has been a partner-centric company since its founding in 2004, with a keen focus on integrating with technology solutions already in use by existing and future customers. Avalara Certified integration partners have met criteria developed by Avalara to guarantee each integration’s performance and reliability. Certified integrations are built to ensure customers enjoy a fast, reliable, and easy process for embedding Avalara’s automated tax management into existing systems.

Additionally, these integrations enable customers of Avalara partner solutions to benefit from Avalara’s real-time calculation of applicable taxes, fees, and surcharges for billing line items. Avalara software reduces the tedium and complexity of determining taxes for millions of products and services across the U.S., Canada, Europe, and other international jurisdictions, giving customers more time to focus on driving their own business success.

The latest group of Avalara Certified integrations includes:

  • Infor LX (by Crossroads RMC) is an ERP solution used primarily by manufacturers.

Read more

Baan & LN Tip of the Week: Get Real!

Kathy Barthelt 0 65666 Article rating: No rating

You’ve got an ERP system, so everything should be real-time and everyone should have access to information in real-time, right? RIGHT?!

Why not? Why are there spreadsheets, and separate Access databases off to the side?

Data loses value over time, so why not give everyone up to date, accurate information all the time? Take a look at those silos of information and see how you can eliminate them. Your business will benefit greatly as a result.

Optimize Your Manufacturing Today!

Read more

BPCS & LX Tip of the Week: Get Real!

Anthony Etzel 0 45038 Article rating: No rating

You’ve got an ERP system, so everything should be real-time and everyone should have access to information in real-time, right? RIGHT?!

Why not? Why are there spreadsheets, and separate Access databases off to the side?

Data loses value over time, so why not give everyone up to date, accurate information all the time? Take a look at those silos of information and see how you can eliminate them. Your business will benefit greatly as a result.

Optimize Your Manufacturing Today!

Read more

Baan & LN Tip of the Week: Simplify & Save Money – Evaluate Your Production Lines

Kathy Barthelt 0 61964 Article rating: No rating

When is the last time you took a hard look at your production lines?

  • How are you moving product through the facility?
  • Do you have work instructions / drawings available where needed?
  • Do you have frequently used inventory available at the line?
  • Where are the bottlenecks?
  • Are your processes simplified?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

Read more

BPCS & LX Tip of the Week: Simplify & Save Money – Evaluate Your Production Lines

Anthony Etzel 0 46849 Article rating: No rating

When is the last time you took a hard look at your production lines?

  • How are you moving product through the facility?
  • Do you have work instructions / drawings available where needed?
  • Do you have frequently used inventory available at the line?
  • Where are the bottlenecks?
  • Are your processes simplified?

Taking a hard look at your processes and procedures may reveal some interesting results. Don’t assume that everyone is doing things the same way. Some may be superstars, and others may need some mentoring. Some processes may be outdated and costing you time and money, while others are extremely efficient. One area of the business may benefit from how others operate. Take the time to review and analyze your findings. Your company may benefit greatly as a result.

Optimize Your Manufacturing Today!

Read more

BPCS/LX Tip of the Week: Make Your ERP Work FOR You - Streamline Your Processes

Anthony Etzel 0 43586 Article rating: No rating

Such lofty goals you had when you implemented your ERP system. It was going to be like pressing the “Easy Button”…  then it wasn’t.

What happened? In some cases, decisions were made to implement the system “just like we used to run our old system”. Great idea? Not so much. Your business changes, and your business software needs to change as well.

Are you using the ERP system, but everything seems cumbersome and takes more time than its worth? 

Ask yourself these questions:

  • Have you looked at streamlining your processes?
  • Can you automate a step or two and eliminate some manual keying?
  • Can you add barcoding to avoid keying in some information altogether?
  • How about automating the printing of some reports?

Now is the time to sit down and really review the steps required to complete the task and think out of the box a bit. Soon you can develop your own streamlined process to get the job done quickly and efficiently.

Optimize Your Manufacturing Today!

Read more
First7172737476787980Last

Tips:  LX | BPCS | M3

Item Facility Master has a new attribute to define the override inspection days lead time CICP.ICINSD.

  • When an item facility has a defined override inspection days lead time, that value will be used instead of the system parameter inspection days lead time.

MRP exception report, MRP200B
Purchase planning report, PUR285B
Purchase order / Requisition maintenance, PUR500D3
Purchase order consolidation / release, PUR640B1
Vendor splits, PUR653B

Read more

This enhancement improved the subfile utilized in MRP320D Master Schedule Detail Inquiry -SCR001 by expanding the subfile with data rather than clearing the subfile as user pages. This change provides full support for the WebTop 4.8 Grid decorator.

This enhancement updated the approach used to populate the subfile to allow a deployed Webtop Grid to function correctly. There is no visible or user-impacted change to the way the program functions.

This enhancement provides improved functionality and full support of a Webtop grid applied to the subfile.

Read more
Last

Tips: LN | Baan

Kathy Barthelt
/ Categories: Infor ERP Tips, Infor LN & Baan Tips, Services News, Support, Training & Workshops, Finance, Manufacturing

Infor LN & Baan Tip of the Week: Reports to Analyze Company Performance

You know what data you need to analyze your company’s financial and production health, but sometimes it's a struggle to get that data in a format that is meaningful. Here are some reports in Baan IV, Baan V, and Infor LN which you may find useful.

As is the case with most ERP reports, with each version progression from Baan IV, to Baan V, to LN, there are improvements in selection criteria and report content. Some may require some setup and others may require some formatting if you would like to export them to Excel.  Contact me if you have questions or need assistance.

BAAN & LN FINANCE:

Baan IV –

Customer Statistics Module

  • Print Customer Statistics by Customer/Credit Analyst (tfcmg3400m000)
    • Prints Average Days Payment, Amount Paid, Average Days Outstanding, Amount Open, Discounts Allowed and Discounts Taken.  
       
  • Print Average Days Outstanding (tfcmg3401m000)
    • Prints Open Amount and Average Days Outstanding.
  • Print Average Receipt Days (tfcmg3402m000)
    • Prints Amount Paid and Average Number of Days for a Payment.


Cash Forecasting Module

  • Print Cash Forecast Summary by Period/Currency (tfcmg3410m000)
    • Prints Total Cash coming in from Sales Invoices, Sales Orders, Sales Quotes, Project Orders, and Budgets. Prints Total Cash going out from Purchase Invoices, Purchase Orders, Standing Orders, and Budgets.
       
  • Print Cash Forecast Summary by Date/Currency (tfcmg3411m000)
    • Prints the same as above but by a specific date.
       
  • Print Cash Forecast Details by Period/Currency (tfcmg3412m000)
    • Prints the same as above but by each period across in columns.
       
  • Prints Detailed Cash Forecast in Home Currency (tfcmg3413m000)
    • Prints each item, purchase order, sales order, etc, with forecast in home currency.


Baan V –

  • Print Finalized Transactions Ledger Account – tfgld1406m000
    • Output can be run to show transactions (debit/credit) by ledger account, transaction type, and time periods. This can be run by range of ledger account and/or range of periods.
  • Print Integration Transactions -tfgld4410m000
    • This has 3 options: a short version of the report, a standard version, and a version by company/ledger account.

Infor LN -

  • Print Finalized Transactions Ledger Account – tfgld1406m000
    • Output can be run to show transactions (debit/credit) by ledger account, transaction type, and time periods. This can be run by range of ledger account and/or range of periods.
  • Print Integration Transactions by Business Flow – tfgld4482m100
    • Output can be run to show all transactions (debit/credit) by business object (production/purchasing/sales)


BAAN & LN MANUFACTURING:

Baan IV

  • Print Actual Cost by Production Order ticst0401m000
    • This report can be run at any time in the production order’s life to show how hours-spent and material-used compare between estimated and actual usage.
       
  • Print Work Center Utilization By Week tiscf1402m000
    • This report shows capacity issues at work centers/machines which help identify production bottlenecks.


Baan V

  • Print Estimated vs Actual Material Costs ticst0401m000
    • This report can be run at any time in the production order’s life to show how actual material-used compares to estimated usage.
       
  • Print Estimated vs Actual Hour Costs ticst0402m000
    • This report can be run at any time in the production order’s life to show how actual hours-spent compares estimated hours.
       
  • Print Work Center Utilization By Week tiscf1402m000
    • This report shows capacity issues at work centers/machines which help identify production bottlenecks.


Infor LN

  • Print Estimated vs Actual Material Costs ticst0401m000
    • This report can be run at any time in the production order’s life to show how actual material-used compares to estimated usage.
       
  • Print Estimated vs Actual Hour Costs ticst0402m000
    • This report can be run at any time in the production order’s life to show how actual hours-spent compares estimated hours.
       
  • Utilization report from– Print Resource Order Plan cprrp0430m000
    • This report from Enterprise Planning will show all orders from planning and production. By incorporating both order types, capacity issues can be seen short range where planning has determined that new orders are needed, as well as long range where planners may find opportunities to shift work or even to plan machine maintenance.

Previous Article The Best Baan | Infor LN Manufacturing Reports to Analyze Company Performance
Next Article Infor LN & Baan Tip of the Week: Year End
Print
51894 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt
Contact author

Contact author

x

Categories