web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Negative Transaction, ...
Microsoft Dynamics AX (Archived)

Negative Transaction, unclear why.

(0) ShareShare
ReportReport
Posted on by Rolberto 35

Hello,

We are using Dynamics AX 2012 R3. I see a negative transaction when I filter my customer AR>Common>Customers>Transactions. This customer had a sale and return against it. When I view the journals/vouchers, ledger accounts, everything looks good and balanced. We're not sure why we see this negative. How would you suggest getting rid of it without having to offset it elsewhere? 

Thanks 

Rob Harriman

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Rob,

    Can you share some screenprints of your negative transactions and provide some comments on how you found those transactions, what seems to be wrong, etc.

    Many thanks and best regards,

    Ludwig

  • Rolberto Profile Picture
    Rolberto 35 on at

    Hi Ludwig,

    For some reason I am unable to paste a screenshot? I view the customer transaction by going to their account in AR>All customers, then hit the transaction button at the top.

    In a nutshell there is a credit balance against a customer that is not true. It needs to be cleared without impacting the general ledger/trial balance. The transactions are showing up on an AR aging report however, the trial balance is correct.

    Thanks

    Rob

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Rob,

    You can attach screenprints by saving them and then uploading them through the 'use rich formatting' form that can be accessed by hitting the respective button right below this TextBox.

    About your issue with the cleansing of the customer account:

    As you know you can't only make a posting in the subledger (AR) without hitting GL. To get only the customer Balance cleaned you can however, make use of the following Workaround:

    1. Create a new posting profile with a specific summary account e.g. account 1234

    2. Create a journal where you post the wrong Balance against the account 1234 and the customer.

    - This clears your customer Balance

    - You get a ledger posting but on the same account. The Overall GL effect is thus 0

    - When making this posting you have to ensure that you select the posting Profile Setup in step 1

    - you have to ensure that you can make a Manual posting on the summary correction account 1234 in my example.

    Hope this helps.

    Best regards,

    Ludwig

  • Asif Bhimla Profile Picture
    Asif Bhimla 90 on at

    Hi Rolberto,

    Can you provide steps of how you processed the return?

    thank you

    Asif

  • Rolberto Profile Picture
    Rolberto 35 on at

    Hello Asif,

    I select create Return order against original sales order. Products registered and received back to primary. Return order invoiced and credits account. It is an exact reversal of the sales order and the GL accounts agree.

    Thanks

    Rob

  • Asif Bhimla Profile Picture
    Asif Bhimla 90 on at

    Hi Rolberto,

    When you invoice a returned order, AX creates a negative balance on the customer transaction indicating an amount to be returned to the customer. Typically, this negative balance is settled a payment back to the customer.  

    Has the payment being made to the customer for the returned items? If yes, did you post that payment in AX?

    Asif

  • Rolberto Profile Picture
    Rolberto 35 on at

    Hi Asif,

    The original payment came from an on account pay method. The RMA payment was the same as the on account payment. Everything is posted.  

    Thanks .. Rob

  • Rolberto Profile Picture
    Rolberto 35 on at

    Thank you for all the help. I will post here once we figure it out. I think I may have a solution, fingers crossed. 

  • Verified answer
    Rolberto Profile Picture
    Rolberto 35 on at

    OK So here's how I was able to fix it.

    I created a new sales order using a miscellaneous item number we use to ship a non stocked items.
    I made the dollar value for the item zero.
    I added a negative charge to match the balance in question.
    I used the same pay method as the original sale/rma then submitted the sales order.
    I was able to settle the new transaction against the customer balance.
    I canceled the new sales order.

    Thank you all again for the support.

    Much appreciated.

    Rob

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans