Productive Computing, Inc. Support Forum

Plug-ins => FM Books Connector => Topic started by: sbenschwartz on May 06, 2011, 02:38:14 PM

Title: Quickbooks SP Report: "Purchase by Item Detail"
Post by: sbenschwartz 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.
Title: Re: Quickbooks SP Report: "Purchase by Item Detail"
Post by: Geoffrey Gerhard 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