Skip to main content

Reverse a Transaction in axapta


You can use the following examples of forms to reverse a transaction:


• Click General Ledger, click Chart of Account details, and click Transactions

• Click Accounts Receivables, then click Customers, and then click Transactions

• Click Accounts Payables, then click Vendor, and then click Transactions


Follow these steps to reverse a transaction at the transaction level.

1. Select the transaction to reverse.

2. Click Reverse transaction.

3. Select the date of posting for the reversal transaction. The date cannot be before the original posting date or in a closed period.

4. Click OK. The transaction itself and all related transactions that were created when the original transaction is posted are reversed.

The results include the following:

• Both new and old reversed transactions now receive a special marking ‘’R(eversed)‘’ allowing you to select these transactions in:

o Reports

o Inquiries

o Periodic jobs

• The ‘’R‘’ marking identifies all transactions settled through reversal and are currently still settled.


Procedure: Revoke a Reversed Transaction

You also can reverse a reversal which involves the following actions:

• Settlements between the original transaction and its reverse are canceled.

• The original transaction is marked as an original transaction.

Follow these steps to reverse a reversal.

1. Follow one of these paths:

o Click General Ledger, then click Chart of Account details, and then select Transactions.

o Click Accounts Receivable, then click Customers, and then click Transactions.

o Click Accounts Payable, then click Vendors, and then click Transactions.

2. Select the reversed or original transaction to revoke the reversed transaction.

3. Click Reverse Transaction.

4. Select the date of posting for the revocation transaction, and then click OK. The reversed transaction and all transactions that you created by using the reversal are revoked, and the revocation transactions share the same trace number.

5. Select a transaction to view all the transactions with the same trace number, and then click Reversed Tracing.

Popular posts from this blog

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole...

Table lists which can have large number of records in Ax 2012

If you are facing database or application performance issue then you can check these tables that may have large number of records. ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTBATCH ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCTMASTERDIMENSIONVALUE ECORESPRODUCT ECORESPRODUCTTRANSLATION ECORESPRODUCT ECORESPRODUCTVARIANTDIMENSIONVALUE INVENTDIMCOMBINATION ECORESRELEASESESSIONPRODUCT ECORESRELEASEPRODUCTLEGALENTITY INVENTSUMLOGTTS INVENTCOSTLISTPARM GENERALJOURNALACCOUNTENTRY GENERALJOURNALACCOUNTENTRYZAKAT_SA SMMTRANSLOG LEDGERENTRYJOURNALIZING DIMENSIONFOCUSBALANCE MARKUPTRANS INVENTTRANSPOSTING INVENTREPORTDIMHISTORY SALESPARMLINE SOURCEDOCUMENTLINE INVENTTRANS TRANSACTIONLOG INVENTTRANSORIGIN INVENTSETTLEMENT SALESPARMSUBTABLE SALESPARMTABLE SOURCEDOCUMENTHEADER SALESPARMUPDATE SQLSYNCINFO GENERALJOURNALENTRY SUBLEDGERVOUCHERGENERALJOURNALENTRY CUSTSETTLEMENT SMMACTIVITYPARENTLINKTABLE INVENTSUMDATETRANS LEDGERTRANSSTATEMENTTMP DIMENSIONFOCUSLE...

Code to get Invoice settlement data for customer in ax 2012

This is simple Code to get Invoice settlement amount data for customer payment in ax 2012. This data is after posting of data. select sum(SettleAmountCur) from custSettlement where custSettlement.TransRecId == custtrans.RecId If you want get settlement amount before posting than you can refer spectrans table.The table SpecTrans contains all the transactions marked for settlement for payment journal. while select spectrans join custtransopen join custtrans where spectrans.SpecCompany == ledgerjournaltrans.DataAreaId && spectrans.SpecTableId == ledgerjournaltrans.TableId && spectrans.SpecRecId == ledgerjournaltrans.RecId && spectrans.RefCompany == custtranssopen.DataAreaId && spectrans.RefTableId == custtranssopen.TableId && spectrans.RefRecId == custtranssopen.RecId && custtransopen.RefRecId == custtrans.RecId && custtransopen.AccountNum == custtrans.AccountNum { info...