DATA MIRROR FOR PT User Manual
Contents
1. 3 MirrorControl Class The MirrorControl is a NET native class that provides the interface to the Data Mirror for PT allowing you to completely control the mirroring process The class should be referenced in NET applications that you develop Sample code in this section will be for VB NET However the code is very straightforward so translation to other languages such as C NET should be fairly obvious Since the MirrorControl class contains events you can refer to the MirrorControl as follows Dim WithEvents oControl As New DataMirrorForPT MirrorControl 3 1 Methods ClearALLPTData Deletes all Peachtree data from the SQL Server tables Example oControl ClearAllPTData Connect DataSource InitialCatalog Username Password Instruct the MirrorControl to make a connection to the specified SQL Server database The parameters are optional DataSource The name or network address of a SQL Server to which you want to connect If no value is specified ASQLEXPRESS is used InitialCatalog The name of the database to which you want to connect If no value is specified DataMirrorForPT is used Username The User ID you want to connect to the database with Password The password you want to connect to the database with A username and password are required if the database has been secured By default the generic DataMirror database does not require a username or password If you need to specify a username and2. Diagnostics will enable additional logging of diagnostics Un checking Log Diagnostics will disable additional logging When the Enable File Mirror box is checked Peachtree data files will be copied to a local mirror folder before they are read If the box is not checked then the Peachtree data files will be read from their original location where Peachtree is using the data Copying the files to a local folder eliminates interference from Peachtree and network access issues when reading the files However there may be situations where you want to access the Peachtree files in their original location The default is FALSE or disabled The Timer Interval in ms Value represents the period of time the application pauses in the main control loop that performs operations The default value is 500 ms You can 10 probably change this to 100 ms if you want to see faster response to events in applications that call the library but you may see some degradation in system performance if you make this value too small The Delay Count is the number of seconds that the application waits after the last file has been modified before reading data from the Peachtree files The default value is 10 The reason this value is so large is because Peachtree typically modifies files for a period of 15 20 seconds after a change has been made on one of the Peachtree forms The File Mirror Path is the local location where Peachtree data files are copied when the Enable
3. File Mirror box is checked The data on this form is stored in the SQL Server table DataToMirror If you do not want to display the form above in your application you can edit the SQL Server table directly as desired StartMirroring Inform the library to start the mirroring process Example oControl StartMirroring Stop Mirroring Inform the library to stop the mirroring process Example oControl StopMirroring 3 2 Properties CompanyName Return the currently selected Peachtree company name Readonly CompanyPath Return the currently selected Peachtree company s directory path Readonly ConnectionString Return the SQL Server connection string that is currently in effect Readonly Initialized Return a Boolean value indicating whether a successful connection to a SQL Server database has been performed yet Readonly Password Specify a password to use for the SQL Server connection string If the database is secured the password can either be specified with this property before calling the Connect 11 method or the password can be specified as a parameter for the Connect method Writeonly TimerEnabled Return or set a Boolean value specifying whether the library internal timer for mirroring is running Timerinterval Return or set the timer interval in ms of the library internal timer for mirroring Username Specify a User ID to use for the SQL Server connection string If the database is secured th
4. Native Moma aem 1 Select or enter a server name Client 10 0 ASQLEXPRESS y Refresh 2 Enter infomation to log on to the server 1 If the server drop down does not Ce Wiodows NT kiegeiod pocut populate click refresh then select a Server SN SQL Server instance F e a apie a ee Iie peel oe Username 2 Set your authentication method emal ae The default is Windows F Bleni a Fa 7 7 M Hank passwor Aow sayma passwort Authentication but you can use SQL ATRA al 3 Select the database DataMimorForPT y authentication if you choose Attach a database file as a database name 3 Select the database Using the filename DataMirrorforPT Then click test AAA connection You may need to create a an empty version of the Erana Rasis DataMirrorforPT database using SQL Management Studio 17 SQL Authentication If you choose to use SQL authentication then you will need a user name amp password set up using SQL Management Studio Select the Security node then Logins Create a new login or use an existing login Then in the login properties select User Mapping Check the highlighted items Server MXQ_001 SGLEXPRESS2008R2 Connection MXQ_001 Bary G Hynum View connection properties 18 Expand the database node then right click DataMirrorforPT to expose the properties Select the Permissions node On the Explicit tab check grant Connect amp Execute Database
5. Peachtree The LastUpdatedTime is the date and time the records in the file were written to the SQL Server database The LastFileMirrorTime is the date and time that the file was last copied to the local mirror folder For all three fields a value of 1 1 1900 indicates the date and time have not changed since the last time the entire database was read either because ReadAllPTData was called or because the Peachtree company was changed Notice that AuditTr DAT is unchecked The application will read new audit trail records anyway but this will prevent the application from reading old audit trail records since the number of old records in the Audit Trail file can be very large and are not of any interest unless you specifically want to examine the audit trail Example oControl ShowDataToMirror The data on this form is stored in the SQL Server table r DataToMirror If you do not want to display the form above in your application you can edit the SQL Server table directly as desired ShowOptionalData Display a form that lets you select some optional data to copy from the Peachtree database to the SQL Server database The items on this form all have a fair amount of additional overhead associated with reading the information so performance can be improved if you only select optional data that you need By default all optional data is read The Start period for journal data value lets you specify the internal period at which the application
6. application optionally copies the appropriate files to a local directory then reads the modified records and updates the SOL Server tables accordingly Copying the modified files to a local directory insures that the application can access the data quickly without any interference from Peachtree Previous experience has shown when Peachtree is being used on several workstations that attempts to read the direct data files from an external application can be extremely slow because Peachtree is tying up essential resources for its own use Also reading Peachtree data across a network can be much slower than reading the data from a local directory The Data Mirror for PT includes an application DisplayMirroredData that illustrates all the features of the library and allows you to control mirroring and to view the contents of the SQL Server database VB NET source code for this application is provided 2 Prerequisites Data Mirror for PT supports Peachtree 2005 and later Data Mirror for PT requires that a SQL Server 2005 or 2008 version be installed Fortunately Microsoft provides a free Express version of SQL Server that you can download and install To download SQL Server 2008 Express go to http www microsoft com exPress download We recommend you download the Runtime with Management Tools or the Runtime with Advanced Tools rather than just the Runtime version as the Management Studio is very useful for managing and examining SQL Server
7. behind the scenes When you click OK you will see Select Unique Record 15 Identifier boxes pop up for each journal you selected For header tables select NRecord or GUID For detail tables select GUID You may also see a box for Customer Sales If so select CustomerID and Period 7 Connection to SQL Server Connection methods vary The following assumes you have SQL Server amp SQL Management Studio installed amp some familiarity with both 32 bit Windows DataMirrorforPT will query the registry for instances of SQL Server and allow you to choose which one to use for the Mirror database 64 bit Windows DataMirrorforPT will be unable to navigate to the section of the registry with SQL instances Use DefaultMirrorData xml in the DataMirrorforPT install folder to specify the SQL Server instance to be used The following shows the default settings lt xml version 1 0 gt lt Data gt lt DataSource gt SQLEXPRESS lt DataSource gt lt InitialCatalog gt DataMirrorForPT lt InitialCatalog gt lt Username gt lt Username gt lt Password gt lt Password gt lt Data gt 16 If you are having difficulty connecting we suggest you use a universal data link file to test your connection independent of the DataMirrorforPT Simply create a new test txt on your desktop change the extension to udl and then double click test udl Data unk Properties A On the provider tab select SQL pare SE i Native Client or SQL Server
8. the InitialCatalog name The 1st time your run DisplayMirroredData exe from DataMirrorForPT2 designate the company from which you want to pull data Note you will need to start each DisplayMirroredData exe from their respective folders They may be run side by side A separate DataMirrorForPT folder amp database are needed for each respective company to be mirrored 10 Using DataMirrorForPT Data in MS Excel MS Access or MS Word A separate document is provided with getting started assistance ofr using DataMirrorForPT in either MS Excel MS Access or MS Word see UsingMirrorData_InExcel_orAccess pdf in the C Program Files Multiware DataMirrorForPT folder 20
9. Bes H pew8 Bes H PCW8 test H PCWS Bes H PP4D11 Company BCS H ppam11 company _PDG H ppam11 company _SBD HAPPAM11ACompanyiBCS H Quantum1 5 company belgarsu H AQuanturn 6 company belgarsu H Quantum1 Company BES Peachtree Version Accounting 10 Accounting 7 Accounting 8 Accounting 49 Complete 10 Complete V6 Complete W7 Complete v8 Complete 8 Complete V9 Distribution 411 5 Manufacturing 11 5 Manufacturing 411 5 Manufacturing 411 5 Quantum 415 Quantum 16 Quantum 417 Last Access 04 17 02 15 46 20 1104 99 18 37 48 01 08 01 12 25 32 04 05 01 10 22 08 04 16 02 13 16 26 03 13 98 14 21 44 04 28 99 15 56 58 07 25 06 17 28 44 08 18 06 11 28 22 04 05 01 10 16 42 08 07 03 13 56 14 08 21 03 17 47 48 08 26 03 18 53 38 08 07 03 13 39 50 09 26 09 15 23 09 20 previously opened companies found Search for Additional Companies The initial list of companies is found by searching the registry and Peachtree ini files for any databases that any version of Peachtree has previously opened Click on the company you want to use and click OK You can also click on any column heading to sort by that column Click on the column a second time and the sort will be in reverse order If you click the Search for Additional Companies button a more exhaustive search will be performed by scanning all your disk partitions This can take some time to perform After the searc
10. Cash Disbursements Joumal Sales Joumal Purchase Joumal Payroll Joumal Cost of Goods Inventory Adjustment Joumal Assembly Adjustment Joumal System Cost Adjustments Purchase Order Joumal Sales Order Joumal Quote Joumal Example oControl Show ournals2Mirror The data on this form is stored in the SQL Server table DataToMirrorJournals If you do not want to display the form above in your application you can edit the SQL Server table directly as desired ShowOptions Displays a form that lets you select some controlling options Ln isi MV Read All Audit Trail Data IM Enable File Mirror 500 Timer Interval in ms jio Delay Count Change Path When the Read All Audit Trail Data box is checked the entire audit trail history will be read when ReadAllPTData is invoked SQL Server has 2 recovery models full amp simple Simple is the default for the Data Mirror however you can override that setting by checking Full Transaction Logging For large databases full transaction logging takes lots of resources disk space Checking Disable Apply Changes will not allow the users to apply changes only to implemented tables This may be necessary if the volume of non mirrored transactions is excessive For very large databases with very high volume of changes Read Peachtree Data may be the fastest way to ensure your mirrored tables are completely current Checking Log
11. DATA MIRROR FOR PT USER S GUIDE Multiware Inc Oct 9 2012 Changes are in red font Table of Contents Lo TAUPO DUI CHONG a O A ts cdas 3 rd e de a o 4 3 M rrorControl Miss a td 5 EN AO E EE E A 5 Clear ALLEPTDatakae A aa a SS 5 Connect DataSource InitialCatalog Username Password oooooccccnoccccnoccninanacinnncnnns 5 Read rol IP ata e e es e cello 6 NN A eid eee A E E duet ea estes eed eee 6 ShowData OMT A een ee Ce ee ak 7 Sh wOptionalData Jasse n a e a aa eriei 8 ShowJournals2MITror 000 a ase iai aaia 9 POW O O O S os 10 StartMirrornin Sson e a a Rees a E A Rian baty tees 11 Stop MITO g easiness e a e e A ri 11 DD Properti ES n tr a e E E AE E Eo Ea OTSR 11 CompanyName 5 sala ante E A see AN 11 COMPARA ST A ARES nua 11 ConnectionString ii O A E Eiaeai saaie aeie 11 FNMA ZO insesi naaste e eea E EAE aT a ASE 11 Pass WOtG O a aia O AEE Se A ESE AEN AEA io eee 11 Tinte A E E A E ate AE 12 Timer aluvial da idad 12 A A aed 12 RN 12 oControl MirrorStateChanged ByVal State As Shortt ooonconnnccnoconoccnonanonancnancconccnnnos 12 oControl LogTransactionAdded ByVal myTime As DateTime ByVal Milliseconds As Integer ByVal Message As StITINY ooocononccnnonacinonanononacononacononanononocconnnnnonancnonanos 12 oControl StatusText ByVal Text As String eee eeeeeeseecnaeceseeeeeeesaeesnaeenseesees 13 oControl StatusProgressInit ByVal Max Value as Integer 13 oControl StatusProgressUpdate ByVal Value as Int
12. Properties DetallirrorforPT E 215 nio x a Server f MiG OONSOLEXPRESS2006R2 1 sen M0 _001 Lory G Hyrum 3 Yan coroecen appetite Property views will vary by version of SQL Server Exposing logins in plain text is not considered a safe practice we recommend Windows Authentication 8 Starting the Data Mirror on Startup The DisplayMirroredData application has two command line switches e R Refresh all on startup and e S Start mirroring on startup The switch delimiters are spaces and if both R and S are specified R should come first You can start up the DisplayMirroredData application from Task Scheduler in the Administrative Tools in the Control Panel Create a basic task set the start When computer starts set Start a Program navigate to DisplayMirroredData exe in the Program Files under Multiware add R S as arguments lastly add the start in folder C Program Files Multiware DataMirrorForPT On 64 bit machines the start in folder will be C Program Files x86 Multiware DataMirrorForPT The company must be set manually at first use The DisplayMirroredData form will display but it can be minimized 19 9 Mirroring 2 or More Companies Any number of companies can be mirrored Just make a copy of the install folder i e copy C Program Files Multiware DataMirrorForPT to C Program Files Multiware DataMirrorForPT2 edit DefaultMirrorData xml in the copy folder Change
13. databases A word of warning installation of these kits takes quite a while to complete so be sure to set aside some time to perform the installation SQL Server 2008 Express is a completely functional version of SQL Server However it does have some limitations compared to the higher version SQL Server The most significant has to do with the maximum size of the database Although we have tested the Data Mirror for PT with some large Peachtree databases it is possible that some extremely large Peachtree databases will contain more data than the Express version can handle in which case you would need to purchase and install a higher version The application DisplayMirroredData was built with VB NET 2008 Express which is a free development tool that you can also download from the link above If you want to modify the application you will need either the Express or full version of VB NET 2008 Microsoft also provides other free Express tools that you may want to consider installing The first time the MirrorControl object is invoked it will look for the specified SQL Server database If it can t find it then it will create the database and build all the necessary tables views and stored procedures This insures that the database will be compatible with the version of SQL Server that you are using You can also specify an existing SQL Server database that does not have the necessary database components and they will be added to that database
14. e MirrorControl object only reads the JrnlHdr and JrnlRow records and the MirroredData SQL Server database contains specific views for the various journals that map exactly into the PawCom specific journal tables Plans are to create additional views that map directly into the PawCom tables so that applications that were developed with PawCom will be able to see recordsets in the SQL Server database that look exactly like the current PawCom tables 6 Attaching the SQL Server tables to MS Access The SQL Server database can be linked to an MS Access application using ODBC To do this you first need to create an ODBC connection When using SQL Server Express you can do this by going to Control Panel Administrative Tools Data Sources ODBC Click the System DSN tab and then the Add button Select the SQL Server Native Client 10 0 driver Name the data source DataMirrorForPT and in the server to connect to box enter local SQLEXPRESS On the next form select Integrated Windows Authentication After creating an ODBC source to the SQL Server database you can link to the tables in MS Access as follows in design mode go to the menu bar entry File Get External Data Link Tables Under Files of Type select ODBC databases On the next form select Machine Data Source DataMirrorForPT On the Link Tables form select only the files that begin with dbo The other files are internal database system files that SQL Server uses
15. e username can either be specified with this property before calling the Connect method or the username can be specified as a parameter for the Connect method Writeonly 3 3 Events If the calling application has included the WithEvents parameter when defining the MirrorControl object then NET will include the following event handlers in your application oControl MirrorStateChanged ByVal State As Short Triggered each time the mirroring state is changed while the library is mirroring data The values of the State parameter are Off 0 Stable 1 Waiting 2 MirroringData 3 If mirroring is turned off then the state will be set to off If mirroring has finished processing any changes to the Peachtree data files then the state will be set to Stable If mirroring has detected that a file has been modified then the state will be set to Waiting If mirroring has detected that the Peachtree database has changed and no further changes have occurred for the number of seconds set in the Options DelayCount parameter then processing of the changes will begin and the state will be set to Mirroring Data oControl LogTransactionAdded ByVal myTime As DateTime ByVal Milliseconds As Integer ByVal Message As String The library maintains a transaction log in the SQL Server table Transaction Log Each time a new entry is made to this log this event is triggered so that the calling application can monitor the log entries in real time The log
16. eger 13 oControl StatusProgressDonel vcsscsiqsaszeendcccddeasted deaveuasadentueysevencsntdedshes daveaceonuneeesn bens 13 4 Display Mirrored Data Application inici tdi da Giese 14 5 SQL Server vs PawCom Access Tables occccconooonocanonocccnnnnnnananononocnoncnnnnonanononoos 15 6 Attaching the SQL Server tables to MS Access c oooooccocccccoocccnoncnconnccconnncnnoncconnnccnnnnccnnnos 15 Ti Commectionto SOL IM o E aed 16 IR A REN th BO ee ee ee tae 16 CADE MADONNA a 16 SOL Authentic emitida nd led 18 8 Starting the Data Mirror on Startup oooooccoccccnoccncnoncnononanononcnonnncnnnnnnconnnncnnnnncnnn nc cnnnncnnnnss 19 9 Mirroring 2 or More Companies ii dee 20 10 Using DataMirrorForPT Data in MS Excel MS Access or MS Wo ldO oooccnnccccnnnccon 20 1 Introduction The Data Mirror for PT is an application that maintains a copy or mirror of a Peachtree Accounting database in an external SQL Server database allowing users to develop applications that will work with the Peachtree data using the development environment Microsoft has built around SQL Server and ensures that there is no interference between Peachtree and external applications that work with the mirrored data The heart of the Data Mirror for PT is a NET class library that performs the mirroring operations and exposes a user interface that allows applications to control the way mirroring is performed Initially all records in the selected files are read
17. entries are defined by the date and time they are entered The milliseconds gives finer division of the entry time so that entries 12 that occur within the same second can be sorted properly The Message is the text of the log entry oControl StatusText ByVal Text As String The library also generates informational text that is not associated with a Transaction Log entry This information typically indicates what the library is doing with finer detail than the Transaction Log data so is useful to display as a status line in the calling application oControl StatusProgressInit ByVal MaxValue as Integer The library provides progress information for operations that will take a while This information is useful for displaying a progress bar in the calling application This event is triggered before progress begins and indicates the maximum value the progress bar should have oControl StatusProgressUpdate ByVal Value as Integer This event is triggered each time an updated value on the progress of an operation is triggered oControl StatusProgressDone This event is triggered when the progress of the current application is complete 13 4 Display Mirrored Data Application The DataMirrorForPT kit includes the utility DisplayMirroredData written in VB NET that illustrates how to use all the methods and properties of the MirrorControl class This utility lets you control the data mirroring library without having to write any code T
18. h any additional companies found will be highlighted in light yellow and any databases located in Peachtree backup files will be highlighted in light green If you do not want to use the form for selecting a company and you know the company s path you can enter the path directly in the SQL Server table named Options If you do not select a new company or click Cancel the return value will be false If a problem is encountered that doesn t allow the form to display an error will be raised Example Try Result oControl SelectCompany Catch ex As Exception MsgBox Error selecting company amp vbCrLf amp ex Message End Try ShowDataToMirror Display a form that lets you select the files you want to mirror by checking the item in the Mirror column FormDataToMirror FileName Address DAT AuditT DAT BOMHist DAT BOMltems DAT Chart DAT Company DAT Contacts DAT Cost DAT Customer DAT adan aaa Mirror LastModifiedT ime 1 1 1900 10 30 2009 3 37 PM 1 1 1900 114141900 10 30 2009 3 35 PM 10 30 2009 3 37 PM 1 1 1900 117171900 10 30 2009 11 48 4M LastUpdatedT ime 111 1900 10 31 2009 8 55 PM 1 1 1900 1 1 1900 10 30 2009 3 36 PM 10 30 2009 3 38 PM 1 1 1900 11 1 1900 1 1 1900 LastFileMirrorTime 1 1 1900 1141900 1 1 1900 1 1 1900 10 30 2009 3 36 PM 10 30 2009 3 38 PM 1 1 1900 1 1 1900 10 30 2009 11 48 AM The LastModifiedTime is the date and time that the file was last changed by
19. he utility also includes simple forms for showing data in many of the SQL Server data tables EF Data Display for Peachtree Mirror 1 33 i y ojoj loj x Options Data to Mirror Optional Data DammSommo Show Sel c Path C Sage Peachtree company Sample PTXA BCS bes caja Name Bellwether Garden Supply Clear Peachtree Data Read Peachtree Data Start Mirroring Activity Log Message 7 13 12 5 33 11 PM 001 DO NOT APPLY CHANGES ONLY UNTIL AFTER INITIALIZING 7 13 12 5 33 11 PM 001 THE SQL TABLES w READ PEACHTREE DATA 7 13 12 5 33 10 PM 949 Purging Audit Trail all but last record s The first four menu bar items when selected call the library to show the corresponding form The Show menu item can be used to select a display of data in many of the SQL Server database These data display forms are very simple similar to what you would see viewing the data in an MS Access table or with SQL Server Management Studio The three buttons on the left are for invoking the corresponding methods in the MirrorControl class The middle button Apply Changes Only will scan the SQL tables for missing records and add them records in Peachtree showing a higher LastUpdateCounter where available and update them and records deleted in Peachtree and delete them Apply Changes Only applies just to the Customer Journal and Line Item tables for release 1 33 or higher For version 1 35 or higher the Apply Changes Only is d
20. into the SQL Server database Then when mirroring is enabled the Peachtree database is monitored for changes additions modifications and deletions and the SQL Server database is updated with the changed information This is a significant improvement over the way that previous Multiware products PawCom and MWToolkitForPT got data where all the records in the external tables were refreshed because it was not known what had changed The Data Mirror for PT also reads data much faster PawCom is approximately seven times faster than MWToolkitForPT and the Data Mirror for PT is 3 4 times faster than PawCom at filling the external tables The mirroring of the Peachtree data is performed as follows The files that make up the Peachtree databases are monitored for changes to their Last Modified date The application keeps track of files that have changed and waits a while until there are no further changes to the files for a short period of time by default 10 seconds The reason it is necessary to wait for modifications to the files to stop is because Peachtree typically makes several changes to a given file over a period of seconds For example when a sales invoice is entered in Peachtree it can take up to 15 20 seconds for the resulting changes of data files to complete even on a standalone system with a local database When the database is stable the application reads new Audit Trail records to determine what operation was performed in Peachtree then the
21. one for the Journal any time there is a delete recorded in the audit trail 14 The button on the right will start and stop mirroring The light to the right of the button will be green when the mirroring state is stable yellow when it is waiting to make updates and red when the SQL Server database is being updated Activity log entries will be red for errors Click the description to see full text A source listing of the VB NET can be found in Appendix A 5 SQL Server vs PawCom Access Tables In general the SQL Server tables in MirroredData mdf are similar to the tables in the PawCom MS Access application However the PawCom tables have a lot of extraneous baggage from older versions of Peachtree Also the PawCom tables have some fields where Peachtree originally stored IDs but now stores indices and for these fields the current PawCom has to do an extraneous and time consuming lookup to find the ID given the index in order to maintain backward compatability That is the structure of the PawCom tables is more consistent with the way the Peachtree records were stored several years ago The SQL Server tables on the other hand are based on the latest structure of the Peachtree records which has been fairly stable for the last few years In the MS Access application for PawCom the default file parameters caused the journal data to be read twice once for the JrnlHdr JrnlRow raw data and again for the specific journal views of that data Th
22. password you can alternatively specify their value with the Username and Password properties before invoking the Connect method Examples oControl Connect Connect to database DataMirrorForPT using local SQL Server Express instance oControl Connect DataSource InitialCatlog Connect to specified database using specified SQL Server instance oControl Connect DataSource InitialCatalog Username Password Connect to the specified secured database with the username password using the specified SQL Server instance ReadAllPTData For each component specified on the DataToMirror form read all records Example Result oControl ReadAllPTData SelectCompany Display a list of Peachtree company databases found on the system Select Peachtree Company Peachtree Companies Found Company P w10 Bellwether Garden Supply PAW Bellwether Garden Supply PAW Bellwether Garden Supply PAWS Bellwether Garden Supply PCw10 Bellwether Garden Supply Berkeley Custom Pools amp Services Inc PCW Bellwether Garden Supply PCW8 Bellwether Garden Supply Test ccrual9 PCW Bellwether Garden Supply PPAD11 Bellwether Garden Supply PPAM11 Pavilion Design Group PP4M11 SBD Manufacturing amp Distribution PPAM11 Bellwether Garden Supply Bellwether Garden Supply 015 Bellwether Garden Supply 016 Bellwether Garden Supply gt Path H PAWTONBes H paw Bes H paw8 Bes H PAWS Bcs H pewl O Bes H pewB Bes H pow
23. should start reading journal records when ReadAllPTData is invoked A value of 0 means read the complete set of journal transactions going back to the start of the company If you want to only read data in open periods the value should be set to 15 Optional Data Include Chart History Include JmiHdr Direct Deposit Data Include Chart Purge Data Include Line Item Attributes Include Customer History Include Line ltem Components Include Employee Direct Deposit Data Include Line Item History Include Employee EE Detail Include Line Item Price Levels Include Employee ER Detail Include Vendor History Include Employee Pay Info Include Employee Payroll Detail Start period for journal data it Example oControl ShowOptionalData The data on this form is stored in the SQL Server table OptionalData If you do not want to display the form above in your application you can edit the SQL Server table directly as desired ShowJournals2Mirror Displays a form that lets you select which journals to mirror In case where you have a very large database with high volume of transactions you will get better performance by limiting the journals mirrored However in limiting the journals you must be careful get the data you need for your application For example sales invoicing may need sales orders and cash receipts Similarly purchases may need purchase orders amp cash disbursement El Journals to Mirror General Joumal Cash Receipts Joumal
Download Pdf Manuals
Related Search