From written request to finished report

Pookin AI turns data in ERP and enterprise software into a report based on a written request. No query writing or report design is required.

New request Logo Tiger 3

Show items that have been in stock for more than 90 days by warehouse. Calculate the capital tied up.

Stock older than 90 days, by warehouse

Sample data
Capital tied up₺4,6 Mn
Items212

Structure of a report

  1. Request

    A report starts with a written request. Period, breakdown and comparison are stated in the request.

  2. Indicators

    Key indicators summarize the request. The previous period value is shown alongside.

  3. Chart

    Breakdowns are presented as a chart. The chart type follows the structure of the data.

  4. Table

    Detail rows appear in the table. The table can be exported to Excel.

  5. Commentary

    Notable values are summarized in a short commentary.

  6. Source

    Every report shows the source read and the row count. Figures are traceable to their source.

app.pookin.ai Türkiye region

Reports / Inventory

Stock older than 90 days, by warehouse

Show items that have been in stock for more than 90 days by warehouse. Calculate the capital tied up.

Capital tied up₺4,6 MnLast month ₺4,3 Mn
Items212Last month 198
Average holding period134 günLast month 129 gün
By holding period, ₺M 90–120 days120–180 daysOver 180 days
  • Gebze2,1
  • İzmir1,4
  • Ankara0,7
  • Adana0,4
ItemWarehouseDaysAmount, ₺
Aluminium profile 40×40Gebze214412.600
Epoxy resin 25 kgİzmir188356.900
Steel sheet 2 mmGebze167298.400
Copper wire 1.5 mmAnkara143241.750
Corrugated box 60×40Adana126187.300

Almost half of the tied-up capital is in the Gebze warehouse. Two items account for most of the stock older than 180 days.

Source: Logo Tiger 3, stock movements and item cards. 9,874 rows read.Sample data

Integration with existing systems

Pookin AI connects to data sources in read-only mode. No record changes in the source system.

ERP

LTLogo Tiger LNLogo Netsis MKMikro SAPSAP Business One

Databases

MSMicrosoft SQL Server PGPostgreSQL MYMySQL OROracle Database FBFirebird

Other sources

{ }Custom software ⇄Web services XLExcel and CSV

Read-only connection: no records are added, changed or deleted.

Company terms are defined

Company-specific terms are mapped to tables and fields during setup. Requests are written using these terms.

    Sample mapping

    Report outputs

    Reports are traceable to their source, can be scheduled and exported.

    Traceable to source

    Every figure is traceable to the table and row it comes from.

    1. IndicatorCapital tied up₺4,6 Mn
    2. BreakdownGebze warehouse₺2,1 Mn
    3. RowAluminium profile 40×40₺412.600
    4. Source tableLogo Tiger 3, stock movements

    Scheduled reports

    The report is regenerated on the defined day and time.

    PDF and Excel

    The report is exported as PDF or Excel.

    Saved reports

    Frequently used reports are kept in the saved reports list.

    Access is limited by role

    Users query only the data they are authorized for. Every query is written to the audit log.

    Data security details

    Product questions

    Is query knowledge required to get a report?

    No. Requests are written in natural language. Turkish, English and German are supported.

    How are company-specific terms recognized?

    Terms are mapped to tables and fields during setup. Mappings are kept in the company glossary.

    Can different sources be combined in one report?

    Yes. Data from multiple data sources is combined in a single report.

    In which formats is a report available?

    The report is displayed on screen, exported as PDF or Excel, or scheduled.

    Can the source of the figures be viewed?

    Yes. Every report shows the tables and filters used. Figures are traceable to their source.

    Are systems not on the list supported?

    Yes. A custom integration is developed for systems that are not listed.

    Request a live demo

    The demo is prepared with your own data.