Productive Computing, Inc. Support Forum

Plug-ins => FM Books Connector => Topic started by: Jeeva@livesmicropoint.com on October 08, 2013, 09:47:39 PM

Title: Amount Return Problem
Post by: Jeeva@livesmicropoint.com on October 08, 2013, 09:47:39 PM
Hi,

While i pull amount from invoice it showing my amount as for example 11880. But the real output is 118.80.

I m uisng UK edition.

Let me know how to solve this.

Thanks in advance.

Jeeva
Title: Re: Amount Return Problem
Post by: Geoffrey Gerhard on October 09, 2013, 06:32:24 AM
After you've run your Invoice Query Request, go to your data viewer and evaluate this expression:

PCQB_SGetXML( "Response" ; "" )

and post the result here. The raw XML will show us what QB returns for the Amount value. In my experience, which includes multiple UK and Australian edition Company files, an Amount value always includes at least one integer digit, a decimal, and exactly two decimal digits.

That said, I wonder if it's a preference issue. Is the "Automatically place decimal point" preference (Preferences>General>My Preferences) enabled for this Company file?


HTH!

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