Project Billing Posted and is in Open but no Distributions, RM Transaction or GL Transaction

(0) Share

Report

Posted on by Community Member

I have looked at the PA Troubleshooting document and nothing helps to resolve this issue. The Project Billing posted and shows in Open tables yet there are no distributions in the Equipment Log or Billing and no RM or GL transaction were create. The All Billing script from the troubleshooting document looks like this the below text. Also, the Troubleshooting Blog entry refers to KB 874076 which shows how to reverse a Billing, but I can't find that KB in the Knowledgebase on Customer/PartnerSource. Any help would be greatly appreciated.

This is on version GP 2013 R2

Project Billing WORK tables
==================================================================================

Project Billing WORK / OPEN tables
==================================================================================

PA11100 - Billing Tax Detail Work/Open
PA11700 - Billing Subline Tax Detail Work/Open

Project Billing WORK / OPEN / HISTORY tables
==================================================================================

PA01901 - Project Key Master
PA11300 - Billing Contract Link Work/Open/History
PA11400 - Billing Project Link Work/Open/History
PA11500 - Billing Contracts Work/Open/History

Project Billing OPEN tables
==================================================================================

PA23100 - Billing Header Open
PA23200 - Billing Detail Open
PA23203 - Billing Detail Open TM
PA05100 - Billing Master Open - Fee

Project Billing HISTORY tables
==================================================================================

Receivables
==================================================================================

RM00401 - RM Key File

GL
==================================================================================

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi,

Have you posted the financial batch in order you to see in GL.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Babu,

As you can see by the script results there are no records in the GL tables and none in the RM tables except RM00401. That said, there are no transactions to post nor have any been posted to the AR or the GL.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Sorry which GL table, are you saying you dont have any batch under Transactions-Financial-Batch start with PA. Have you tried reconcile of RM as well as checklink. Please take a backup before doing this.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Babu,

No data went to GL or RM except a row in the RM00401 RM Key File. There are no transactions in GL or RM. Checklinks was run in AR and GL but if there are no rows in the tables in question checklinks will have nothing to refer to. Checklinks was also run in PA to no avail.

Thanks for your input.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi,

The details about the document is located in this blog post from Pam Peterson :

and the document (word format) can be found on the Partner source here :

[View:https://mbs.microsoft.com/partnersource/northamerica/deployment/documentation/how-to-articles/MDGP_HOWTO_PABilling:750:50]

The blog post has the link also for the Customer Source, so it should be there too..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The document is there that allows you to query information. The KB 874076 referenced in the blog that states a way to reverse a billing is not. The link goes nowhere and when I search the KB in Customer/Partnersource it doesn't come up with results. Does anyone have information on how to reverse a billing? I need to either reverse this one or build the data in GL and RM to accomodate it.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

The document MDGP_HOWTO_PABilling.DOCX that Pam is referring to is actually what I believe to be the KB874076 (without being namely identified)

Did you download yet the document and read thru the 25 pages... There is even a SQL script embedded into the document and lots of other SQL scripts to query and delete data. Plus you'll have to run a few reconciles on PA as well after deleting the faulty data.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I guess I assumed there was another KB based on what Pam said here in a comment to the Blog for The document MDGP_HOWTO_PABilling.DOCX. Thanks for clarifying! None of those scripts actually clean up my transaction. My transaction is in Open status with no pollution of data in Work or History. The only thing wrong with the transaction is that it has no Distributions in PA, no RM invoice or RM data of any kind other than a Key Record, and no GL data of any kind. That results in no updates to the Customer's balance or open transactions and no GL effect.

Here is where I thought Pam was referring to another way to reverse a billing. I thought it was referring to a way to reverse a valid billing transaction and not one that was incomplete. This was her comment to the Blog that introduced the HOWTO doc. I thought they were two separate bodies of info.

Pam Peterson

That is great to hear that it was helpful to you!

KB 874076 provides steps on how to reverse a billing invoice so I would start there. If you need further help, please post your question on the Forums which is an area better suited for troubleshooting. Thanks!

Was this reply helpful? Yes No
Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

I sent Pam a private message to try to get a clear answer about this.

Let's wait and see if she answers that.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi,

I got the answer from Pam and it looks like there is really a KB874076, but the MS search engine seems to be unable to locate it.. Here is the direct link :

874076 How to do credits in Great Plains Project Accounting Billing Entry

support.microsoft.com/.../en-US

Hope this helps.

Was this reply helpful? Yes No