Infor LN / Baan Tips & Tricks for EXECUTIVES
Finance: Propagating Unused Sub-Accounts
You can use this procedure to find accounts that have a valid sub-accounts group but no corresponding general ledger chart account records. This action creates the general ledger chart account record for the account and sub-account combination. This action does not add the accounts to charts.
- Select Financials > Global Ledger > Setup > Finance Enterprise Group > Maintenance.
- Open the finance enterprise group and click the Sub Account tab.
- Select Actions > Propagate Unused Sub Accounts.
- Select the finance enterprise group and click OK.
Sub-accounts are added according to group if they have been defined on the accounts. The resulting account can be added to the charts.
Operations: Best Practices for Purchase Order Archiving / Deleting
Here are some best practices to follow if you are considering archiving or deleting purchase order data:
You cannot delete a purchase order (line) if:
- The linked warehouse order is closed but cannot be removed.
- The purchase order is linked to a PCS project that is not yet archived. When the PCS project is archived, the purchase data is also archived and you can delete the purchase order.
- A consignment replenishment order is not yet consumed completely.
- The invoice is yet to be completely matched and approved.
- The invoice amount is not yet inserted as turnover history.
- The sales order or service order that's linked to the purchase order line, and for which an internal invoice must be sent from the purchas office to the sales office or service office, is not yet invoiced. In this case, you cannot delete the purchase order line before the sales order or service order is invoiced.
Technology: Using Table Boosters to Speed Up Sessions & Processes
To increase the speed of sessions and processes slowed by large amounts of data, you can use table boosters. These speed up access to specific database tables by loading the table, or a specified part of it, into memory. Table boosters are defined in the Table Boosters (tcmcs0598m000) session.
Tables
Table boosters are implemented for tables. By default, table boosters are not active. When you access a table, LN builds a list of tables for which you can activate the boosters in the Table Boosters (tcmcs0598m000) session.
Note: You can only activate table boosters for tables that have been accessed at least once.
For more information, refer to the LN - Performance, Tracing, and Tuning Guide (U9357).