Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2013 Project Billings don't show in Apply Sales Documents when entering Cash Receipt

Posted on by Microsoft Employee

We are testing an upgrade from GP 2010 R2 to GP 2013.  We have multiple databases and all have an issue with open project invoices not showing in the Apply Sales Documents window.  All other invoices from SOP and AR show up but Project Invoices do not.  If you post the Cash Receipt without applying it and then go to the Apply Sales Documents screen after posting they show up.  This was not an issue with GP 2010.  Does anyone know of a fix for this?

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: GP 2013 Project Billings don't show in Apply Sales Documents when entering Cash Receipt

    So it has been another 10 days and not a single reply to this posting from anyone at Microsoft.

    In the meantime the SQL Job solution has been implemented and seems to be working.

    Shame that Microsoft does not care enough to even comment on these issues related to the Canadian Payroll.  But, as we know, why should they spend anytime developing something that is considered a waste of time.  Has anyone noticed that Payroll gets no attention except when they are looking for a reason to 'sell' annual maintenance plans.

    Just a little bit tired of the 'we are microsoft and we do what we want' attitude.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: GP 2013 Project Billings don't show in Apply Sales Documents when entering Cash Receipt

    I am amazed that Microsoft has not commented on this matter - it is not just Project Accounting users, it appears that almost all 3rd party applications - not core Microsoft Dynamics GP - pushing to AR is generating this problem.

    Is it possible then that this an ISV matter?

    I question only because the silence from Microsoft on this matter is deafening.

  • Tracey Brinkman Profile Picture
    Tracey Brinkman 5 on at
    RE: GP 2013 Project Billings don't show in Apply Sales Documents when entering Cash Receipt

    We have a customer that we just upgraded to GP 2013. They do not use Project Accounting, however they use WennSoft Job Cost. They are running into this same issue. Has this issue ever been resolved? I have not been able to find anything that makes me believe it has.

  • RE: GP 2013 Project Billings don't show in Apply Sales Documents when entering Cash Receipt

    Does anyone know if this is resolved? I am experiencing the same symptoms in GP 2013 on invoices imported via e-connect.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP 2013 Project Billings don't show in Apply Sales Documents when entering Cash Receipt

    Thanks for the information.  I'll give it a try.  FYI.  We have SP2 installed and it is still not resolved, although SP2 was installed after doing the upgrade to SP1.  Not sure if that would be an issue.  We can retest the upgrade straight to SP 2 and see if that resolves it.  Thanks again!

  • Suggested answer
    RE: GP 2013 Project Billings don't show in Apply Sales Documents when entering Cash Receipt

    I saw the same thing after we upgraded a client last May.  We ended up doing a service request with Microsoft.  Their response is below.  They did not charge us for the support incident, since it was a known bug.  We ended up installing multicurrency with check links on multicurrency setup.  However, I would recommend just installing SP2, since it was supposed to be fixed in that update.

    From Support Ticket:

    I am providing you a copy of our scope agreement for your issue.

    Issue Definition: I understand that you are not seeing your Project Accounting billing invoices in the Apply Sales Document window that you access from the Cash Receipts window. Instead you have to find the document using the Apply Sales Document window under the Transactions menu.

    Scope Agreement: The scope of this case is to determine why you are not able to access your Project billing invoices via the Apply Sales Document window under Cash Receipts Entry.

    Assessment: Can you verify if you are Registered for Multicurrency? (Microsoft Dynamics GP menu >> Tools >> Setup >> System >> Registration). If you are not registered for Multicurrency it looks like you are running into bug PR68110

    For a workaround you can do either of the following:

    Post the cash receipt first, and then apply

    or

    Run an update statement on the RM20101 (Open Trx) table to remove the currency information.  In mine my currency is Z-US$.  Yours might be different.

    Update RM20101 set CURNCYID = '' where CURNCYID = 'Z-US$' and DOCNUMBR='enter the billing document number'

    Plan: As of right now this is set to be fixed in GP 2013 SP2. I do not have a set date on when this will be released yet. I will make sure you are not charged for this case.

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans