I tested this like 10 times in the test database and all it did was mark
the check box like I wanted so that accounting could manually reconcile
it after that. However when they went to open the Reconcile screen it
was blank not only with nothing checked but no records at all. I went
into the table CM20200 table and they are all still there and I even
tried to set all the fields changed back to what they were and still
does not work. Any suggestions would be great.. GP 8 SP 5
However, if you insist in going down the path you are going, there is a good
reason why your "reconciliation" code is not working. You are missing the
reconciliation header record. IF you go to Transactions > Financial >
Reconcile Bank Statements, the first thing GP asks you to do is to select a
checkbook to reconcile. It then asks you for a Bank Ending Balance, a Bank
Statement Ending Date, and a Cutoff Date. Once you enter this information, it
builds a) a reconciliation header, and b) a number of transactions that fall
within the dates criteria.
Now, matching the transactions via code is the easiest aspect of this whole
thing. How are you going to create the accumulated values based on the
transaction type? These values update the reconciliation header so the user
can figure out what needs to be adjusted. I believe you are underestimating
the work involved in creating a bank rec solution.
Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
You can go through www.nolancomputers.com for complete details.
Thanks
Janakiram M.P.
MCP-GP