web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Lost unposted patch t...
Microsoft Dynamics GP (Archived)

Lost unposted patch transactions

(0) ShareShare
ReportReport
Posted on by Community Member

Lost unposted patch

Hi, I created a patch in 26 march, it was 50 line and every day I was adding more lines to post it at the end of the month. Today i was trying to open the patch but there is a message says there is no transactions. What is that mean?! Should I record all lines again ?! Please advise

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    First I'd run check links on the unposted transactions. If it's GL, I'd also reconcile batches. Go to Financial | Utilities | Reconcile and then choose Batches. For Check Links use Financial and select the Transaction Work logical file. If it still does not show up, look in SQL and check out the entries in the GL10000 and GL10001. Also check the GL20000 to make sure it wasn't posted by mistake. If you still can't find it, you can either re-enter it in the GL Entry screen, or put it in an Excel spreadsheet and past it into the GL Entry Screen.

    Kind regards,

    Leslie

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Leslie, bit of an off shoot question - I have an error that says an account is part of an unposted transaction and therefore I can not delete the account.  The account is marked in Finance as Inactive.

    I have searched Gl10100 - GL10000 - GL10001 - nothing

    I have run all the Batch Reconciles in Finance

    This client has payables and GL only - simple installation

    Question: Where else to look for this transaction?

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    At this point I'd search the entire database for the Account Index number that is attached to that account. Sometimes you've got to pull out the big guns. Once the query finishes, it should be pretty easy to eliminate random occurrences of the number by the name of the column the value was found in.

    Good luck!

    Leslie 

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Ok it is Friday and I am beat - I am not sure I know where to go to pull out the big guns, but being from Texas I am sure you have the answer Val.  

    This client uses the GL and Payables only - no inventory, nothing else.

    I have looked in the PM Work tables ( I think ) as well as the GL Work - nothing.

    I did a full reconcile of GL and removed an number of JE records from the GL tables that had no batch details, but that did not change much.

    Any assistance would be great

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Bill,

    I'm guessing if that account is out in some transaction somewhere, I would search the database for the account index. The search for a number will most likely return results that do not have anything to do with your query, but you should be able to tell if it's relevant by looking at the table and field value of the hits. If you see something in a 10 or 20 thousands file, I'd investigate. It may say 'unposted', but I have found that error message before on things that were in a work table. Depending on the size of the database, this query could take a long time to run, but sometimes it just needs to work :).

    If you do not have a SQL search tool, you can download a FREE one from APEXSQL.com.

    Kind regards,

    Leslie

  • L Vail Profile Picture
    L Vail 65,271 on at

    Bill,

    Is this account in a budget? I would remove it if it is.

    Leslie

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    I was thinking about that ( budget ) but wondering how far back - this company seems to have kept all the budget import templates ever made - not tossing anyone - list goes back 10 years - crazy.

    But I will be looking here.

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

    Just a final follow up  to not my posted question - but - if an account is referenced in History ( at any time ) I am thinking you can not remove the account from the GL00100 or anywhere for that matter - would that not break something in the Payables for example?

    Just thinking out loud to my own question.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans