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

Kathy Barthelt
/ Categories: Infor LN & Baan Tips, Support, Training & Workshops, Consulting, Finance, Manufacturing, Operations, Technology

Infor LN & Baan Tip: How to deal with data growth of your ERP system…

Spending time on managing ERP data can deliver huge benefits, not just in reducing storage costs, but also in improving the experience of business users. Proactively managing application data also helps accelerate key business processes which has a positive impact on customers, suppliers, and partners. Use these solutions to reduce the data growth and disk storage used on your system:

• Use database compression. See Infor LN Data compression (B0050 US) for more information.
• Using the varchar data type for string fields reduces the size of the database. Tables must be recreated for the varchar conversion. See solution 22923520 for the latest porting set.
• Regular archiving history data will have a very positive effect on performance. The database growth will be limited and inserts in large tables will be faster. See the Infor LN User Guide for Archiving (U9352 US) for more information.

Previous Article Check-Ups are important… Including Infor LN & Baan ERP Check-Ups!
Next Article Infor LX & BPCS Tip: Transaction History – Did you know?
Print
120643 Rate this article:
5.0
Kathy Barthelt

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt
Contact author

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

Want to increase your efficiency across your organization?

Is access to real time data important to you?

Take a look at how and where your information is stored. Do you have employees keeping separate spreadsheets or databases outside of your ERP?

Separate data silos means that information is not being shared between departments. This can hamper growth, and cut down on overall efficiency. Take a look at why these silos exist. Can something be done within your ERP system to avoid having to store the information elsewhere? Can an integration be cre

ated to allow the ERP to have exposure to other databases, or allow updates to occur between systems?

Need help figuring out where to start? Contact us. We’d be happy to help.

Optimize Your Manufacturing Today!

Read more
  • Print Sales Order History Information - all invoices processed through sales
  • Check Inventory Valuation - this should tie out to your inventory accounts
  • Print Integration Information - see all postings from WIP to finished goods
  • Print G/L Transaction Information - print specific transaction types for any GL account
  • Print Lot Control Information - will show where serial numbers were used

Optimize Your Manufacturing Today!

Read more
FirstLast

Tips: LN | Baan

Categories