Author Topic: When sending a Quote to an invoice line it turns into a ?  (Read 5600 times)

Scott Toland

  • Member
  • *
  • Posts: 21
When sending a Quote to an invoice line it turns into a ?
« on: January 26, 2012, 12:50:32 PM »
If there is a Quote (") in filemaker field that is being sent to an invoice line (Desc) in QB, that Quote (") turns into a (?).  Any way to stop it from turning it into a (?) in QB?


Also, how do I force a carriage return in the invoice line in QB without having any trailing text?  I have to put in a (.) or some other text following the return in order for it to show in QB.

Thanks,

Scott

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #1 on: January 26, 2012, 01:31:36 PM »
To handle the Quote character, wrap the field in the format function like this:

PCQB_SFormatString( TO:field ; "STRTYPE" )

Can't answer the trailing return question, which sounds like a QB display issue. The work-around you've identified may be your best option.


HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

Scott Toland

  • Member
  • *
  • Posts: 21
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #2 on: January 26, 2012, 03:08:43 PM »
Now what shows is (") instead of the (?).

Thanks for your help!  Any other clues to solve this one?

Scott

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #3 on: January 26, 2012, 04:04:44 PM »
That's what shows in QB???

What version of QB & what version of FMBooks Connector are you using?

The PCQB_SFormatString function converts relevant characters into an escaped ("web safe") equivalent, with " being the escaped equivalent of a quotation mark. QB should convert each back into the original "unescaped" text character.

Curious....


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

Scott Toland

  • Member
  • *
  • Posts: 21
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #4 on: January 26, 2012, 06:13:53 PM »
The plugin is 3 and QB is 10.

Thanks,

Scott

Scott Toland

  • Member
  • *
  • Posts: 21
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #5 on: January 26, 2012, 06:19:25 PM »
Sorry, forgot to answer your first question.  Yes that is what shows in QB.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #6 on: January 27, 2012, 09:06:19 AM »
There are several iterations of the plug-in--is yours the latest?

In QB, hit the F2 function key to call up an info screen. The Product Info line will tell you which release you're on--R13, for example. Have you applied all the updates?

Which version of Windows, and which Service Packs (SP) have been applied?

Have you run the MSXML and QBXMLRP2 installers? If not, log out of FMP & QB, run those, log back in and see if the problem persists.

If it does, and your software is all up-to-date, the only remaining suggestion I can offer is that you call Productive Computing Tech Support. I hope you'll post a follow-up here once the problem's solved, 'cause I've never seen this issue and now I'm really curious about its cause.


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

Scott Toland

  • Member
  • *
  • Posts: 21
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #7 on: January 31, 2012, 10:11:49 AM »
Hi Geoffrey,

QB is 10 Release 12P, The Plugin says it is 3.0.0.5 dont know if this is uptodate.

Windows XP Pro. Service Pack 3

Have not run MSXML or QBXMLRP2.  Will run and let you know.

Thanks,

Scott

Scott Toland

  • Member
  • *
  • Posts: 21
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #8 on: January 31, 2012, 01:49:11 PM »
Hi Geoffrey,

Even after installing QBXMLRP2 (MSXML wouldnt let me install since my version is newer then the install) it still enters """ for any quote passed thru plugin to QB.

FYI,

Thanks,

Scott

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #9 on: January 31, 2012, 06:08:05 PM »
That's what shows when viewing the Invoice in the QB UI? I'm asking (more explicitly this time) because QB normally returns " in the Response to FileMaker even as it displays " in its own UI.

If it's showing you " in the QB UI, it's time to call Tech Support at Productive Computing.


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

Scott Toland

  • Member
  • *
  • Posts: 21
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #10 on: February 01, 2012, 05:12:39 PM »
Hi Geoffrey,

We decided to just substitute the character to another character rather than spend the time calling productive computing, we have the same issue with the "&".

So, I just modified the scripts,  will probably only have to add a handful of substitutions to the script.

Anyhow, thanks for your help!

Scott

Scott Toland

  • Member
  • *
  • Posts: 21
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #11 on: February 22, 2012, 05:18:44 PM »
Just a followup on this, This whole problem turns out to be a problem with 'Smart Quotes' (Have I said how I dislike Smart Quotes?).  Anyhow, if I just use normal quotes they transfer fine, 'Smart Quotes' turn into '?' when posted to QB.

Talked to Support about it without any fix.

Thanks for your help!

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 468
Re: When sending a Quote to an invoice line it turns into a ?
« Reply #12 on: February 23, 2012, 12:13:06 PM »
Was tech support able to replicate the issue? I just tried it, and this...

PCQB_SFormatString ( “left right” straight" ; "STRTYPE" )

...yields this...

"left right" straight"

...which is the expected result. (Sort of--QB doesn't support “curly” quotes, so all quotes map to the "straight" quote it does support.)

Do you use FileMaker Advanced? If so, what Result is shown when you copy/paste the PCQB_SFormatString function above into a new Expression in the Data Viewer's Watch tab and click the "Evaluate Now" button?

Thanks for updating the thread with your experiences.


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852