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

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Theme picker

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

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.....
First567810121314Last

Theme picker

Tips: LN | Baan

Are you striving to create shipping labels that cater to all your customers' needs? Do you require specific details on your shipping labels for particular items or product lines?

According to recent research, the global barcode label printer market was valued at $2.6 billion in 2022 and is estimated to reach $4.3 billion by 2032, exhibiting a CAGR of 5.2% from 2023 to 2032.

Crossroads RMC's RMClabel software automates the printing of customer-specific and item-specific labels...

Ensuring access to historical logistical and financial transaction information for your employees is crucial. However, before proceeding with archiving or deletion, it's essential to evaluate the necessity of retaining this data. Baan and Infor LN (ERP LN) offer standard archiving sessions within major modules that typically handle a significant volume of historical transactions. These sessions are designed to transfer historical data to an archive company before deleting it from the operational company.

When it comes to archiving sessions, you have three primary options:

1234567810Last

Theme picker

Categories