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:

OPERATIONS: Update, Cancel or Remove Outbound Order Lines

FINANCE: Currency Differences Accounts

TECHNOLOGY: Advantages of Data Replication

Instead of sharing tables through logical linking, you can replicate table content between companies. This approach allows certain non-key attributes of a record to vary by company. For example, if you replicate bills of materials rather than sharing them, each company can associate a different warehouse with the same bill of material. This way, the bills of materials are consistent across companies, while the warehouses can differ.

Replication also enables selective availability of records in other companies. For instance, when replicating items, you might limit which items are available in a sales company based on their item group, only including end items. You can further refine replication to specific subsets, such as particular item groups.

Keep in mind that replication requires any referenced tables to be either replicated or shared as well.

Currency differences can make the financial analysis and reconciliation more complex. These types of currency differences can occur:

• Currency differences
  Currency result caused by fluctuations in the exchange rate, for example, if the rate differs between the invoice date and the payment date.

• Exchange gain and loss
  Currency result caused by the use of different exchange rate types, for example, the Sales rate type and the Internal rate type, or if using the rate determiner you have changed the exchange rate for a transaction during the order handling procedure.

• Translation gain and loss
  Currency result caused by the use of different currencies during the order handling procedure, for example, if the order currency or the payment currency differs from the invoice currency.

• Destination gain and loss
  Currency result caused by different results when the transaction currency is converted to the various home currencies. Destination gain and loss can only occur in an independent currency system.

To support good reconciliation possibilities, currency differences and exchange gain and loss are posted to these accounts:

When the originating order or order line of an outbound order line is canceled or changed, this affects the outbound order line and may affect the related outbound advice, shipments, or shipment lines.

For most order origins, warehousing order-type parameters determine whether these actions are allowed:

• Update the outbound order line if the originating order is changed.
• Cancel the originating order line and the outbound order line.
• Delete the canceled outbound order line.

If updating is allowed...

Table Timestamp Definitions (ttadv4136m000)

Use this session to define timestamps for Infor LN tables. A timestamp is an additional column that stores the date and time of the last change for each record.

Timestamps are utilized by features like the extraction logic of CPM Enterprise Analytics. They enable CPM to perform incremental data extractions. For example, CPM can use the timestamps to extract records that were changed during the last week in a weekly extraction process.

To Create Timestamps...

Operations: To absorb the cost of cost items into specific projects, you'll need to handle them as customized items. However, cost items cannot directly be defined as customized items. Customized items must be physical, either manufactured or purchased.

That said, it's still possible to absorb cost items into a project, although indirectly. Here's how:

1. Set Up Ledger Account: First, create a new ledger account in session tfgld0508m000 and set the type to "PCS" (project) in the operations management integrations. This account will be used for matching and approving purchase orders for cost items.

2. Create and Activate Projects: Ensure that the necessary projects are created and set to active status.

3. Purchasing Cost Items...

FINANCE
Ledger Account Blocked Error

OPERATIONS
Absorbing Cost Items into Projects

TECHNOLOGY
Adding a Timestamp to LN Standard Tables