Infor LN & Baan Tips & Tricks for EXECUTIVES

FINANCE: Use of Electronic Bank Statements

All actions required for converting, validating, matching, and posting electronically received bank statements can be performed within a single session:

• Bank Statement Workbench (tfcmg5610m100)
• Bank Statement (tfcmg5610m000)

Alternatively, you can use the sequence of electronic bank statement sessions outlined below.

Steps to Process Electronic Bank Statements:

1. Convert Electronic Bank Statements (tfcmg5202m000)
   Convert the received bank file to a format that LN can process. LN stores the converted bank statement files in the directory specified in the Path For EBS Archive field of the Bank Relations (tfcmg0510m000) session. In the Pathname EBS File field, you must add the file name. To add the current date to the file name, append a tilde (~) to the file name.

2. Validate Bank Statements (tfcmg5202m000 / tfcmg5510m000 / tfcmg5511m000)
   Validate the converted electronic bank statement.

3. Match Bank Statements (tfcmg5210m000)
   Automatically match as many of the imported statements (status Validated) as possible with open items. LN can match the statements with sales invoices, purchase invoices, and anticipated payment documents.

   Matching Options:

   • Match - Surplus on Aging / Unallocated (Default value)
   • Match - Surplus on Unallocated
   • Match - Surplus to be allocated Manually
   • Allow Underpayments
   • Use Payment Difference Tolerance
      

4. Matching Results (tfcmg2500m100)
   Review the results of the matching process.

   To handle an unmatched amount, you can:

   • Manually add an unallocated payment or receipt line.
   • Reconcile the surplus with remaining open entries of the business partner.
      

5. Post Bank Statements (tfcmg5210m100)
   Post the bank transactions to the General Ledger.

   Update the business partner’s bank account number and other details in the Bank Account by Pay-by Business Partner (tccom4115s000) session, based on the details read from the bank statement file.

OPERATIONS: What is Statistical Inventory Control (SIC) and How Does It Work?

Statistical Inventory Control (SIC) is an inventory-controlled order system designed to maintain stock levels based on predefined thresholds, rather than being demand-driven like EP (Enterprise Planning). Since SIC relies on inventory levels, it may lead to higher stock levels. To minimize financial risks, SIC is best suited for:

• Low-cost items.
• Items with predictable demand or short lead times.

Applications of SIC

• Low-Cost Items: Particularly effective for inexpensive goods.
• Predictable Demand or Short Lead Time: Suitable when demand patterns are stable or lead times are minimal.
• Warehouse-Specific Planning: Useful for planning by warehouse rather than across the supply chain.
• Trading Industries: Commonly employed in sectors like supermarkets.
• Immediate Demands: Effective for items required immediately by customers.
• Ease of Use: Simple to implement and manage.

Limitations of SIC

• Does not account for dependent demand from planned orders (e.g., MPS/MRP/INV).
• Does not generate distribution orders.
• Ignores time-phased planned orders.
• Lacks forecast consumption techniques.
• Uses both nettable and non-nettable warehouses.

How SIC Works

SIC operates based on the Reorder Point, Stock Levels, and Order Method.

Triggering SIC

When Economic Stocks (calculated as On-Hand Inventory + On-Order – Allocated Stocks) on the Horizon Date fall below the Reorder Point, SIC triggers the creation of:

• Planned Purchase Advice.
• Planned Production Advice.

Order Methods in SIC

The quantity for these advices is determined by the Order Method, which can be one of the following:

• Replenish to Maximum Stock
• Fixed Order Quantity
• Economic Order Quantity (EOQ)
• Lot-for-Lot

Example: SIC in a Supermarket

Scenario: Managing stock for Ice Cream (1 Kg Pack)

• Current Stock: 10 PCs
• Reorder Point: 5 PCs
• Safety Stock: 2 PCs
• Lead Time: 1 Day
• Order Method: Replenish to Maximum (Maximum Stock: 20 PCs)
• Maximum Anticipated Consumption: 3 PCs/Day

Process:

1. Customer purchases reduce the stock.
2. When stock reaches 5 PCs, SIC is triggered.
3. A Purchase Advice is generated for 15 PCs to replenish stock to the maximum level (20 PCs).
4. During the lead time (1 day), the remaining 3 PCs (excluding Safety Stock) meet customer demands.
5. In emergencies, Safety Stock can also be utilized.

Statistical Inventory Control offers a practical approach for managing inventory levels, particularly in industries with predictable demand or fast-moving items. However, its limitations make it less ideal for complex or time-phased planning scenarios.

TECHNOLOGY: Archiving Data from tipcs300 and ticst300 Tables

1. Archiving tipcs300

• Using Session tipcs2260m000:
  • When archiving PCS projects, selecting the "Archive Financial data" option ensures that:
    • Records in tipcs300 are archived to the archiving company.
    • Records are deleted from the original company.
  • If records remain in tipcs300:
    • They may belong to projects that have not been archived.
    • The project may have been archived without selecting "Archive Financial data."
  • Verify there are no errors during the archiving process.
• Using Session tipcs3500m001:
  • The session "Delete Financial Transactions by Project" can delete records from tipcs300.
  • Note: This session is not for archiving; it removes records without copying them to the archiving company.

2. Archiving ticst300

• Using Session ticst0250m000:
  • The session "Archive Production Orders" allows:
    • Archiving and deleting records from the original company.
    • Only deleting records from the original company.
  • When executed:
    • Records in ticst300 associated with archived orders are removed.
    • Remaining records belong to unarchived orders.

Kathy BartheltKathy Barthelt

Other posts by Kathy Barthelt

Contact author Facebook page Twitter Linked In YouTube Website