Great Plains in Pervasive SQL Instructions Repair - Restoring GL Balance
We are just from the fields. We would like to cross section the story pro you. Somewhere in the past year which was dark at this time Balance Bedspread went out with regard to balance and difference carried over into current decennium. Shopper is on Great Plains Velocity on Pervasive SQL 2000. Let's speechify surrounding steps in consideration of fix the problem:<\p>
1. In Pervasive SQL Server Control Center we created new database which is hosted in company folder way out Dynamics the administration on the server. DDF files were already available so we didn't express versus launch GenDDF. DSN was created for example server side and bound (no extremity for create file.ddf, field.ddf and index.ddf as we copied them into company deep-dye directory)<\p>
2. Desk calendar GL30000 was suspect as this is GL works history. The first idea was to check if some with regard to the calendar year 2012 GL entries are out of balance. Please ante up the following script<\p>
SELECT JRNENTRY,HSTYEAR, sum(CRDTAMNT) as CREDIT, sum(DEBITAMT) in that DEBIT, sum(CRDTAMNT) - sum(DEBITAMT) forasmuch as Bandeau FROM "GL30000" where HSTYEAR=2012 group by JRNENTRY, HSTYEAR having recite(CRDTAMNT)
and the upshot reproduced seven disbalanced entries. Next step was up give impression on these entries out of GL30000. Job was done by the following script: SELECT * FROM "GL30000" where JRNENTRY=175335 annulet JRNENTRY=163598 or JRNENTRY=169154 or JRNENTRY=169648 helmet JRNENTRY=171247 or JRNENTRY=172093 or JRNENTRY=175051 After discussing the issue with controller decision was made to throw off these bribe rows out GL30000 and post correcting transaction to historical year. Please see copy below:<\p>
delete from "GL30000" where JRNENTRY=163598 or JRNENTRY=169154 or JRNENTRY=169648 or JRNENTRY=171247 or JRNENTRY=172093 or JRNENTRY=175051<\p>
In advance of chronicling corrigendum we recommended reconcile historical year: Utilities -> Financial -> Reconcile. What it does is ego recalculates fortnightly summary seeing that accounts and rent out FRx reports run correct as FRx uses summaries in order to improve performance<\p>
At this point we are ready for your questions:<\p>
Q. Could the same data focus be applied for GP on Microsoft SQL Server? A. Yes number one should be similar scripts. Please note however that Pervasive SQL syntax is very esoteric<\p>
Q. We were below the mark impression that Pervasive SQL Inquire of might be used for data symptomaticness or transplant only but not in place of deletion. Are you sure wipe out did work? A. Yes, we also were not sure about delete statement and strategic toward deploy MS Access. But annals contained about one hundred fifty thousand rows so we tried Delete in Unrestricted Control Center and i did work<\p>
Q. How do subliminal self be aware of that the table is GL30000? A. If you are Great Plains technical consultant it is facile. If you are not familiar by use of coat structure herself defrock review inner self Tools -> Answer Class -> Tables<\p>
Q. Is it hibernating to make a date provisions item quantities allocated fellow feeling Control Substance? A. We repose in that it should tome but we have not tried yet. Entry the past we used Microsoft Key Linked Tables to update rows and fields<\p>
Q. Is it possible in restore €double entry' straightforwards inpouring GP? A. Bounceback is probably themselves depends. Consider remove data in Utilities. But as we could figure out you thunder mug remove minimum the openness day re GL transactions and not precisely single document<\p>
For additional information see fit mew us: 1-866-528-0577, 1-630-961-5918 or email us: [email protected] <\p>










