Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Answered

GP transactions posting error

Posted on by 2,095

Dear All, I am having some transactions, that giving me the below errors during the posting process , also its shown in one report but not in other reports like some times shown in the vendor report but not shown in the transactions report 

what can i do to solve this issue. ? 

Regards

Rashed

  • wperkinson3 Profile Picture
    wperkinson3 728 on at
    RE: GP transactions posting error

    What causes the batch to not have any transactions?  I have several batches that state there is one journal entry.  When I click on "Transactions," there is nothing there as you stated.  I have several of these and I am trying to find the root cause.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP transactions posting error

    Mahmoud, I'm new to GP, just joined a company on GP 2010, and I have come across what appears to be an anomaly with regards to the "no transactions", or at least something that I do not understand.  I have seen your responses on other questions I have so I figured I would address this one to you directly.

    There was a batch of 4 manual checks created in December 2015, but it was incorrectly dated January 2015.  The checks showed up in the bank recon module and have been reconciled, but the transactions have not hit the respective expense accounts nor were the cash transactions posted to the GL.  Now when I review the batch it is showing as "No Transactions".  

    There is a team of bookkeepers here that is very inexperienced in GP and accounting so items of this nature I have found are over their heads.  Further, they do not remember this batch in particular.  Any thoughts on how this could have occurred?  My thought on how to correct it is to post a JE directly to the GL hitting the cash and expense accounts since it has already hit the bank module.  Would you recommend any other way?  

    Thank you in advance

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: GP transactions posting error

    You can directly delete the batches(No transaction)  from Transaction-->Financial-->batches window.

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,736 on at
    RE: GP transactions posting error

    A batch could have a status of "No Transactions", which means that the batch has been created but no transactions at all have been assigned to this batch.

    In order to delete these batches which have "No Transactions", just go to the associated module batch entry window, and simply delete the batch.

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    RE: GP transactions posting error

    Thank you all again for your help, i will try your suggestions tomorrow and get back to you , reference to Mr.AlSaadi observation what i guess is the root cause of this issue some time network dis-connectivity or server down while processing this transactions if i am not mistaken.

    thank you and b. Regards

    Rashed

  • Rashed Alhakimi Profile Picture
    Rashed Alhakimi 2,095 on at
    RE: GP transactions posting error

    Soma

    Thank you for your help , how can i remove this No transaction transaction ? is there a way to get rid of it?

    thank you and B. Regards

    Rashed

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,736 on at
    RE: GP transactions posting error

    Let me get to the root cause of this problem. I can see that you post several batches at a time with several of them having errors, therefore, the posting stops at a certain point and the batch is flagged with "Transaction Error - Edit Required".

    More important than solving those stuck batches is to know why such problems occurs. There could be several reasons for that, such as;

    • Closed fiscal period
    • Incorrect distribution
    • Access on accounts (in case you have account level security activated)
    • Many other reasons.

    The bottom line, what to do to stop the bleeding of such corrupted transactions. You could simply make use of the "Edit-List Posting Reports". To print edit list report, click on the "Printer Icon" either on the transaction or batch level.

    Check the following references to further understand Edit list reports;

     Dynamics GP Batch Edit Lists vs. Bad Data and Stuck Batches

    Hope this helps,

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GP transactions posting error

    Hi,

    you get these errors for the following reasons,

    1 : Incorrect Posting date or Transaction Date

    2 : Incorrect Distributions

    3 : Unbalanced amounts

    4 : if you have installed additional features like Analytical Accounting you have to enter the Analytical information.

    to correct this:

    Note down the batches which has errors,

    then recover the batches from Microsoft Dynamics GP--> Tools --> Routines --> Batch Recovery

    1. Open Transaction --> Financial--> Batches.

    2. Select your batches and click print button in right top corner to view the error list.

    3. Correct the errors printed in step2.

    Regards,

    SantoshG

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: GP transactions posting error

    The cause of the issue (No Transactions), there is no transaction available for those batches in GP.

  • Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: GP transactions posting error

    Use batch Recovery to recover the transaction and then open the batch through Payables Batches.

    Clicking the print icon in the top right of the window will print the Batch Edit List which will show any error messages.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans