Archive for October, 2026



Reading “AS OF” inventory values from IQMS

Friday 9 October 2026 @ 2:54 pm

I recently worked on a project that involved the IQMS database. We needed to incorporate inventory quantities from both the beginning and the end of a selected period into a report. Normally this requires working backward from current values based on recent transactions. But IQMS has a table called C_ARINVT_AS_OF which can store inventory values as of a specific date. The records are generated whenever you run an an inventory “As Of” report in IQMS.

So the plan was to run this inventory report twice, once for period begin and once for period end, just before running our new report. The new report would then find the appropriate records and incorporate them. But, what we found was that each time we ran the “As Of” report, it would remove the records from the last run. Even though I saw older records in the table, running that inventory report would only ever leave the latest set of records.

It took me a while to notice that all the older records that were still in the table were generated by different IQMS user names. Apparently, this table only stores one “AS OF” date per user. When we had one user generate the beginning date and a different user generate the end date, both sets of records were available in the table. So now the plan is to have separate users run the inventory report for the different dates, and then both data sets will exist for the report to use.

I love a good puzzle, so call me with your reporting challenge.





Recrystallize Pro