Productive Computing, Inc. Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

SMF - Just Installed!

Pages: [1]   Go Down

Author Topic: Push Custom Field into QBO  (Read 536 times)

Veselko

  • Member
  • *
  • Posts: 9
Push Custom Field into QBO
« on: March 07, 2017, 03:28:53 AM »

Hi all,

I have one Custom Field for every Transaction (not line item), which I want to fill with data from FileMaker; some simply number field which tells me more about transaction.

So, in "Push Invoice to QBO" script, I put lines:


PCQO_RqAddRelatedRecord( "Trip Number" )
PCQO_RqAddFieldWithValue( "Trip Number::value" ;"123" ),

where "Trip Number" is name of my CustomFiled.



Those lines are not enough, or they are completely wrong.

In Result I'm getting:
--------------------
"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.TxnTaxDetail), not marked as ignorable (4 known properties: "DefaultTaxCodeRef", "TxnTaxCodeRef", "TotalTax", "TaxLine"])
  specified is unsupported or invalid

SOURCE: PCQO_RqExecute"
--------------------


When I remove those lines, it works perfect; but I want to be able to push that info into Invoice too.


Can someone, point me into right directions?

Thank you in advance.
« Last Edit: April 25, 2017, 01:52:15 AM by Veselko »
Logged

Veselko

  • Member
  • *
  • Posts: 9
Re: Push Custom Field into QBO
« Reply #1 on: March 15, 2017, 09:04:00 AM »

Hello again,

Following "Developers_Guide_FMBooksOnline" I figured out that "Settinng values for CustomField   objects is accomplished   with adding   the CustomField object as a related record."
 So I put in "Push Invoice to QBO" script following lines:

Code: [Select]
Set Variable[$$Result; Value: PCQO_RqAddRelatedRecord( "CustomField" )]
Set Variable[$$Result; Value: PCQO_RqAddFieldWithValue( "DefinitionId" ;"1" )]
Set Variable[$$Result; Value: PCQO_RqAddFieldWithValue( "Name" ;"Trip Number" )]
Set Variable[$$Result; Value: PCQO_RqAddFieldWithValue( "Type" ;"StringType" )]
Set Variable[$$Result; Value: PCQO_RqAddFieldWithValue( "StringValue" ; "1234" )]
Set Variable[$$Result; Value: PCQO_RqCloseRelatedRecord]

I get Erroor messages:


------------------

Error executing request

CODE: 2010
SEVERITY: ValidationFault

MESSAGE: Request has invalid or unsupported property

Property Name:Unrecognized field "stringvalue" (class com.intuit.schema.finance.v3.CustomField), not marked as ignorable (7 known properties: "StringValue", "D specified is unsupported or invalid

SOURCE: PCQO_RqExecute
------------------

Can someone help me, how to avoid this situation?

Thank you in advance.
Logged

Veselko

  • Member
  • *
  • Posts: 9
Re: Push Custom Field into QBO
« Reply #2 on: April 27, 2017, 05:14:37 AM »

Find attached solution for one custom field.

Cheers

Logged
Pages: [1]   Go Up