Infor LX Tips, Infor LN Tips, BPCS Tips, Baan Tips, Infor M3 Tips & Infor ERP News, Crossroads Connection

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