Question Status

Suggested Answer
l-thomas asked a question on 26 Mar 2011 11:41 PM

Please help, I dont understand why Great Plains is doing this. The PAY GL Account code is "doubling up" sometimes "tripling up". Below is the steps I'm following:

  1. Enter the supplier invoice in the Payable transaction entry window
  2. Proceed to the Payables Transaction Distribution entry window
  3. Enter the GL account code for PURCH
  4. Click Ok
  5. Click Save

This is where the problem begins. I get the error message "This transaction will not post; it includes distributions with errors. Do you want to save it with errors?". When you click Save and check the Edit list for the transaction, it clearly shows that the problem exists in the distributions. Sometimes the Accounts Payable value is double/ sometimes trip the amount of the PURCH account.

I'm also using AA. When the PURCH GL account code is entered the AA distribution window is not opening so I cannot enter my dimension code.

How do I set this right? Please help!!!!!!!!!!!!!

 

 

  

Reply
Suggested Answer
l-thomas responded on 27 Mar 2011 5:57 AM

I solved the problem but I thought I'd let everybody know how I did it.

Incredulously, I had to unlink and then re-link the GL account codes to the AA Class ID. I dont understand the relation at all but it fixed the problem for now. I'm still not able to add a new Account Class ID but this is another problem with AA.

If anyone can share some light as to what's the relation, I'd appreciate it.

Thanks in advance!

Reply
Mike McElhaney responded on 12 Feb 2012 9:25 PM

I actually used the script from this KB article 897280 to fix it without having to do it all manually.  This post did help get me in the right direction though.. thanks!

mbs2.microsoft.com/.../KBDisplay.aspx

Reply
Bab responded on 18 Sep 2012 9:12 AM

Mike, can you proivde the script in here?.

I am having the same issue like I-thomas and i dont feel comforatble with unlinking the GL account. I would like to try this script but i do not have access to the link you provided?

Reply
Suggested Answer
l-thomas responded on 27 Mar 2011 5:57 AM

I solved the problem but I thought I'd let everybody know how I did it.

Incredulously, I had to unlink and then re-link the GL account codes to the AA Class ID. I dont understand the relation at all but it fixed the problem for now. I'm still not able to add a new Account Class ID but this is another problem with AA.

If anyone can share some light as to what's the relation, I'd appreciate it.

Thanks in advance!

Reply