Plug-ins > FM Books Connector Online

Push Custom Field into QBO

(1/1)

Veselko:
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.

Veselko:
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: ---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]

--- End code ---

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.

Veselko:
Find attached solution for one custom field.

Cheers

Navigation

[0] Message Index

Go to full version