Financials

Advance-payment assignment during invoice registration

Typically, advance payments are made to a supplier before the purchase invoice is received. To avoid overpayment of invoices, new functionality has been added to assign advance and unallocated payments to the purchase invoice during invoice registration. Additionally, invoices can now be assigned directly and a separate process is no longer required.

To use this functionality, in the Transaction Entry Defaults (tfgld0131m000) session, a transaction type for advance and unallocated payments must be set up for the user and the Use for Direct Transaction Entry check box must be selected.

In the Purchase Invoice Entry (tfacp2600m000) and Purchase Invoice Inquiry (tfacp2600m100) sessions, the Assign Adv./Unall.Payments command is now available. When you click this command, the Assign Advance/Unallocated Payments to Invoices (tfcmg2131s000) session is started. For the business partner on the invoice header and in the Pay-to field that has a balance, this session lists all advance and unallocated payments. You can automatically assign one or more advance or unallocated payments by selecting the payments and clicking Process.

If manual assignment is required, for example to indicate payment differences or payment discounts outside the thresholds, you can go to the details of the advance or unallocated payment, or use the Assign Invoice to Adv./Unall. Payment command. Both actions start the Assign Unallocated/Advance Payments to Invoices (tfcmg2106s000) session where the manual assignment can be performed.

After an assignment is processed, an assignment document is automatically created for the transaction type that you specified in the Transaction Entry Defaults (tfgld0131m000) session for assigning advance and unallocated payments. The invoice registration can be continued, but after assignment, the header fields Amount, Rate and Currency cannot be changed. To change these fields, you must withdraw previous assignments.

If Segment Reporting is implemented, the assign advance and unallocated payments functionality can be used only if the invoice is segmented. This means that a cost invoice must be fully posted to ledger accounts and dimensions. Order-related invoices must be fully matched and approved.

Cash flow - update of period totals

When multiple users update transactions with the same cash flow reason, locking problems can occur. This is because for each cash flow reason posting, the period totals for that cash flow reason are updated.

To avoid these errors, companies can postpone the update of period totals for cash flow. If the new Postpone Updating Period Totals - Cash Flow parameter is selected in the Group Company Parameters (tfgld0501m000) session, period totals are not updated in the Period Totals - Cash Flow (tfgld219) table during transaction processing. The new Update Period Totals - Cash Flow (tfgld2219m000) session can be run at regular intervals, such as at the end of each month, to calculate these totals for reporting purposes.

Column totals in aging analysis details

When analyzing the aging analysis details of a customer, the totals by aging analysis bucket are now available. In the Aging Analysis Details (tfacr2522m100) session, at the bottom of the Amounts in Aging Currency tab, a line has been added that displays all the column totals.

Consequently, it is no longer required to go to the summary session to view the business partner totals.

Period status by year

The Fiscal Year, Period Type, Period option has been added to the View menu of the Period Status (tfgld0107m000) session. Consequently, you can now change the period status for a specific year or period for all period types.

Reversal date as rate date

For reversal journals in a foreign currency, the rules and regulations regarding the currency rate to be used can be followed more closely. In the Journal Voucher Documents (tfgld0618m000) session, the Use Reversal Date as Rate Date check box has been added for this purpose.

Transaction currency and bank transaction rate checks after finalization

After finalizing a bank statement with payments or receipts, for which the transaction currency differs from the bank currency, you can now check the currency and rate for the transaction.

To support this, the Transaction Currency and Bank Transaction Rate fields have been added to these sessions:

  • Invoice-to Business Partner Open Entries (tfacr2520m000), on the Miscellaneous tab.
  • Invoice-from Business Partner Open Entries (tfacp2520m000) session, on the Miscellaneous tab.
  • Receipt Details (tfacr2524s000) session, on the Bank Details tab.
  • Open Entry (tfacp2100s000) session, on the Payment Data tab.