Sometimes, due to a clerical error, an invoice has been created and a payment applied to the wrong customer account.
The following are the steps that should be followed in Microsoft Dynamics AX 2012 for the scenario where an invoice was posted to one customer account and you want to move that invoice to a different customer account.
1. Reverse the settlement through Closed transactions editing
• Navigation: Accounts receivable > Common > Customers > Collect > Closed Transaction Editing
• Change “Settlement reversal posting date” to Todays date (this ensures that the reversal isn’t put in a closed period)
• Mark payment and then select reverse
• This transaction can now be seen in settle open transactions editing
• Note: this transaction will also be in the current period
2. Create a customer payment with opposite amount of original payment journal
• Accounts Receivable > Common > Payments > Payment Journal > New Payment Journal
• Create a Journal with an opposite amount. IE, if original was credit make a debit journal
• Post Journal
3. Settle original payment with new payment through Open transaction editing
• Accounts Receivable > Common > Customers > Collect > Settle open Transactions
• Mark original payment and the payment that was just created
• Select update
4. Reverse your invoice
• Accounts receivable > Common > Customers > Customer > Transactions
• Select original transaction
• Click “Reverse Transaction” at the top
• Change “Reverse posting date” to today’s date, add a reason code and hit ok
5. Post Invoice on correct account
6. Post Payment Journal on correct account
Have other Microsoft Dynamics AX inquiries or needs? Visit our Help Desk for AX page to see how our experts can help!
You can also contact Ellipse Solutions, LLC by email at info@ellipsesolutions.com or by calling (937) 312-1547.