[Crystal Reports] Inventory stock date query

[monstertool]

I'm building a Crystal report that returns inventory stock status for a specific date or range of dates. The problem I'm having is finding the necessary field(s) and formula to do this. I can get it to return current inventory but not for a specific date in the past. Any thoughts?

TIA

[gibbo]

QuickBooks would only hold a single value for the SOH. The figure would be updated with Purchases and Sales. The only way you could do this, I think, is to have an opening SOH figure at a point, then to do your own additions for Purchases and deductions for Sales. This opening SOH would have to be held outside QuickBooks.

[rusty3200]

Using Intuits Sofware Development Kit (SDK) you can query for the Inventory Valuation Summary Report as of any date. Most likely whatever Crystal is working against (QODBC or ??) is SDK based and may have this capability.

[monstertool]

Thanks for the info.

Crystal uses QODBC to query the QuckBooks db. The real issue for me is finding the proper field(s) and formula to pull the data I need (inventory as of a specific date).

[rusty3200]

Check with QODBC and see if they can get the Inventory Valuation Summary report.

[monstertool]

Okay...I'll try that.

Thanks!