Jump to content


Productive Computing
  • Content Count

  • Joined

  • Last visited

  • Days Won


PCIPal last won the day on September 3 2018

PCIPal had the most liked content!

Community Reputation

3 Neutral

1 Follower

About PCIPal

  • Rank

Profile Information

  • Location
    San Diego County, CA, USA
  • Interests
    QuickBooks Integration, Outlook/Exchange Integration, FileMaker Hosting, FileMaker Plug-ins, FileMaker Custom Development

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance
    FIleMaker Platinum Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi BoloMan28, It looks like you have the APAccountRef field out of order with the intended structure of the BillPaymentAdd request schema. You need to specify the APAccountRef field after PayeeEntityRef and before TxnDate. Thanks! CT
  2. Alexandria, How did you install the plug in initially? Did you happen to use the "Setup" installer? If you did, try uninstalling and reinstalling. If not, please use the "Setup" file to install the plug in and its proper dependencies. If you have any questions, please let me know. Kind Regards, Jordan
  3. Hi Brain, Thank you for your feedback. I have sent all the information to our Products team to review. Thank you.
  4. Hi Brian, "Modified Date" is a date property. The plug-in will convert any timestamp to a date value when passing it to Address Book. If you need to look for records based on a specific time of the date, then you will do some parsing in FileMaker after the records have been pulled in from Address Book. Thank you.
  5. Hi adgilcan, Can you post some screenshots on where you have placed the Acrobat plug-in? Sincerely, Carson
  6. Hi soundsessential, You would need to add CheckPayment as a related record and then set the BankAccountRef. Let me know if this resolves the issue or not. Thank you. PCQO_RqAddRelatedRecord("CheckPayment"); PCQO_RqAddFieldWithValue("BankAccountRef::value"; $value); PCQO_RqCloseRelatedRecord; Sincerely, Carson
  7. Hi soundsessential, I would set the "IncludeLinkedTxns" to true in the BillQuery request. Then I would loop through all the LinkedTxn in the response and look for any records with a TxnType of "BillPaymentCheck" or "BillPaymentCreditCard". Please give it a try. Thank you. Sincerely, Carson
  8. Hi Sue, Try to do the following: 1. In Contacts, go into Find mode. 2. Select the "Company" checkbox and select "Omit" for "Matching records:" 3. Click "New Request", select "Omit" for "Matching records:" and enter in "NOMAIL" in the "Keywords" field. 4. For each keyword that you want to find, click "New Request" and enter in the keyword in the "Keywords" field. 5. Perform Find Sincerely, Carson
  9. Hi soundsessential, You can set the "metaData" attribute in the request and look for the retCount attribute in the response. Here is an example for Customer Query. PCQB_RqNew("CustomerQuery" ; "metaData=MetaDataOnly" ); PCQB_BeginSession(); PCQB_RqExecute(); PCQB_RsGetResponseAttribute( "retCount" ); Also, you should be using the latest version of the FM Books Connector plug-in. There were bugs on setting the attributes in a request in version 10 and of the plug-in. I've tested the confirmed that it is working on of the plug-in. Sincerely, Carson
  10. San Diego, CA – November 9, 2018 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce a new Maintenance Support Program for FileMaker users. This program is intended to provide FileMaker customers a low-cost alternative to time and materials billing when performing “fix it” type programming and regular maintenance on their systems. Support plans are designed to improve the performance of a FileMaker app by fixing nagging issues that users create workarounds for, reducing the costs associated with upgrading from one version of FileMaker to the next, providing a means to clean up and modernize legacy code, improving a solution’s user interface, and regularly meeting with and getting advice from a certified FileMaker development team. This program allows its users unlimited access to FileMaker experts without worrying about the bill. Productive Computing’s FileMaker Support Program includes: Unlimited support on small development and support requests Unlimited support on FileMaker Pro usage/training Free consulting sessions on programming best practices and workflow recommendations Free Health Assessment ($1,000 value) One free subscription to Productive Computing University ($149/yr value) Annual customer workflow audit, FileMaker new features overview, and system recommendation report "We just completed a massive upgrade in our FileMaker system and, now that we’re on the maintenance program, we’re able to reduce ongoing costs for any remaining open issues as a result of the deployment. The maintenance program has unquestionably delivered a tremendous value for an affordable price." Alana W., 25 Users, Historic and Fine Art Industry Representatives Clients who also purchase their FileMaker licensing through Productive Computing will be provided with the following services at no additional charge: Discounted hourly billing rates for larger custom development projects Unlimited FileMaker Pro client and server installation support Unlimited SSL Certificate installation for security of FileMaker Server Unlimited support on issues related to FileMaker upgrades and conversions This support program is designed for customers who: Are considering making changes to their system but are concerned about the cost Have recently invested in major custom development to expand their solution’s functionality Would like to have an on-call FileMaker support resource who knows and cares about their business and specific workflow Like programming themselves but occasionally need a little bit of help or advice Are interested in outsourcing their FileMaker development to free up staff time Do not have an internal employee maintaining their system Value annual system checkups and would benefit from regular service to keep their solution working at maximum efficiency Are interested in continuing to improve their system and business processes Want to capitalize on FileMaker’s newest features to benefit their company Productive Computing’s FileMaker Maintenance Support Program is available for $200/mo for up to five users, additional users can be added for $40/mo. For more information on plan details and restrictions please visit https://www.productivecomputing.com/filemaker-maintenance-support-program/.
  11. Hi Paul, You will need to edit your sales tax rates in QuickBooks Online. Then you can do a query to pull in the tax codes and tax rates into FileMaker. Edit Sales Tax Rate in QuickBooks Online Sincerely, Carson
  12. Hi jfk_25, That error indicates that QuickBooks has not been accessed by the third-party application (in this case, FileMaker 14) before. This is expected behavior when connecting to QuickBooks after upgrading FileMaker to a new major version. All you need to do is open QuickBooks and your company file, then begin a session and configure the QuickBooks configuration certificate as per the Developer's Guide, just like you were doing a first-time startup. You will then be able to use QuickBooks in unattended mode once more. The reason behind this is that the QuickBooks treats the combination of the FM Books Connector plug-in and the version of FileMaker as the key to determine when a different application has tried to access QuickBooks. If you were to set up a connection with FileMaker 14, and then upgrade to FileMaker 17, QuickBooks would treat FileMaker 17 as a "new application", and so the first-time setup would need to be repeated. It's a bit of extra work, admittedly, but it's necessary, and once it's been re-configured, anyone with access to your company file can connect from that new version of FileMaker. Hope this helps! - CT
  13. Hi Paul, You are correct! There is, however, a cap that Intuit uses which natively sets the limit to 500 records, due to a limitation of bandwidth and throughput on the network connection. You can also use pagination to pull in all records from QuickBooks, by setting a combination of the "StartPosition" and "MaxResults" fields, and looping until there are no more records left to pull. We have an example of how to paginate in the Developer's Guide, for future reference. Thanks! - CT
  14. Hi Trebor, Runtime versions of FileMaker have their own Extensions folder that any needed plug-ins should be placed into. Usually, this is in the runtime's primary folder, in the "Extensions" subfolder. Place the plug-in into that folder to have FileMaker Runtime load the plug-in on initialization. To install the QB Bridge, when you download the installer package of the FM Books Connector, we have included in the Extras folder a copy of the QB Bridge installer as a standalone installation package. Normally, you'd just run the primary installer (the first "setup.exe" file), which would take care of the plug-in and the QB Bridge program all in one go. But some instances only need the bridge file separate, so we have the separate QB Bridge installer provided. You'd simply run that setup.exe file and it will take care of installing the bridge. Hope this helps! Chris Turner
  15. Hi TJ53, At this time, the Cloud Manipulator is not server-side compatible, so unfortunately it will not work with FM Go. I have added your name to our interest list, and if the plug-in is later updated to become server-side compatible, we'll send out an announcement. Thank you for your interest! CT
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.