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

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author

Please solve captcha
x

Tips:  LX | BPCS | M3

In SFC600, there is no code to capture the time spent on re-work. Re-work is usually at a specific operation, or when the part is finished and QC determines that re-work is required in order to pass inspection. You are faced with deciding on how to report the additional labor time.

Do you continue to report it against the operation, or create a re-work shop order?

If you are re-working through a specific operation you can capture the time as run labor with the SFC600 program. Now you need to deal with the variance of actual to standard time and what impact this has on costing.

Make to Order? No problem if you use the Configuration Management System. This LX product allows you to define and configure a make to order product during Customer Order Entry. Basically, you have the option to create different products under the same common product item. You will get two completely different common end items that are configured from the same common parent.

The customer orders are planned and turned into shop orders for each end item with all the associated components. With an MES solution in place, the shop order side is easy to schedule and allows you to manage the shop floor.

FirstLast

Tips: LN | Baan

Categories