Hi,

 

I have the customer ListID in FM and wanna make sure that this customer does exist in QB. This is my approach:

PCQB_ZQuery("CustomerQueryRs/*/ListID";"Customer";"<ListID>" & $QBCustomerListID & "</ListID>";"")

Then I use "PatternCount" to search for the target ID.

Can anyone suggest any neater approach?

Edited July 30, 20187 yr by siroos12

Hi Siroos,

Using the native FM Books Connector functions, you can verify if a customer exists by executing the following functions:

 

PCQB_RqNew( "CustomerQuery" )

PCQB_RqAddFieldWithValue( "ListID" ; $QBCustomerListID )

PCQB_RqExecute

 

If the result of PCQB_RqExecute is 0, the customer exists in QuickBooks; otherwise, the customer does not exist. Using these functions ensures you don't need to worry about using a PatternCount to validate the results of the response; the plug-in will report error if the requested ListID is not found (you can further verify this by calling PCQB_SGetStatus immediately after the PCQB_RqExecute function call).

 

Hope this helps!

Chris Turner

30 minutes ago, PCIPal said:

Hi Siroos,

Using the native FM Books Connector functions, you can verify if a customer exists by executing the following functions:

 

PCQB_RqNew( "CustomerQuery" )

PCQB_RqAddFieldWithValue( "ListID" ; $QBCustomerListID )

PCQB_RqExecute

 

If the result of PCQB_RqExecute is 0, the customer exists in QuickBooks; otherwise, the customer does not exist. Using these functions ensures you don't need to worry about using a PatternCount to validate the results of the response; the plug-in will report error if the requested ListID is not found (you can further verify this by calling PCQB_SGetStatus immediately after the PCQB_RqExecute function call).

 

Hope this helps!

Chris Turner

Awesome, Thank you!