Jump to content

Brandan

Members
  • Content Count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Brandan

  • Rank
    member

Profile Information

  • Location
    UK

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    17

Platform Environment

  • OS Platform
    Windows
  • OS Version
    Win 10, Win 2016, FM Server 17

FileMaker Partner

  • Certification
    Not Certified

Recent Profile Visitors

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

  1. Hi Fitch, Thought I'd show you a screen video because I cannot get it to work. Thanks 20190507_101951.mp4 Try again... 20190507_101951.mp4
  2. Hi Fitch, I did as you kindly explained. However, when I drag a new field onto the layout it is still the original Font and Size. The Theme is set to the new one but Style shows as default. I click on the arrow next to Default and I only get an option to save as new.
  3. Wonderful. Just to change the font default.
  4. Hi Guys In layouts when I drag a field onto the layout it always uses the same font. I cannot find a way to change the default font. So at the moment every field I drag onto the layout I have to change its font size and resize the field box. I have read through a few articles which don't seem to show the same for my Filemaker (V.17 Pro Adv). i.e. Edit, preferences, no font tab. Also, in layout don't select anything and then change the font attributes, but they are greyed out. I've looked at themes and styles but cannot make sense of it if this is where I need to look. Your advice would be greatly appreciated.
  5. Ah, wonderful. I spent hours on that XD Many Thanks
  6. Hi, I have fixed the add/update Products script but I'm back to the original issue with the error when adding Invoices to QBO specifically SalesItemLineDetails Line: 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 It seems to refer to the ItemRef value which as far as I can see is correct. I have no idea why it mentions DiscountR as I'm not trying to apply discounts to the invoice. The script is as follows: PCQO_RqAddRelatedRecord [ Select: On; Results: $$Result; Record Type: "Line" ] PCQO_RqAddFieldWithValue [ Select: On; Results: $$Result; Field Name: "Description"; Field Value: Line Items::ProdDescripOneLine ] PCQO_RqAddFieldWithValue [ Select: On; Results: $$Result; Field Name: "DetailType"; Field Value: "SalesItemLineDetail"] PCQO_RqAddFieldWithValue [ Select: On; Results: $$Result; Field Name: "Amount"; Field Value: Line Items:: ProdUnitCostRRPTotal ] PCQO_RqAddRelatedRecord [ Select: On; Results: $$Result; Record Type: "SalesItemLineDetail" ] PCQO_RqAddFieldWithValue [ Select: On; Results: $$Result; Field Name: "ItemRef::Value"; Field Value: Line Items::QBListID] PCQO_RqAddFieldWithValue [ Select: On; Results: $$Result; Field Name: "Qty"; Field Value: Line Items::Qty ] PCQO_RqAddFieldWithValue [ Select: On; Results: $$Result; Field Name: "UnitPrice"; Field Value: Line Items::ProdUnitCostRRP ] PCQO_RqAddFieldWithValue [ Select: On; Results: $$Result; Field Name: "TaxCodeRef::Value"; Field Value: "34"] PCQO_RsCloseRelatedRecord [ Select: On; Results: $$Result ] PCQO_RsCloseRelatedRecord [ Select: On; Results: $$Result ]
  7. I have come across this in the developers guide: 13) Entity Query Support Each entity has its own “Query” support, specified by the Query operation. By default, when receiving an entity query request, QuickBooks Online will return no more than 500 matching entities. When setting up query requests using the FM Books Connector Online, however, this number of entities to be returned can be specified by defining the “MaxResults” field in the request. If this is omitted, then the request will return as many entities as their are in the QBO company, or 500, whichever is less. I might have to rethink how the script will check for items and add/update them accordingly based on the QBOList_Id.
  8. What I have noticed is the total items downloaded from QBO is 499. Is there a limit somewhere ? There are 949 items in QBO.
  9. Hi Quincy, I have constructed a script copying steps from the main database. It first Pulls items down and places them into a table. It then looks up the item to see if it's in the list. In this case it is not in the list. Therefore it adds the item to QBO and requests the ListID which it does get. However, if I pull the list down again I cannot find the item I just pushed. But I can find the item in QBO products 😕 When I run a QueryItem for the item it is not found. So it doesn't seem to be finding the item when I run a query which explains why the rest of my scripting for uploading an invoice fails. Here is the script I constructed for testing: Many Thanks Test script.pdf
  10. I have narrowed it down to Product Item ID not being pulling from QBO. I can add products to QBO and get the Item ID, they appear in QBO but when I execute the script to pull all items down into FM the recently pushed item is not pulled down. Script for Getting Items: This does pull in items from QBO but as I mentioned the new item is not in the list. Here is the script to Add or Update Items:
  11. 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 miss out a few 'need to know' values for me to cross check. This is what I have currently: Hoping something jumps out at someone. It seems to not like the ItemRef::Value which maybe a hint to the issue which I've spent all evening trying to work out. But then again I haven't needed to look at it for over three years XD. If you require more info please let me know. Many Thanks.
  12. I found the problem ! It was this line: Set Variable [ $$Result ; Value:PCQO_RqAddFieldWithValue( "DetailType" ; "Service" ) ] Needs to be: Set Variable [ $$Result ; Value:PCQO_RqAddFieldWithValue( "DetailType" ; "SalesItemLineDetail" ) ] Looks like 'Service' no longer works. I'm very happy
  13. 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, DepositLineDetail, SalesItemLineDetail, PurchaseOrderItemLineDetail, DiscountLineDetail, TDSLineDetail, SubTotalLineDetail, ItemReceiptLineDetail, PaymentLineDetail, TaxLineDetail, AccountBasedExpenseLineDetail, SalesOrderItemLineDetail, ItemBasedExpenseLineDetail, GroupLineDetail, DescriptionOnly] specified is unsupported or invalid SOURCE: PCQO_RqExecute Running Debugger stops at the Execute invoice upload line with the above error, and as the error states. I have been through the Demo file to try and see if there are any new commands, or to see if any of the PCQO_ commands have changed. But unable to find any differences. I have attached a PDF of the script I think is failing. If anyone can see where my script is incompatible with the new plugin I would be eternally greatful. Many Thanks, Brandan Script.pdf
×
×
  • Create New...

Important Information

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