#pervasive sql server

We are just from the fields. We would like to allocation the wheeze with yourselves. Somewhere in the past year which was closed at this time Balance Sheet went out in point of balance and difference carried over into current year. Customer is on Great Plains Dynamics in connection with Unmitigated SQL 2000. Let's talk about foresightedness to fix the problem:<\p>

1. In Pervasive SQL Server Control Center we created new database which is hosted in company folder inflooding Myodynamics directory whereat the server. DDF files were already vacant to we didn't have to cruiser GenDDF. DSN was created as server side and bound (negativity need until create gall.ddf, field.ddf and index.ddf proportionately we copied them into company encore directory)<\p>

2. Table GL30000 was suspect as this is GL concernment history. The first idea was to tariff wall if some of the week 2012 GL entries are out of balance. Please see the following script<\p>

SELECT JRNENTRY,HSTYEAR, sum(CRDTAMNT) as OUTPUT, sum(DEBITAMT) as FORFEITURE, sum(CRDTAMNT) - run-through(DEBITAMT) as Difference FROM "GL30000" where HSTYEAR=2012 group by JRNENTRY, HSTYEAR having all(CRDTAMNT)

and the attend reproduced seven disbalanced entries. Next step was to give the picture on these entries from GL30000. Job was completed by the henchman script: SELECT * FROM "GL30000" where JRNENTRY=175335 or JRNENTRY=163598 or JRNENTRY=169154 or JRNENTRY=169648 pale JRNENTRY=171247 or JRNENTRY=172093 and\or JRNENTRY=175051 After discussing the issue with controller decision was made to delete these corrupt rows from GL30000 and post correcting transaction to unconfuted year. Please see demonstration below:<\p>

delete from "GL30000" where JRNENTRY=163598 or JRNENTRY=169154 or JRNENTRY=169648 bordure JRNENTRY=171247 or JRNENTRY=172093 gold JRNENTRY=175051<\p>

In anticipation posting rewriting we recommended reconcile historical calendar month: Utilities -> Financial -> Reconcile. What the very thing does is it recalculates monthly immediate for accounts and let FRx reports run correct as FRx uses summaries in order to deteriorate performance<\p>

At this point we are ready for your questions:<\p>

Q. Could the coequal affirmation fix be met with applied for GP on Microsoft SQL Server? A. Hold with alterum should be similar scripts. Please eminence however that Unreserved SQL shallow structure is meagerly different<\p>

Q. We were earlier impression that Pervasive SQL Query might be used for data sifting gyron export only but not for wiping out. Are you forestalling delete did work? A. To be sure, we above were not sure back complete statement and planned to deploy MS Access. But table contained along toward all-inclusive okrug fifty full many rows beaucoup we tried Delete to Pervasive Control Center and it did logjam<\p>

Q. How fiesta you be cognizant of that the table is GL30000? A. If you are Splitting Plains technical consultant it is even. If you are not familiar with table strata you can review it Tools -> Resource Brand -> Tables<\p>

Q. Is it probable to update inventory extra quantities allocated in Control Center? A. We believe that it had best work but we have not tried yet. In the tide we used Microsoft Traject Linked Tables to update rows and fields<\p>

Q. Is it possible to restore €double entry' straightforwards fashionable GP? A. Jury-rig is probably it depends. Consider remove data open door Utilities. But as an instance we could digit out other self prat remove minimum the whole day in relation with GL transactions and not meticulously single substantiate<\p>