Closed customer transaction editing in several currencies (form) [AX 2012]

Updated: February 24, 2011

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click Accounts receivable > Common > Customers > All customers. On the Action Pane, on the Collect tab, click Closed transaction editing.

Use this form to view closed, also called settled, transactions for the customer account that is selected on the All customers list page. You can also reverse a settlement.

When you reverse a closed transaction, the following processes occur:

  • Foreign currency revaluations, penny differences, and cash discounts that are related to the transaction are reversed.

  • Due-to and due-from amounts are reversed, if the settlement includes one or more payments in one legal entity and one or more invoices in another legal entity.

  • A new voucher number is assigned to the transaction.

You can view the result of the transaction reversal in the Settle open transactions form. (Click Accounts receivable > Common > Customers > All customers. On the Action Pane, on the Collect tab, click Settle open transactions.)

NoteNote

If an icon is displayed in the Is marked field, the transaction is already marked for reversal, and it will be reversed when you click Reverse.

The following tables provide descriptions for the controls in this form.

Tab

Description

Overview

View the list of closed transactions for the selected customer account.

General

View additional information about the selected transaction.

Financial dimensions

View information about financial dimensions, such as the default dimensions and where the dimensions are used in account structures and advanced rule structures.

Payment

View details about the payment of the selected transaction.

Settlement

View details about the settlement of the selected transaction.

Collections

View collections status, interest, and collection letter information about the selected transaction.

Button

Description

Reverse

Reverse the settlement of the selected transaction.

Inquiry

Open a menu that contains the following items:

  • Voucher – Open the Voucher transactions form, where you can view ledger transactions for the selected transaction.

  • History – Open the Customer settlement form, where you can view settlement history for the selected transaction.

Field

Description

Settlement reversal posting date

Select how to determine the posting date to use if the settlement reversal creates settlement reversal transactions:

  • Latest date – Use the original settlement date of the most recent transaction that was involved in the settlement.

  • Today's date – Use today's date.

  • Selected date – Use the date that you specify. The date must be the same as, or later than, the date of the most recent transaction that was involved in the settlement. If you select this option, specify the posting date for the selected transactions.

Show

Select one of the following filter settings:

  • All – Display all transactions.

  • Letter of credit – Display only letter of credit transactions.

  • Import collection – Display only import collection transactions.

The default selection is All.

Is marked

If an icon is displayed, the transaction is marked for reversal.

Mark

If this check box selected, the closed transaction will be reversed when you click Reverse. For more information, see Reverse settlements.

Voucher

The voucher number for the ledger transaction.

Account

The customer account that is associated with the transaction.

Company accounts

The legal entity that is associated with the customer account for the transaction.

Date

The posting date of the transaction. This date is often the invoice date.

Due date

The due date of the transaction.

Invoice

The invoice number that the transaction is attached to.

Settled currency

The amount that was settled in the transaction currency.

NoteNote

If the transaction is reversed, this is the amount that is being reopened.

Currency

The currency code for the transaction.

Bank document number

The bank document number for the letter of credit.

Shipment number

The shipment number for the letter of credit.

Cash discount date

The cash discount date for the customer transaction.

Discount used

The cash discount that was received by the customer.

Description

The description for the current transaction. The description can be inserted automatically when invoices are posted, or you can enter it manually before updating.

Transaction type

The transaction type, such as a payment, invoice, or interest note, that is attached to the transaction when it is posted. This is determined by the function that generated the transaction.

Correction

If this check box is selected, the current transaction is a correction of another transaction. Debit amounts are reversed using negative debit amounts and credit amounts are reversed using negative credit amounts. This method of transaction reversal is known as Storno. When credit notes are updated, ledger transactions are debited or credited as reverse entries.

Posting profile

The posting profile that was used for this transaction.

A posting profile can be attached to selected customers, groups of customers, or all customers.

Last foreign currency revaluation adjustment date

The date of the most recent foreign currency revaluation for the transaction.

Last foreign currency revaluation adjustment voucher

The voucher number for the most recent foreign currency revaluation for the current transaction.

Last foreign currency revaluation adjustment rate

The exchange rate for the most recent foreign currency revaluation.

Billing classification

The billing classification that was assigned to the invoice when it was created.

NoteNote

This control is available only if the Public Sector configuration key is selected.

Approved

If this check box is selected, the transaction has been approved. The default value for payments is from the payment journal.

Document

The number of the document that the transaction is based on, such as a bill of exchange.

