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 GP (Archived) / Zero dollar Project Ac...
Microsoft Dynamics GP (Archived)

Zero dollar Project Accounting invoices do not go to AR when posted alone.

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,788 Moderator

Can anyone confirm that if you post zero dollar project accounting billing invoices alone in a batch that no record will be written to the RM20101 table? We have a client who we have written an SSRS report that uses the RM20101 table. They were curious as to why some zero dollar invoices appeared and other did not appear. We have tracked this down to the fact that when these zero dollar invoices are in a billing batch with other non-zero dollar invoices a record does get written to the RM20101 table. However, if a zero dollar PA billing invoice sits in a batch by itself and that batch is posted, no record is written to the RM20101 table. This is GP 2013.

*This post is locked for comments

  • Rennecia Barran Profile Picture
    Rennecia Barran on at
    RE: Zero dollar Project Accounting invoices do not go to AR when posted alone.

    Hi, I currently have the same issue as you Richard, for GP 18.3 though, a particular zero dollar invoice is in project but not AR. 

    I know this is an old post, what did you do?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Zero dollar Project Accounting invoices do not go to AR when posted alone.

    Misery loves company. If it were not for our report I never would have noticed this. Let me know what you find out on your end. I stated our case from this side and there is not much I can add.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Zero dollar Project Accounting invoices do not go to AR when posted alone.

    Hi Richard.  Ironically I had a similar issue come up today with a client.  They are having issues with running the Cycle Biller and zero dollar PA invoices posting to RM but not to the GL.  Also, the zero invoices sit in the Time and Materials Billing window and even if they bill them they never clear out.  Maybe we can collaborate together on these issues?  I know PA pretty well but I may open a MBS case to sort it out quicker.  

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,309 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans