Jump to content

Bruce Herbach

  • Content Count

  • Joined

  • Last visited

Community Reputation

-1 Poor

About Bruce Herbach

  • Rank

Profile Information

  • Title
    Chief Developer Herbach Consulting
  • Industry
    FileMaker Development
  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet

Recent Profile Visitors

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

  1. Geoffrey, Very helpful. Thanks much. I'll look at using the PSQB_Z functions. When I ran the PCQB_SGetXML function, the result did not have the Earnings section I was looking for which of course explained the errors and blank responses I was getting. I understand that this request maybe above and beyond so please understand no is a perfectly acceptable answer. Would you be willing to share an example of your process for building a request? Again thanks very much for all of the help. I'm new to working with Quick Books and have made a fair amount of progress with the proj
  2. Geoffrey, I'll give that a try. Do you have an example file using XML to download all Customers and upload a customer? I have been using the API version. Although new to working with QuickBooks it is very similar to other plugins I have worked with. Thanks very much Bruce Herbach
  3. Geoffrey, I may be looking at the wrong field. When I look at the Employee in QuickBooks, I have a portal on the Payroll Info tab labled Earnings. It has two columns, Item Name and Hourly/Annual Rate. These are the two fields I want. When I tried this with PCQB_RsOpenFirstRelatedRecord, and PCQB_RsOpenNextRelatedRecord, I get an error Code 1000. If I leave out these commands, using PCQB_SgetStatus, when the result is empty it reports Code 0. Thanks very much for your assistance. Bruce Herbach
  4. I'm working on pulling Employee information from Quickbooks into FileMaker. I have most of the query working. I'm trying to get the information for PayrollItemWageRef::FullName and rate. The image below shows the information from SDK. What should the syntax be for PCQB_rsGetFirstFieldValue? Assistance with this would be greatly appreciated. Thanks Bruce Herbach
  5. I have a script that updates a Vendor record in QuickBooks Enterprise Solutions: Contractor 20.0. When I developed the script I believe that they were on version 19. I was doing some work on this yesterday and noticed that the update is now getting a 3190 Error. Meaning: Cannot clear required Element Explanation: Cannot clear the element in the fieldName field. The script either re-writes the current value or updates the value in the VendorMod::Name field. This was working. The script step is PCQB_RqAddFieldWithValue( "Name" ; Vendor::VendorName ). Should I be able to update
  6. It looks like QuickBooks has redone their website. https://developer.intuit.com/app/developer/qbdesktop/docs/api-reference This may be the new setup.. If so it is really hard to use after using the previous version. For instance I just completed a script ( that works ) that pulls in Time tracking: It starts with: PCQB_RqNew("TimeTrackingQuery" ; "" ) But on the setup they have it looks like they have it listed as " |TimeTrackingQuery > " I think the "|" is a seperator and should be ignored. The ">" is a button to show details. I did end up sign
  7. I'm stuck as well. I have set up a script to pull in information and really can't proceed with out it..
  8. As of this morning the links to Intuits SDK have failed to connect. I was using it yesterday. http://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.htmls Is there a new link for this?
  9. For the project I'm working on, I want to be able to have FileMaker generate a client invoice based on hours staff have worked. Currently they enter the hours and project into Quick Books directly on the Enter Time/Use Weekly time sheets screen. Then export a spread sheet, tweek it and copy paste into the invoice they send to their client. I would like to be able to use the Customer/Job and date range to pull this information from Quickbooks. So the question is in the QuickBooks SDK, which Query do I use to pull this information? Thanks Bruce
  10. The project I'm working on will be running on the computer with QuickBooks installed. I believe that office staff may have access to the Quickbook data file from other computers in the office where they enter data. FileMaker with the plugin will be running on the quickbooks computer and periodically looping through a set of tables and adding or modifying data in quickbooks. With this in mind, what should the set up be for the QuickBooks connection? Ideally staff will be able to their work while FileMaker is doing it's work. In some cases, staff and FileMaker will be looking at the sa
  11. I'm still very new to using the Productive Computing QuickBooks Plugin. My client has been using both FileMaker and QuickBooks for a long time. Until now they have been disconnected. I'm finding that for both Customers and Vendors, we have records in both that should match. The issue is that one will have Harry Brown Brothers while the other has Harry Brown Brothers, Inc. I have a scripts that will pull information from QuickBooks based on the FullName field but it only works if there is an exact match. So in this case if Harry Brown Brothers is in FileMaker and I run the script I ge
  12. I'm setting up a script to add a Bill to QuickBooks using the SDK BillAdd. In the script it loops through and adds line items using SDK item from ItemLineAdd. In QuickBooks when I display a bill the client has a field labled Customer:Job You can see it in the attached jpg. I am able to fill in the other fields in the ItemLineAdd and have them display correctly when adding a bill. I don't see any way to to fill in this field from the fields listed in the SDK section for BillAdd/ItemLineAdd. There is a CustomerRef section with fields for ListID and FullName. I am expecting to add
  13. Once I fixed an issue with fields earlier in the OSR this field reverted to it's optional state. I had an issue when trying to set two fields one on each side of the Sales/Or/AndPurchase section. Should have used fields from And section only. The message I was getting when the script tried to set fields on both sides of the OR was that is was expecting ExternalGUID. As stated at the top, I'm new to working with the plugin and interpreting the OSR. That stated, I now have the script working and correctly adding ItemNonInventoryAdd items. If I enable the line: set variabl
  14. Thanks. It appears that the a FileMaker UUID should work, but when using the primary key/uuid value I still get the error message. For the moment this is not a show stopper. Current data in QuickBooks does not have a value in this field and we can get by with out it.
  • Create New...

Important Information

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