Closed customer transaction editing in several currencies (form)

Article
05/05/2014

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

Note

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.

Tasks that use this form

Reverse settlements

Key tasks: Letter of credit for the export of goods

Key tasks: Letter of credit or import collection for the import of items

Navigating the form

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

Tabs

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.

Buttons

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.

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.

Fields

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. Note 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. Note 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. Note (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. Note 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. Note 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. Note 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. Note 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. Note 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 Note This field is available only if the Negotiable instrument configuration key is selected.
Remittance number	A unique identifier for a remittance file. Note 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. Note 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.