Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

AR Edit list error

Posted on by

Good morning!

I have a recurring AR batch for monthly rents and a recurring batch for monthly rent deposits.  The monthly rents are posted on the first of the month and the deposits are applied to the rents and then posted on the second of the month. This month on the Cash Receipts Edit List, two of the deposits showed a different amount when applied to the rent.  For example, the Credit Amount was $500 and the Amount Applied showed $400. Yet when you go into the Transactions by Customer it shows the proper amounts - $500 rent and $500 paid (WORK as it's not posted yet) with no balance owing.  This issue was tried in PreProd and when posted it went through properly with the full $500 being applied but I am hesitant about posting it for real - what other errors is that creating??

Has anyone else had this issue?  Any suggestions?  

Many thanks,

Kelly

Categories:
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,554 Super User 2024 Season 2 on at
    RE: AR Edit list error

    Hi Kelly,

    We will soon move this question to the Dynamics GP forum for you.

    community.dynamics.com/.../microsoft-dynamics-gp-forum

  • David Bader Profile Picture
    David Bader on at
    RE: AR Edit list error

    Hi Kelly,

    It appears that you are working in Dynamics GP and you logged this issue to the Dynamics 365 for Finance and Operations Forum.

    If this issue should re-occur please log a new inquiry to the Dynamics GP Forum.

    Have a great day!

  • KE AMHS Profile Picture
    KE AMHS on at
    RE: AR Edit list error

    Good morning!

    I have the batches in the Sales module in GP. Currently I have a recurring Monthly Rent batch and a recurring Monthly Deposit batch (it was this batch that had the problem). 

    I contacted CCIM to have the problem diagnosed and they are the ones who processed the batch in preprod to see if it would post properly and it did.  They gave us options such as deleting the batch and re-entering it, posting it as-is (seeing as when they did it in preprod it processed with the proper amounts), or to send the issue to Microsoft where it would probably take several weeks to get a response.  

    I discussed it with my finance team and we decided to delete the recurring batch that was having the issue and re-entering it. It has no issues and the edit list is perfect. I will make it a recurring batch again and see if it develops the same issues over time (I had posted that recurring batch about 10 times). CCIM said the recurring batch may have developed this error somehow and that it shouldn't do it again... we'll see.

    I will respond in this forum again if we develop the issue again but it looks like the issue has been resolved.

    Thank you and have a great day!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,554 Super User 2024 Season 2 on at
    RE: AR Edit list error

    Hi Kelly,

    Are you using general journals or do you have a customization for the rent and rent deposits?

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,554 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,588 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans