Dynamics Community Forum Thread Details

Project Accounting missing PM expenses

Accounting just realized that some projects are missing transactions that they believe were posted in payables in GP. (transactions are already paid in PM)

The cost category exists for the projects/contracts but reports are showing zero.

Is there any way to backtrack to the PM transaction to see what exactly is missing?

Maybe PO Receipts table?

Categories:

Administration and Setup

Financial Management

Project Accounting

Hello Deanne,

I want to make sure that I understand your issue correctly. Are you stating that there are Payables Management transactions posted only to PM and the GL that should have been Purchase Order Processing Receipts with Project information on them? Or do you have POP Receipts that posted through POP, PM, and the GL that do not have Project information on them that should have?

With both scenarios, the situation remains the same. Unless you know exactly which entries should have been processed with Project Accounting information in the first place, there really isn't a way to tell you that it should have just by looking at the entries.

If this is scenario one, and the Invoices are already paid, and they should have been processed through POP as a Receipt with Project information instead, then you would need to Void the Invoice, which will move the Payment back to Open and make it available to be used again. You can then process a new Shipment/Invoice through POP with the Project Information on it, and then use the Payment to apply to that new Invoice that will show up in Payables Management.

If this was scenario two, and you processed POP entries without Project information on them, you would need to process a POP Return w/Credit entry to return the Invoice and Shipment. This would produce a Credit Memo document in Payables Management, which can then be applied to the new Shipment/Invoice that is created when you re-enter the entry with Project information on it.

Please note the information above is pretty general, and if you have specific questions on transactions, I would recommend opening up a support ticket to work with us further on this. Also, if you do take action on the entries and you are not certain how it will turn out, you can definitely give this a try in a Test company first using the KB article below to create the Test company.

KB - Set up a test company that has a copy of live company data for Microsoft Dynamics GP by using Microsoft SQL Server

Let me know if that helps!

Thank you,

Quick Links

Leaderboard