New April Hotfix and more changes for VAT
Check out the latest updates to Microsoft Dynamics GP 2016 and 2018.
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
Is there a way to add a GL Account to a posted transaction so the books will balance?
This should never happen under normal circumstances. Did you have an interruption during posting?
I under stand that there are safeties in place to keep this from happening. but for what ever reason they failed. Accounting did not mention any abnormal behavior.
So Is there a way to correct this?
Not through native GP. You will need to use SSMS and create a query. I would delete this bogus J/E and then enter the correct one using GP. When done run Financial->Reconcile. Also do a backup before doing any back-end corrections. You could post to a suspense account but that will leave a hanging chad.
That is what I was worried about though I am comfortable with SSMS, do you have any direction as to the tables I would need to alter to make this right?
You can do this one of two ways. if you know the J/E that is wrong you can correct it or delete it and enter a correcting entry. The table you need to correct is GL20000. Make sure you perform a backup before doing this. After doing this run GL reconcile.
OK thank you i will do this and let you know how it goes.
What columns do I need to change the only one that seems amiss is ACTINDX. So in the test company i changed it to the same number as the other line items then ran check links and reconcile but that did not seem to change anything.
If you have an unbalanced entry then you are going to need to add a record. ACTINDX is the value you need to match to the account number that is missing. GL Reconcile will find this new distribution and adjust the summary tables for this account. So you will add a new record into the GL20000 table linked on the journal entry number. The dollar value will go into either the DEBITAMT or CRDTAMNT column.
The row already exist though, so do I need to delete it first then insert the new row? I am just a little lost feels like I am doing then undoing if I follow this.
Every journal entry will consist of at least two records with the sum of the debits equally the sum of the credits. If you have an unbalanced entry there is either a record missing or a debit or credit amount is wrong. Can you paste the results of this script in your reply?
WHERE JRNENTRY=##### -- Where #### is the journal entry in question.
JRNENTRY DEBITAMT CRDTAMNT
86477 0.00000 54.00000
86477 54.00000 0.00000
Based on this, and not to jump on your answer Richard, but there is nothing wrong with this entry. When you first said account missing, I know I would expect to see in the above example 3 lines -
86477 1 dollar amount
86477 2 dollar amount
86477 MISSING dollar amount
This is the picture I got - did I miss read this. If you are saying that the account was not entered when the JE was first created, that I think is a different matter. But again, if I read this wrong - sorry for butting in - but I was just reading and was interested.
I understand why you would think that but it is actually in the sales "receivables Distribution inquiry Zoom" window on one of my Document lines is missing the account.
If possible, please clip a picture and post
Like Richard I am not clear on how this might have happened, but based on what you entered on the screen, it is a balanced entry and therefore is not 'bad' in the strictest sense of the word.
Could this be a matter of an account that did not have any dollar value required and was left blank - and therefore did not post?
From the information I see - it is balanced and I am not clear on what you mean 'so the books will balance'
Did I miss something.?
It is posted and that is the issue. That it is posted but not to a specific account
Business Applications communities