Author Topic: Quickbooks SP Report: "Purchase by Item Detail"  (Read 1996 times)

sbenschwartz

  • Member
  • *
  • Posts: 2
Quickbooks SP Report: "Purchase by Item Detail"
« on: May 06, 2011, 02:38:14 PM »
Can I access Quickbooks' SP reports?  I specifically want to access the "Purchase by Item Detail" report which is a standard (canned) QB report accessible outside QB as an SP.  Is this report accessible via FM Books Connector.  If so, how?  Thank you.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Quickbooks SP Report: "Purchase by Item Detail"
« Reply #1 on: May 10, 2011, 06:40:51 AM »
I'm not sure what an SP report is, but I you can extract all the Purchase by Item Detail report data using FM Books Connector. Create a General Detail Report Query using "PurchaseByItemDetail" as the value of the GeneralDetailReportType element. Parsing specific data from the Query's result may be challenging, but it's possible using both XPATH and FileMaker's native string manipulation functions. Good luck!

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