Document date

The document date for the transaction.

Order account

The order account that is related to the transaction. This might differ from the invoice account that is specified in the Account field.

Tax invoice ID - sales

The identifier for the tax invoice that is generated when value added tax (VAT) is realized. This ID is automatically assigned when the invoice is posted. The ID uses the number sequence that is specified in the General ledger parameters form.

NoteNote

(THA) This control is available only to legal entities whose primary address is in Thailand.

Approved by

The user who approved the transaction.

Financial dimensions

The financial dimensions that were set up in the Financial dimensions form.

Where the %1 dimension is used

The account structures and advanced rule structures that use the financial dimensions that you selected in the Financial dimensions or Default financial dimensions field group.

NoteNote

The name of the field depends on the selection in the Financial dimensions or Default financial dimensions field group.

Method of payment

The method of payment that was used for this customer transaction.

Payment specification

The payment specification for the current method of payment.

Payment

The terms of payment for the transaction.

Payment reference

The reference to a specific payment.

Prepayment journal voucher

Select this control to specify that the payment is a prepayment that was made by using a prepayment journal voucher. For more information about prepayments and the prepayment journal vouchers, see About prepayments and prepayment journal vouchers.

Due date

The date when the payment for the transaction is due. The due date affects the calculation of balances, collection letters, and interest notes.

Canceled payment

If this check box is selected, the payment has been canceled.

Payment ID

The payment identifier that is used when a payment is made.

Central bank purpose code

The code that is used for reporting to the central bank.

Purpose text

The description of the code that is displayed in the report to the central bank.

Payment step identification

The payment step that is currently associated with this transaction.

NoteNote

This field is available only if the Payment management configuration key is selected.

Previous payment step ID

The payment step that was associated with this transaction before it reached the current payment step.

NoteNote

This field is available only if the Payment management configuration key is selected.

Reporting batch

The reporting batch for payment management information.

Bill ID

A unique identifier for bills of exchange that is used when bills of exchange are created.

NoteNote

This field is available only if the Bill of exchange configuration key is selected.

Sequence number

Displays 1 for the first cycle of a bill of exchange and 2 for the first redraw action.

NoteNote

This field is available only if the Negotiable instrument configuration key is selected.

Status

The status of the bill of exchange:

  • None

  • Drawn

  • Remitted

  • Protested

  • Redrawn

  • Honored

NoteNote

This field is available only if the Negotiable instrument configuration key is selected.

Remittance number

A unique identifier for a remittance file.

NoteNote

This field is available only if the Bill of exchange configuration key is selected.

Currency

The currency code for the transaction currency.

Settled currency

The settled part of the amount in the transaction currency.

Amount settled

The amount that was settled in the accounting currency.

Exchange rate adjustment amount

The amount of the foreign currency revaluation in the accounting currency.

NoteNote

Information is displayed in this field only if invoicing was done in a foreign currency, and if a foreign currency revaluation was performed between the time of invoicing and the time of payment.

Settled currency

The settled part of the amount in the transaction currency.

Amount settled

The settled part of the amount in the accounting currency. This includes any foreign currency revaluations and penny differences.

Last settlement voucher

The voucher number for the most recent settlement.

Last settlement voucher account number

The account number for the most recent settlement.

Last settlement voucher company account

The legal entity for the most recent settlement.

Last settlement

The date of the most recent settlement.

Settlement

If this check box is selected, the transaction is settled.

You can click Reverse to change the settlement. For more information, see Reverse settlements.

Closed date

If the transaction has been settled, the date for the full settlement is displayed. This date corresponds to the transaction date of the final settlement. If the field is empty, the transaction has not yet been fully settled.

For example, if a prepayment journal voucher that was posted on January 1 is settled against an invoice that was posted on February 1, the invoice date is displayed.

Close

The posting profile that is used when closing the transaction.

Interest note

The interest note number for the most recent interest calculation for the transaction.

Date

The transaction date for the interest note.

Interest date

The date of the most recent interest calculation for the transaction.

Collection letter

The current collection letter number for the transaction.

Date

The date of the most recent collection letter for the transaction.

Collection letter code

The current collection letter code for the transaction.

Collections status

The status of the transaction in the collections process. For more information, see Collections (form).

Reason code

The reason code for the current collections status. The reason code is selected when the collections status is changed in the Collections form.

Reason comment

The reason comment for the current collections status. The reason comment is entered when the collections status is changed in the Collections form.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

Show: