Financials

Additional filter options in mapping scheme for ledger and dimension mapping

Filtering has been added to the From Element and To Element fields in the Mapping by Element Group (tfgld4667m000) session. This enables you to filter on any element value used in that session.

Calculation of currency difference by payment schedule

If a receipt or payment schedule applies to an invoice, the invoice is received or paid in multiple payments, each with its own due date. When reporting open entries to assess risks on current assets and liabilities, these different due dates should be considered. If the invoice is in a foreign currency, then the reports must consider the different due dates when assessing the risk to a company from changes in currency rates.

These changes have been made:

  • In the Write off Currency Differences (tfacr2250m000) and Write of Currency Differences (tfacp2240m000) sessions, the currency differences are now recorded and posted per receipt or payment schedule line instead of per invoice. Existing unrealized currency differences that are posted on invoice level (old situation) are reversed and unrealized currency differences are calculated and posted by receipt/payment schedule line.
  • To view the currency differences by receipt/payment schedule line, fields to display amounts in the home currency have been added to the Receipt Schedules (tfacr1103m000) and Payment Schedules (tfacp1103m000) sessions.
  • On receipt or payment of a schedule line, these situations can apply:
    • For invoices for which currency differences are calculated and posted on schedule line level (new situation), the unrealized currency profit/loss to be reversed and the realized currency profit/loss are determined and posted by the received or paid schedule line.
    • For invoices for which currency differences are calculated and posted on invoice level (old situation), the realized currency differences to be posted and the reversal of the unrealized currency differences are calculated and posted on invoice level.
  • For invoices with schedule lines, the reversal of the unrealized currency differences and the calculation and posting of the realized currency differences, is now performed by receipt schedule line in these sessions:
    • Send Documents to Factor (tfacr2212m000)
    • Write Off Bad Debts (tfacr2255m000)
  • Various print and display sessions, such as the Calculate Aging Analysis (tfacp3525m000) and Print Aging Analysis (tfacr2420m000) sessions now consider the posted currency differences and report the correct amounts in the home currency.

Posting of expense tax to inventory at receipt

To comply with the accounting requirement to have the most accurate inventory value (actual costing) possible, the expense tax can be posted to inventory or WIP when the goods are received in LN CE.

To enable this functionality, select the new At Receipt check box in the Consume Expense Tax in Inventory / WIP group box of the ACP Parameters (tfacp0100m000) session. The existing North American Expense Tax parameter has been renamed to At Invoice Approval and has been placed in the same group box.

When an item with an expense tax code is received, the financial company of the purchase order’s purchase office is used to determine the applicable expense tax parameter.

Now, if the At Receipt check box is selected, the net amount of the receipt is posted, and the expense tax amount. This is done by using the same integration document type (IDT) Purchase order/Receipt as the normal receipt transaction.

The Tax Indicator integration element has been added to distinguish between the net amount and the expense tax amount. If required, this indicator can be used to map expense tax transactions to different ledger accounts or dimensions. This new integration element is set to Not Applicable for normal (net) purchase order and receipt transactions and to Expense for expense tax transactions.

The expense tax amount is calculated from the receipt transaction amount multiplied by the applicable expense tax percentage. In the event of a variance between the calculated expense tax posted at receipt and the actual invoiced expense tax, this variance is posted at invoice approval through the existing Purchase Order/Price Variance IDT.

Expense tax handling at receipt has been implemented in these areas:

  • Purchase order receipts
  • Purchase schedule receipts
  • Supplier stage payments
  • Landed costs on receipts
  • Additional cost transactions
  • Cost to be specified
  • Cost invoices in Financials
  • Freight shipments
  • Freight order clusters
  • All intercompany trade scenarios

For freight shipments and freight order clusters, expense tax at invoice approval can now also be handled.

Purchase invoice matching by packing slip

To support third party Accounts Payable (AP) automation solutions, the packing slip number can now be added to the existing PurchaseInvoice BDE. During purchase invoice processing, this packing slip number is used to correctly match the related receipts.

Note: A BDE (Business Data Entity) is an XML message, like a BOD (Business Object Document). However, instead of using ION as a means of transport from one package to another, a BDE uses web services for communication.

Tax reconciliation

This functionality was initially required for Germany, but has been added to the standard for general use. See Germany.

Withholding tax for received purchase invoices

You can now use withholding tax codes when you set up rules for tax codes in the Received Invoice Rules (tfacp1115m000) session. Consequently, withholding tax codes are automatically assigned to the received tax lines in the Received Purchase invoice (tfacp1610m000) session.