Author Topic: Amount Return Problem  (Read 1048 times)

  • Member
  • *
  • Posts: 4
Amount Return Problem
« on: October 08, 2013, 09:47:39 PM »

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.


Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Amount Return Problem
« Reply #1 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?


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