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.