FM Books Connector Online

Hello! I seem to be having issues creating a bill. I keep getting the error 2010 Failed To Parse JSON Element. A property specified is unsupported or invalid. I'm at a bit of a loss of what isn't working in this script. I'm very new to the world of quickbooks in general. Thank you in advance for any advice! I uploaded the images of the script to my Claris Post. https://community.claris.com/en/s/question/0D5Vy00001OBiAMKA1/trying-to-create-bill-in-qbo-using-pc-qbo-connector-advice-needed

Have a client using FM Books Connector 12.0.0.7 with local Quickbooks Premiere Plus Pro Services Edition 2022 about to migrate to QB Online and FM Books Connector Online. We are push/pulling companies/invoices. Some questions: 1) Should we upgrade to FM Books 12.0.0.8 first? 2) What are the functional differences between the 2 versions of FM Books Connector? Is there a matrix of functions compatible/not compatible? How dramatic are the FM scripting changes needed? Basically looking for a guide for implementation (if available) but also to get some direct feedback from someone who has already done this to find best practice and possible issues. Thank yo…

Hello, I am using the QBO demo file and added an attachment to an invoice and inserted as a reference. When I push the invoice, I get this error: I then change the attachment to not be a reference and push the invoice and FileMaker 20 crashes. Can attachments successfully be added?? Thanks!

When creating an invoice with the plug-in, even though the preference for DocNumber to auto-generate is set ( and manual creation of invoice proves that to be true ) the DocNumber field is blank. Do I have to tell QBO to auto-generate this field when creating it, and if so, is there documentation on how to do that?

Has anybody had issues querying payments? PCQO_RqNew ( "Query"; "Payment" ) PCQO_RqAddFieldWithValue ( "Id"; Payments::QBTxnID ) PCQO_RqExecute Yields: No records found for this query. If i do a select * from payment where id = '####' in the intuit api, then the payment shows up.

Query on the customer table returns 500 results. I want to pull all 9000+ I do not find anything in the documentation that discusses how to do this, please advise.

Hello, Has anybody successfully managed to get v3 of the FM Books Online server side plugin working with FileMaker Server on macOS? I have tried with FileMaker Server 16 and 17, testing with the server side demo file provided and with my sandbox and live QBO accounts. What mostly happens is that I get the FileMaker error of 'The hosts capacity was exceeded', and the FMS logs show FMSE unexpectedly shutting down every time I attempt to use the plugin 'on server' with PSOS... Any tips or suggestions much appreciated.

Hi All, Since upgrade our plugin to Win Version 3.0.0.1 I now get this error when uploading invoices to QBO. It seems to be only invoices with more than 1 qty of an item as the error suggests. I have attached the script. UnitPrice (Line Items::ProdUnitCostRRP) * Qty (Line Items::Qty) does = Amount (Line Items::ProdUnitCostRRPTotal). So I'm unsure what is causing the issue. This was working fine before the upgrade !? So I'm wondering if there is something that has changed that needs to be called in the script. I would appreciate any help... script.pdf

Does anyone have an example of how to pull all items from QBO including the sub items? I can currently pull all the items, but not the sub items.

I will be installing FM Books online (server) and owner if there are demo files anywhere that have examples of a good number of typical transactions and queries - the demo file available on Productive's site is quite limited in scope. TIA Oliver Reid

When pushing a BillPayment, what's the format for the BankAccountRef field? Most fields are one or two levels, such as "DocNumber" or "VendorRef::Value" but BankAccountReference has three levels. I've tried "CheckPayment::BankAccountRef::Value" and others but none are working. Thanks

Hi Folks, Have an issue since updating to Filemaker 17 and the Latest Productive FM QB Online Plugin. My existing Database was working fine before upgrade but I now get this Error when I'm pushing invoices to QBO. Particularly adding products to the invoice. Error executing request CODE: 2010 SEVERITY: ValidationFault MESSAGE: Request has invalid or unsupported property Property Name:Unrecognized field "Line" (class com.intuit.schema.finance.v3.SalesItemLineDetail), not marked as ignorable (17 known properties: "ItemRef", "DiscountR specified is unsupported or invalid SOURCE: PCQO_RqExecute The Demo file does seem to…

Hi all, I have script which pull the Balance for Customer into FM. It worked fine till Today. From Today, I have unpredictable behaviour. I didn't update Windows ( where is the server) or nothing. Same behaviour is on every machine from which I tried to connect on, even is Windows, even is Mac. Here is the part of code which pulls the Balance for one Customer. Set Variable [$$Result; PCQO_RqNew( "Query" ; "Customer" )] Set Variable [$$Result; PCQO_RqAddFieldWithValue( "Id" ; $Customer_QBO_ID_List )] Set Variable [$$Result; PCQO_RqExecute] If[$$Result ≠ 0] Exit Script [Text Result:999999999] End If Set Variable [$$Result; PCQO_RsOpenFirs…

Hi, Hoping someone and provide some guidance. I have been running version 1.0.1.5 of QBO for a number of years without issue. I have just update the plugin to the latest version 2.0.4.0 and something has changed which isn't working with my PCQO scripts. The following error is occurring when try to execute the Invoice upload command: Error executing request CODE: 2010 SEVERITY: ValidationFault MESSAGE: Request has invalid or unsupported property Property Name:Can not construct instance of com.intuit.schema.finance.v3.LineDetailTypeEnum from String value ("Service"): value not one of declared Enum instance names: [JournalEntryLineDetail,…

I'm successfully using PCQO_RqUseJSON to add Journal Entries into QBO. However, I just added a way for the script to check if the vendor was already in QBO. This works. However, afterwards, it goes back to the journal entry to be entered. When it calls PCQO_RqExecute, it now calls the Vendor Query again. I tried re-loading the session info, but it doesn't seem to clear it. Essentially: PCQO_RqNew [ Select: On; Results: ; Operation: "Query"; Entity Type: "Vendor" ] PCQO_RqAddFieldWithValue [ Select: On; Results: ; Field Name: "DisplayName"; Field Value: VENDORS::Short Name ] PCQO_RqExecute [ Select: On; Results: $result ] PCQO_RqUseJSON [ Select…