![]() Have you talked to your GP Partner about this? Unfortunately, without being able to see this in action, I am not sure how much more can be done to troubleshoot it. The fact that you can see it in the sample company with the default checkbooks seems to indicate that it is not your data, but rather something in application and how it is displaying the data. Having multiple users perform bank reconciliations simultaneously is not uncommon and based on my understanding of how GP stores the bank rec transactions, there should never be any cross over like what you’re describing. Since you’re on a version of GP that is no longer supported, you cannot go to Microsoft to ask about this, however, you could try posting this question on the GP community forum to see if anyone else has run into this or has any other ideas.įor what it’s worth, my gut feeling on this is that it is not a bug or known issue, but something specific to your environment/data. I do not have access to a test GP 9.0 environment right now, but I just tested this with GP 2010 and am not able to duplicate this behavior. I hope you can point me in the right direction. Log story short, what tables to I need to look at in order to get this straightened out? I’ve looked at all of the CM tables and cant see what I am missing. However the Adjusted balances are off by the original amounts… Now when I run CL, it puts back in the two transactions with zero dollar. Since then, they have moved on to the next month’s reconcile. This did take it out of reconciliation and after running a checklinks and reconcile, it updated the Adj Book Balance = Adj Bank Balance. Later, I did update other fields in this table to show zero dollars and mark it void. After trying a finance reconcile and running checklinks with no success, I updated the CM20200 table field RECOND = 1 for the two records. However, they are showing up in the bank rec as un-reconciled. ![]() They show as voided in the Checkbook Register and in the Vendor Inquiry. The problem I am having is that two cash payments to vendors were voided. I found this post about the CM tables very helpful, but what I thought I fixed a couple weeks ago with a Bank Rec issue has come back to me! Hi Victoria! I hope you are able to help me. Great information on EFT tables here from Shipli Rao at Encore Business Solutions: EFT Tables Used in Dynamics GP Thank you to Michael Lupro of BestTechsNW and Paul Maynell of Maynell Associates for their help with providing additional information on this page! CM30300 – Receipt History – added in GP 2016 R2ĬMTrxType (Transaction Type) and abbreviation:.CM30200 – Transaction History – added in GP 2016 R2.CM20501 – Reconcile Adjustments – adjustments on current reconciliations.CM20500 – Reconciliation Headers – header information entered during bank reconciliation.CM20400 – Distributions – GL distributions for all bank rec transactions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |