Not directly crystal related but maybe some help could be provided. Data extraction for reports

I need to find which tables Item  Qty on hand and item cost are . Using Access ODBC, and need to extract Inventory Stock status data for connecting to Power BI. Any help?

  • 0
    Hi pmendoza, Item Cost can be found here >> "InventoryCosts"."TransAmount". QOH is a bit more tricky. When writing with crystal, you can use a GetPeach command, that was written long ago with C++ and is not native to a table.field. Now with Sage Intel, you can extract it from the Inventory Analysis container. Dave