![]() When poking checks with a vendor ID, I found that Peachtree (7.0) would not automatically enter the address from the vendor record, the way it would if I had selected the vendor name from the list.If you follow the manual's directions, you will be referencing a field that is only visible when you are selecting a payment to edit. There is no documented way to retrieve or poke information from or to the “memo” field on a payment.What little information on DDE exists in Peachtree's manual is valuable, but is not always accurate.Don't put commas in your vendor names! This will screw up any attempt to retrieve information on that vendor, unless they are part of a larger range, where that vendor is neither the first nor last in the range. ![]() N.B: Due to the way that Filemaker stores exported file settings, if you plan to use your solution in a networked environment, each user's. csv file, and DDE poke to your heart's content. Have the script open a VB application (or, in my case, an Excel document with an “Auto_Open” macro. Export Records (Important: Have it export to the same file location every time use.Perform Find (your found set should be all the records you want to export).Rarely used, it will instruct Filemaker to open the document or application of your choice. How to create a Filemaker script that writes a payment/receipt in Peachtree:įirst, know the “Send Message” Filemaker script step. These tips are intended for the user who is “almost there”, to figure out the seemingly small bugs that will take up the majority of your time. ![]() I will also assume a basic familiarity with Filemaker. ![]() I will assume that the reader has read the other resources on this web site, and is comfortable with moving information using DDE. However, with an intermediary (here, I use Excel and VBA a standard VB program will also do the trick), and patience, one can put together a fully automated solution. We thank him for contributing the following content to our web site:įirstly, for those who are considering a project that involves automating both Filemaker and Peachtree, understand that this will be a complex task, since there is no means of communicating directly between the two programs. Jon Goldberg has successfully integrated Peachtree Accounting and FileMaker Pro via DDE (by way of Excel). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |