Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / AR Edit list error
Finance | Project Operations, Human Resources, ...
Unanswered

AR Edit list error

(0) ShareShare
ReportReport
Posted on by KE AMHS

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:
Microsoft Dynamics GP
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,280 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... 291,280 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans